SAP Connection Settings
You can change the SAP connection settings in the IT Management Console. Navigate to Models > [Model name] > Connection Settings and expand SAP connection settings to view and edit the available settings.
The following SAP connection settings can be edited:
SAP connection settings | |
|---|---|
Hostname* |
The hostname (FQDN) or IP address of the SAP system (application server or message server). |
System number* |
The SAP system number. Example: 00 |
System ID* |
The SAP system name. Example: SAP Internal use: EA2 or EA3. |
Client |
The SAP mandant. Example: 800 |
User name* |
The SAP user name, used for the connection with SAP. |
Password* |
The SAP password, used for the above user name. |
Language* |
The two-letter language code. This defines in which language SAP error messages will be displayed. Use the SAP language code table to determine the appropriate language code. Default: EN. |
Use fixed SAP server* |
Execute a table extraction job on the SAP Application Server where the job has been created. |
Job class* |
The priority with which the jobs in SAP are run:
Default: C. |
Extractor module name* |
The name of the Angles for SAP Data Extractor Function Module which has been imported into the SAP system. If you have Function Module 4.22 or earlier, the Extractor module name should be Z_EA_DATA_EXTRACTOR. If you have Function Module version 4.23 or later, the name should be /EASUITE/Z_EA_DATA_EXTRACTOR. If this field is left empty, the Angles for SAP Function Module will be selected automatically. |
Use load balancing* |
If you select Use load balancing, SAP will decide on which server the batch job will run. This can only be used if the hostname is an SAP message server, and the group name is maintained. See field Group name. SAP Logon groups are maintained in the transaction SMLG. Default: Unselected. |
Group name* |
The group name for the connection with the SAP message server.
Note:
This field is mandatory when Use load balancing is selected. |
Prefix |
SAP extraction file names are always preceded by a prefix. Make sure that every model has its own unique prefix. It is recommended to end this prefix with an underscore character. Example: EAX_SAP_ |
* This setting will be ignored when the copy method DIRECTDB is selected.
The available Copy method settings depend on which Copy method is selected. The following Copy method settings can be edited:
Copy method | ||
|---|---|---|
Copy method |
The copy method specifies the way in which table data is transferred from SAP. |
|
SMB |
SAP logical file path |
The name of the logical file path on SAP as defined in transaction FILE. Default: ZEA_INTERFACE. |
Username |
The SMB share user name. |
|
Password |
The SMB share password. |
|
Path |
The SMB share path. |
|
ZIP table data |
When selected, table data is compressed using ZIP64. This requires additional steps in SAP. See the 'EA Function Module Installation Manual' for more information. Default: Unselected. |
|
Use SMB2 |
Select this option to use SMB2 as the copy method. Caution: If you use SMB2 with a version of CloverETL older than 4.8.2, your download will fail. Caution: Angles for SAP recommends using SMB2. SMB1 has been deprecated due to security issues. |
|
FTP / SFTP |
SAP logical file path |
The name of the logical path on SAP as defined in transaction FILE. Default: ZEA_INTERFACE. |
Host |
IP or hostname of the (S)FTP server. |
|
Port |
The (S)FTP port number. Refer to the list of port numbers and ranges in the Firewall Guidelines to decide on the correct (S)FTP port number. Default: FTP = 21, SFTP = 22. |
|
Path |
The (S)FTP server path. |
|
Username |
The (S)FTP connection user name. |
|
Password |
The (S)FTP connection password. |
|
ZIP table data |
When selected, table data is compressed using ZIP64. This requires additional steps in SAP. See the 'EA Function Module Installation Manual' for more information. Default: Unselected. |
|
RFC |
SAP program ID |
The program ID on SAP as defined in transaction SM59. You need to create a destination in SM59 on SAP to use RFC. Default: ZEA_RFCOPY. Note: Keep this ID in sync with the RFC destination name. |
SAP Gateway host |
The SAP Gateway host in the format <hostname:port>. If you do not specify the port number, the System number (as shown above) is used as the default port number. To override this default port number, you must enter a port number. Example: sapgatewayhost:01 |
|
SAP RFC destination |
The SAP RFC destination name. Keep this destination name in sync with the SAP program ID, if possible. Default: ZEA_RFCOPY. |
|
SimpleRFC |
Compression at data transfer |
Select this option to improve transfer speed over a slow network. The data will be compressed by using a table of fixed-length character-type lines. |
Number of buffered blocks on SAP |
With this option, you can specify the maximum number of memory blocks that the shared memory on the SAP server may use per table download. The default is 3. |
|
Use SNC |
Use SNC to communicate with the SAP system. |
|
SNC Partner name of SAP server |
SNC Partner name of the application or (in case of load balancing) the message server. |
|
Concatenated list of servers with SNC names |
Leave blank to apply the SNC name from the parameter 'SNC partner name' to all Application Servers. This setting is only needed if the Application Servers have specific SNC names, and you should provide a concatenated list of SAP servers with their SNC names. Add each server to the list using the following format:
Make sure to end each entry with a semicolon. Example
|
|
| WEBSOCKET_RFC | Web socket host name | This will be the same as the Hostname of the SAP machine. It should be the FQDN. The name will be shared by the SAP Basis Team |
| Web socket Port | The port of the SAP machine. | |
| Use TLS | This setting is used to encrypt the data sent. It should be set as True as it allows the connection to be made. | |
| Web socket certificate | This certificate is used by the Client and the Server side to communicate with each other. It’s a .p12 file to be provided by the IT Team. | |
| Web socket certificate password |
The password for the Web socket certificate used for communication. Note: The IT Team has to make sure the domain name is added to the DNS. |
|
DIRECT DB ** |
Database type |
The database type of the underlying database of the SAP system. Currently only SQLServer is supported. Value for SQLServer: MSSQL Caution: The usage of DIRECTDB requires the activation of an additional module. This module can only be activated outside the IT Management Console. Contact the Angles for SAP Service Desk if you want to use DIRECTDB. |
Connection url |
The connection string used to establish the connection with the database. Please apply the ETL Server connection string syntax rules. For SQLServer the connection string is built as follows:
Copy
Example:
Copy
|
|
Database name |
The database name on the database level (also entered as last part of the connection string). |
|
Database schema |
The database schema on the database level. |
|
Username |
The name of the user on the database server. |
|
Password |
The password of the user on the database server. |
|
** The following limitations apply for the copy method DIRECTDB:
Plugins are not supported.
-
The content of pool, cluster and text tables cannot be downloaded directly from the database as they exist in other tables on the database level. A transformation is needed to download the content of these types of tables. The ETL Server will handle this transformation. However, the following restrictions apply:
For pool tables no additional ‘where clause’ conditions can be set.
For cluster tables an additional ‘where clause’ condition may only contain fields from the table cluster of the download table. A download error will occur if invalid ‘where clause’ conditions are used. Example: In SAP, BSEG is a cluster table which belongs to the table cluster RFBLG. An additional ‘where clause’ condition for the BSEG table may only contain fields from the RFBLG table cluster.
Not all texts can be downloaded. However, all texts that have been entered or maintained with standard SAP transactions (such as VL02N or VA02) can be downloaded.
-
The following fields can be left blank since they will be ignored:
Hostname, System number, System ID, User name, Password, Language, Use fixed SAP server, Job class, Extractor module name, Use load balancing and Group name.
Test Extraction
After setting and saving the Copy method settings it is recommended to do a test extraction to validate if the settings are correct. To do so, go to Models > [Model name] > Refresh cycle and click Test extraction.