Connection to multidimensional databases based on SAP HANA requires that front end containing the required OLE DB driver is already installed. To do it, you can follow the guide from the manufacturer's site. The bitness should be the same as for the Prognoz Platform 9 version in use.
To create connection to SAP HANA, 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 SAP HANA driver, in the Server field determine IP address or the SAP HANA server name. Determine data base instance number in the Instance field . The instance number can be obtained from the SAP HANA database administrator. To connect, determine user authentication method, if required, determine user name and password.
Click the Check Connection button. If connection is successful, click the Next button to go to the Information Providers page. On this page one select catalogs or information providers, and ADOMD catalog objects are created based on their information. By default, the All element is selected, all cubes created on server are created. If required, the list of created elements can be reduced, to do this, select required catalogs or separate information providers. The list of selected elements is saved, on updating the ADOMD catalog contents the information only about selected elements is updated.
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: