...
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 | |||
SplitFilesChunckSize | Chunck size to split the Details, Buildups, and BuildupDescriptions file to multiple files by a number of entities. 0 - default. Output 1 file | RFC & HANA | 0, 10000, 1000000 |
Complex connection properties (HANA connection only)
...
Command for versions < 1.2.5
./DataLineage.cmd extract-all -s <SID> -h <HANA Schema>
Plan a regular job
In most scenarios, it makes sense to pull the metadata of a system regularly. A recurring job should be created for this purpose. This chapter describes how to do it in Windows and Unix environments.
Note that this only works from versions > 1.4.0.
Windows
Open the Task Scheduler in Windows
Right Click > Create a task
In the general tab, you can give the task a name and should choose the second option “Execute independently of the user login”. You can also change the user here
In the tab Trigger, you have to set the interval in which the task should be scheduled
In the tab Actions, you have to insert the command which should be run.
