By default the required driver for connection to multidimensional databases based on Microsoft Analysis Services is already installed in Windows OS. The updated driver version can be installed with the Microsoft SQL Server (Native Client) front end.
To create connection to Microsoft Analysis Services, follow the steps:
In the object navigator select the Other > ADOMD Catalog button in the New Object button drop-down menu on the Home ribbon tab or the Create > Other > ADOMD Catalog item in the object navigator context menu.
If required, change name and identifier of created object. Click the Next button to go to the Parameters wizard page.
Select the Analysis Services driver, in the Server field determine IP address or the server name. To connect, determine user authentication method, if required, determine user name and password. Click the Check Connection button. After the successful connection, in the Name drop-down list select the multidimensional database, according to its contents the required objects will be created in repository. Click the Finish button.
For the ADOMD catalog created in repository, select the Refresh context menu item. Wait for the Prognoz Platform 9, basing on metadata from server, creates all required objects - ADOMD dictionaries and ADOMD cubes:
See also: