SAP connection
We need to fill following parameter in order to connect BW on component tSAPConnection. Default context is already created for all BW systems.
The user to connect must be RFC_TAL_WBP, which is the RFC user for Talend (DE team). It already save in global context g_CNX_SAP_WBP
| Variable | SBX | DEV | QAS | PRE | PRD |
|---|---|---|---|---|---|
| sapClient | 400 | 110 | 400 | 400 | 400 |
| sapUser | RFC_TAL_WBP | RFC_TAL_WBP | RFC_TAL_WBP | RFC_TAL_WBP | RFC_TAL_WBP |
| sapHost | wb1.eua.solvay.com | wbd.eua.solvay.com | wbq.eua.solvay.com | wbv.eua.solvay.com | wbp.eua.solvay.com |
| sapSystemNumber | 20 | 48 | 32 | 85 | 00 |
| sapUserPwd | get it from Keepass |
To run the test, DE can select the system that you want to run, it will automatically connect to that system and get the result
RFC Connection
It is required when FTP-Batch is used. This is require when we load a huge volume of data (more than 10,000 records), it is required to split the data and temporary save to the folder. To connect to RFC, we can use QAS folder to keep the file
It also already save in global context g_CNX_FTP_BW
| Variable | Value |
|---|---|
| ftpHost | wbq.eua.solvay.com |
| ftpFolder | /exploit/BW/test |
| ftpPort | 22 |
| ftpUser | sftpbw |
| ftpPwd | get it from Keepass |
This function is available only some component
GCP Connection
| Variable | Meaning |
|---|---|
| l_VAR_GCS_CSV_TO_STAGING_BUCKETNAME | Bucket Name in GCS |
| l_VAR_FOLDER | Local path |
| l_VAR_FILE | Local filename |
| l_VAR_LIMITROW | Limit number of row per file. Required only tSAPTableInput |
| l_PATHDIR_GCS_CSV_TO_STAGING_SERVICE_ACCOUNT_PATH | Location path and file of service account (JSON file) |
More detail how to get GCP service account
Component to Connect BW
OBJECT | Talend component | COMMENT |
|---|---|---|
tSAPTableInput | Delta No Filter Yes FTP-Batch Yes | |
tSAPInfoobjectInput | Delta No Filter No (with text better use SAP table) FTP-Batch No | |
(old model) | tSAPDSOInput | Delta No Filter Yes FTP-Batch Yes |
(old model) | tSAPCubeInput | Delta No Filter Yes FTP-Batch Yes |
tSAPADSOInput | Delta Yes Filter Yes FTP-Batch No | |
tSAPCubeInput | Delta No Filter Yes FTP-Batch Yes | |
Composite Provider | tSAPADSOInput | Delta Yes Filter Yes FTP-Batch No |
BW Queries | tHttpRequest is used for Xtract | The best solution for query is Xtract and use tHttpRequest |
1. SAP Table
It is the same as ECC SAP Table just to connect to BW
2 InfoObject (Master data)
Although Talend has the component to get data from infoObject but it is better to get it from table since the tSAPInfoobjectInput can't have filter and there is no FTP batch or load by starting row like tSAPTableInput. Therefore, it is better to use tSAPTableInput