Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

The SQL Port of your HANA DB.
Normally the SQL Port is 3<instance number>13.
To figure out the SQL Port use this guide or visit the SAP help for more information.

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" ], ["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.

Password

Password of the user for the BW Data Lineage API
(info) The password shouldn’t contain “EncryptedPassword

The password must be set via command line (see here). In that case a property EncryptedPassword is stored in the appsettings.json file. If you need to use a clear password, please use the connection string.

Complex connection properties

...

Example of ConnectionString:

...

Info

If you do not insert a password in the connection string you can also set an encrypted password via command line (see here).

Set Password

The following command in the command line sets a encrypted password into the appsettings.json file.

Windows

Code Block
languagepy
DataLineage.cmd set-password -s <SID> -h <HANA Schema> -p <password>

Unix

Code Block
languagepy
./DataLineage.sh set-password -s <SID> -h <HANA Schema> -p <password>

Run Application

The BW Data Lineage API can be started for one system.
To find all parameters you can use, try --help to get more information.
The following command are examples only. The full command list can be found here.

Windows

Run the application with the following command

Code Block
languagepy
DataLineage.cmd extract-all -s <SID> -h <HANA Schema>

Unix

Run the application from terminal

Code Block
languagepy
./DataLineage.sh extract-all -s <SID> -h <HANA Schema>

Plan a regular job

Windows

Unix