Foresight Analytics Platform allows for setting up communication with various SAP products and platforms. The general integration scheme looks as follows:
Connection to SAP NetWeaver BW and SAP HANA can be set up directly from the 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 ensure effective work with the selected database, the one should install a driver 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.
The operations that are required to set up connection are described 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, one should develop an additional user application, which will execute all required operations for connection, extraction and loading data to Foresight Analytics Platform tools. Work with RFC functions is available in the Python language and requires the presence of the PyRFC library. To work with the Python language 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 first execute integration.
See also:
Connecting to External Databases | IAdoMdCatalog