Alias types

You can create these types of database alias:

Infor BI OLAP Provider

Driver: Select XMLA.

In Alea ad-hoc reports and Alea formula reports a native (non-odbo) connection is automatically used when you connect with XMLA.

ODBO is not supported by OLAP Server 11.

Microsoft Analysis Services

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 in detail at .

If required, in the Specific provider version field, of the Advanced tab, select a specific driver to use.

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]