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:
Data of other SAP products can be accessed by calling RFC functions or by means of interaction via the SOAP protocol 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. Work with RFC functions is available in the Python language and requires the presence of the PyRFC library. To work with the Python in the platform, one can use Python modules or call the functions implemented in external Python files using the Python.Invoke method in the Fore language.
NOTE. To work with the Python language in Foresight Analytics Platform, one should firstly execute integration.
See also:
Connecting to External Databases | IAdoMdCatalog