To connect to multidimensional databases in the repository, there is a specific object - the ADOMD directory. It supports connection to databases that are created on the basis of:
Microsoft Analysis Services.
SAP NetWeaver BW.
SAP HANA.
Other multidimensional sources to connect to which the drivers are installed in the operating system.
Structure of data sources used in this software is similar to structure of the Prognoz Platform 9 cubes.
NOTE. Creating an ADOMD catalog is available only in the desktop application. To succeed a work with selected database, the installed driver is required in the operating system of the computer used for connection.
An ADOMD catalog is a container where, after connection, cubes and dimensions are created reflecting multidimensional sources stored on the multidimensional database server. After connection the catalog gets metadata of the server objects and creates their analogs in the repository: ADOMD dictionaries and ADOMD cubes. If source cubes use variables, parameters are created to manage values of these variables in the ADOMD cubes. The working order and parameter settings depend on the variables settings in use.
It is available to access data of source objects via objects created in the ADOMD catalog. ADOMD catalog executes all operations required to create and run MDX queries used on working with multidimensional data sources.
The next subsections contain description of connection to various time series databases:
NOTE. If due to any reason sources metadata could not be read via ADOMD during catalog refresh, for example, the sources used calculations not supported in ADOMD, such sources are not added to the catalog. A message is displayed with a list of skipped sources and errors text.
Objects created in ADOMD catalog can be used in various Prognoz Platform 9 tools: Dashboards, Analytical Queries (OLAP), Reports. Modified data can be saved to ADOMD catalog if the current provider supports data update using MDX queries.
See also: