You can create these types of database alias.
- Infor BI OLAP Provider
- Driver: Select XMLA or Native (non-ODBO). Native connections to OLAP 10.1 support
Unicode. ODBO is not supported by OLAP Server 10.3.0 and later.
Note: You can create an OLAP relational alias by copying an OLAP alias that uses the XMLA
driver. In the Database Structure pane, right-click the OLAP XMLA alias and select .
- Microsoft Analysis Services
- The version of Analysis Services is detected and the most recent ODBO driver is used.
- To use XMLA with Microsoft Analysis Services, XMLA must be enabled on the server.
Specify the server name as
http://[server_name]
.
- Enabling XMLA on a server is a manual process.
- The process is described at It is described in detail at .
- If required, in the Specific provider version field, of the Advanced tab, select a specific driver to use.
- Infor BI DataLink Provider
- DataLink Server provides connectivity to multiple systems through DataLinks. The Q&A 10 driver provides connectivity to Infor Q&A 10 sources. Select the DataLink Server or Q&A 10 driver as appropriate. In the Server field, specify the URL of the server on which Infor BI DataLink Server or Infor Q&A 10 is installed and configured.
- We recommend that you do not specify 'localhost' as the server name, particularly
if DataLink Server is not running on the same server as Application Studio.
- Infor CPM Relational Provider
- You access these databases through a webserver.
- In the New Database Alias dialog, select in the Driver list.
- Specify the URL of the data source in the Server name field. The syntax of the URL is:
-
http://server_name/web_application_name/service_host_instance_name
.
- For example:
http://my_machine/xmlawebservice/xmlawebservice.svc
Note: The service host instance name is optional.
- Select a database from the Database list.
- Previous versions supported DS Connector connections. The order of the dimensions
in a cube varies between DS Connector and XMLA connections. This can affect formulas
if, for example, you migrate from DS Connector to XMLA.
- To retain the existing order of dimensions when changing from DS Connector to XMLA:
- Click the Advanced tab.
- Select , in the DS Connector compatibility field.
- By default, compatibility is not selected for new database aliases.
- EXASolution Provider
- This alias type provides an XMLA connection to an EXASolution database. Specify the
server name as
http://[server_name]
.
- Essbase XML for Analysis Provider
- This alias type provides an XMLA connection to an Essbase database. Specify the server
name as
http://[server_name]
- Relational Provider
- Relational Provider: Connects to a relational database using ODBC, OLE DB, OLAP, or
a custom connection string. For ODBC connections, there must be a DSN for the data
source.
- The OLAP driver connects to an OLAP Server database but returns a relational result. You can use this, for example, to return
elements from multiple dimensions in a single hyperblock.
Note: You can create an OLAP relational alias by copying an OLAP alias that uses the XMLA
driver. In the Database Structure pane, right-click the OLAP XMLA alias and select .
- For OLAP connections, use this syntax to specify the database in the Database field:
-
<server name>/<db name>
. For OLE DB connections, specify the database name.