...
If you want a license for the BW Data Lineage Metadata API we need the SID of your BW system and the HANA schema in which the BW application is stored.
Requirements
.
Requirements
| Info |
|---|
Two possibilities to connect There are two ways how the BW Data Lineage API can connect to your system.
You can decide how you want to connect. For the RFC approach you need to install a Function Module in your development system and transport it through your landscape (more is describes here). |
The BW Data Lineage Metadata API can be started from any machine (Windows or Unix) which has access to your SAP BW System or the underlying SAP HANA database.
A HANA database user is needed who has full select rights on the HANA schema on which the BW application is storedDepending on the approach you have chosen, you will need a HANA or a BW user. Which rights are needed is described here.
Installation
Windows
Download the latest version of the BW Data Lineage Metadata API and unzip it. Open the terminal or command line to work with the tool.
...
To maintain the connection data you have to change the appsettings.json file.
See below how it might look like. Per default the appsettings.json file is empty, but the two connection possibilities are shown (see below).
...
If you decided on the RFC connection you use the properties below BwSystemConfiguations. If you decided on the HANA SQL connection you use the properties below HanaSystemConfiguations.
It can contain multiple systems depending on what is maintained in our license (see below what it might look like).
...
Explaining the properties:
Property | Meaning | Connection | Example | ||
|---|---|---|---|---|---|
BwSid | The System ID of your BW system | RFC & HANA | BI2, A4H, ..… | ||
Server | The host or IP address of your HANA database | RFC & HANA | hdb.mycompany.de | ||
SystemNumber | The system number of the BW system | RFC | 00, 03, … | ||
Client | The client of the BW system | RFC | 001, 800, … | ||
Prefix | The prefix of the function module for the RFC connection | RFC | Z_, /MYCOMP/Z_, … | ||
Database | The database on your HANA tenant where the BW application is located | HANA | HN2, HDB, SYSTEMDB, … | ||
HanaSchema | The schema where the BW application is located | HANA | SAPBI, SAPA4H, SAPHANADB, … | ||
SqlPort | The SQL Port of your HANA DB. | HANA | 30213 | ||
UseSsl | If you have set up and want to use an SSL connection to your HANA database. | HANA | true, false | ||
Languages | List of Languages you want to export | RFC & HANA | [ "E", "D" ], [ "E" ], ["D", "C", "F"] | ||
User | User for the BW Data Lineage API. The user needs full select rights on the HANA schema of the BW system. | RFC & HANA | |||
EncryptedPassword |
| RFC & HANA |
Complex connection properties (HANA connection only)
Instead of using the delivered content of the appsettings.json file, you can use a connection string if you need to set more properties for your HANA database. That is important if you use e.g. proxy servers and users.
...