Versions Compared

Key

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

...

Code Block
languagexml
{
  "BwErpSystemConfigurations": [
    {
      "BwErpSid": "",
      "Languages": [ "", "" ],
      "Server": "",
      "SystemNumber": "",
      "Client": "",
      "User": "",
      "Prefix": ""
    }
  ],
 
  "HanaSystemConfigurations": [
    {
      "BwErpSid": "",
      "HanaSchema": "",
      "SchemaBlacklist": [ "", "" ],
      "Languages": [ "", "" ],
      "Server": "",
      "Database": "",
      "SqlPort": "0",
      "UseSsl": "false",
      "User": "",
      "ConnectionString": ""
    }
  ],
  
  "SacSystemConfigurations": [
    {     
      "Url": "",
      "TokenUrl": "",
      "ClientId": "",
      "ExcludePrivateObjects": false
    }
  ]
}

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.

...

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

since v1.4.0 you can run the Metadata API without installing a function module. In that case you do not have to set it in appsettings file (more infos here).

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, …

HanaSchemaBlacklist

Schemas which should not be analyzed during the process of getting metadata from HANA. It totally make sense to restrict it via the list at least for some technical SAP schemas.

HANA

["_SYS_AFL", "_SYS_AUDIT", "_SYS_BI", "_SYS_BIC"]

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.

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

Note

No manual input. 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.

RFC & HANA

Url

URL of the SAC instance

SAC

https://mysacinstance.eu10.hcs.cloud.sap

TokenUrl

Token URL of the SAC instance

SAC

https://mysacinstance.authentication.eu10.hana.ondemand.com/oauth/token

ClientId

Client ID for the OAuth Authentication in SAC

SAC

EncryptedSecret

Note

No manual input. The secret must be set with the first start of the API for SAC.

SAC

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

...