Database alias types

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 Create Relational OLAP Alias.
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 XMLA 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:
  1. Click the Advanced tab.
  2. Select Yes, 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 Create Relational OLAP Alias.
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.
Related topics