Creating a database alias
Database aliases are saved in the Repository.
To create a database alias:
- Click the root of the Database Structure.
- Click New Database Alias.
- Specify a name and, optionally, a description.
- Select the database provider from the Provider list.
-
Select the driver to use.
The providers support ODBO and XMLA drivers. Both drivers provide the same functionality but, for ODBO, the driver must be installed on each client machine. Either driver may perform better than the other, depending on the database used and its environment. For example, ODBO might be faster with client lists, but there might be no noticeable difference.Note: ODBO is not supported by OLAP Server 10.2. but is supported by OLAP Server 10.1x.
- For XMLA connnections, in the Server field, specify the name of the machine on which the database is located, or its URL (depending on database alias type).
- Select the database and click Test Connection.
-
If the connection test is successful, click
OK.
Note: For relational aliases where ODBC is selected as the driver, the DSN list replaces the Server field. Select the database source name.
-
Click the
Authentication tab.
In the User Information section, you can select the authentication system.Note: The authentication system depends on the database provider selected. It is independent of the authentication used to connect to the Repository.
-
In the Authentication list box, specify this information:
- Existing connection
- Log on to the database alias with the same credentials you
use to log on to
Application Studio.
The
User name
and
Password fields are disabled.
Existing Connection works for:
- Infor CPM Relational Provider aliases only if the existing connection to the Repository is made through CPM Applications authentication.
- OLAP Server aliases, regardless of the repository authentication.
- Basic
- Enter a user name and password.
- Windows
- The log-on data of the Windows account is used. The User name and Password fields are disabled.
- Kerberos
- The log-on data of the Windows account is used. The Kerberos protocol authenticates the user. The User name and Password fields are disabled.
- HTTP
- A specified user name and password is used for authentication. Authentication is through the HTTP protocol.
Note: The options of the dialog vary according to the provider and authentication system selected. -
Select
Connect at log-on to
connect to the database alias when you log on to
Application Studio.
You can specify that no connection to the database alias can be made unless the Event Agent is in one of these states:
Status Explanation Any: The connection is made independently of the status of the Event Agent. Running: The connection is only made when the Event Agent is running. >=Paused: The connection is made when the Event Agent is paused, stopped or disabled. >=Stopped: The connection is made when the Event Agent is stopped or disabled. Disabled The connection is made only when the Event Agent is disabled. -
Click the
Advanced tab.
Here you set the connection time-out and command time-out commands. Any properties of the connection string used can be added in User-defined properties. Different alias types display different fields on the Advanced tab.
-
Specify this information:
- Unique name style
- The algorithm used by Analysis Services for generating unique names can make them unstable after some time. You can specify which algorithm is used to generate unique names:
- Display description or name in Infor CPM Relational Provider database aliases
- You can specify whether an Infor CPM Relational Provider alias displays descriptions or names of elements.
- Add one of these strings to the user-defined properties of the alias:
-
captions=descriptions;
-
captions=names;
- Measure dimension in Infor CPM Relational Provider database aliases
- To specify which dimension is used as the Measure dimension, specify the name of the dimension in the Measure dimension field.
- Display placeholder element
- This determines how missing elements in ragged and unbalanced hierarchies are treated.
-
Value Description 0 Default. Currently the same as Value 1. 1 Placeholder elements are exposed. 2 Placeholder elements are not exposed. See http://msdn2.microsoft.com/en-us/library/aa256070(SQL.80).aspx - Run location
- Determines whether queries are executed on the client or server.
- Language ID (LCID)
- LCID is supported only by Infor BI OLAP Server and MS Analysis Services database aliases. LCID sets the preferred Locale ID for the client application.
- Infor BI OLAP Server database aliases support language cultures (e.g. English) and sub-cultures (e.g. English (USA)). To specify a culture or sub-culture, specify the appropriate code in the Language ID field. For example, specify 09 as the Language Id for English or 1033 for English (USA).
- Microsoft Analysis Services database aliases accept both culture and sub-culture Ids, but use the sub-culture. For example, if you specify 09 (English) as the Language Id, the alias uses 1033 (English (USA)).
- If a process opens multiple connections, each must use the same LCID as the first.
- See
- The Language ID is also displayed, and can be edited, in the Properties pane of a database alias.
- To synchronize the database language with the report language, specify 0 as the LCID. In the connection string of the database alias, the LCID changes according to the report language selected in Extras > Language Settings.
- Database type
- A relational list is defined by an SQL query. You might need different versions of the same query to account for differences in the way in which different database providers implement SQL. For example, the syntax for including global variables in SQL queries differs according to database type.
- See Using variables in SQL queries.
- You can write multiple list SQL queries and store them as a single list. Select the required database type.
- See Managing database types
- Select Type indifferent if none of the relational list definitions is database-specific and queries have been written for the default type.
- See Managing database types.
- Keep connection alive
- The Keep connection alive option sends a dummy request to the
server every five minutes to prevent inactive users from being disconnected.
For OLAP connections, the option is effective if, in Database Settings in
OLAP Administration,
the specified HTTP/S session timeout is more than five minutes.
The option is not supported by these combinations of alias type and driver.
Alias Type Driver Infor BI OLAP Provider Native Infor DataLink Provider Q&A 10 DataLink Server Relational Provider ODBC OLE DB Custom