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.
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.
The object that is used for connection - ADOMD Catalog.
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.
Description of operations, that are required to set up connection, is given in the following subsections:
Data access of other SAP products is available via RFC function call or via SOAP communication in web application. To do it, it will be required to develop an additional user application which will perform all required operations for extraction, transformation and loading data to Foresight Analytics Platform tools.
See also: