License
If you want to have 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
The BW Data Lineage Metadata API can be started from any machine (windows or unix) which has access to the SAP HANA database.
A HANA database user is needed which has full select rights on the HANA schema on wihch the BW application is stored.
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.
Unix
Download the zip and start the following command
mkdir DataLineage; tar -xzf DataLineage_master_x.x.x.x_Unix.tar.gz -C DataLineage; chmod +x DataLineage/DataLineage.sh; chmod +x DataLineage/Core/DataLineage
Insert License
Maintain Connection Data
To maintain the connection data you have to change the appsettings.json file.
See below how it might look like. It can contain multiple systems depending on what is maintained in our license.
Explaining the properties:
Property | Meaning | Example |
|---|---|---|
BwSid | The System ID of your BW system | BI2, A4H, .. |
Server | The host or IP address of your HANA database | hdb.mycompany.de |
Database | The database on your HANA tenant where the BW application is located | HN2, HDB, SYSTEMDB … |
HanaSchema | The schema where the BW application is located | SAPBI, SAPA4H, SAPHANADB, … |
SqlPort |
| 30213 |
UseSsl | If you have set up and want to use an SSL connection to your HANA database. | true, false |
Languages | List of Languages you want to export | [ "E", "D" ], [ "E" ], [ "E", "D", “C” ] |
User | User for the BW Data Lineage API.
| |
Password | Password of the user for the BW Data Lineage API | |
How to find the SQL PortOther settings
Run Application
Windows
Run the application with DataLineage.exe in the command line
Unix
Provide execution rights in terminal, if needed:
chmod 777 ./BwDataLineage or
_chmod +x BwDataLineage_
Run the application with ./BWDataLineage from terminal