Foresight Analytics Platform provides a possibility to set up communication with various SAP products and platforms. General view of integration scheme looks as follows:
Connection to SAP NetWeaver BW and SAP HANA can be set up directly from repository. Structure of data sources used in this software is similar to structure of the cubes used in Foresight Analytics Platform.
The ADOMD Catalog object is used for connection.
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.
One can 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.
Description of operations, that are required to set up connection, is given in the following subsections:
Access to other SAP products data is available via RFC function call or via SOAP protocol communication in the web application. To do this, it is required to develop an additional user application which will perform all required operations for connection, extraction and loading data to Foresight Analytics Platform tools.
See also:
Connecting to External Databases | IAdoMdCatalog