General Settings for Connection settings and Tools
The Connection Settings are part of the ETL Server, and it takes care of the extraction, loading, and transforming of SAP data into Angles for SAP.
You can change the settings for Connection Settings and other tools in the IT Management Console. Navigate to Models > [Model name] > Connection Settings and expand General settings for Connection Settings and tools to view and edit the available settings.
General settings for Connection Settings and tools | |
|---|---|
Number of concurrent table extractions |
The number of concurrent table extractions on SAP. Increasing this setting might increase download performance. Please contact the customer's SAP application manager if you want to specify a value higher than 3. Default: 3. |
Number of concurrent downloads |
The number of concurrent copy jobs transferring data from SAP to the Angles for SAP work folder. You may increase this setting when SAP's temporary storage is getting full. However, keep this setting in sync with the amount of concurrent table extractions. This setting is not used in case of the RFC Copy method. Default:3. |
Number of concurrent indexing processes |
The number of concurrent indexing processes at the Angles for SAP extraction. Increasing/decreasing this setting will result in more/less load balancing. Please contact the Angles for SAP service desk before increasing this setting. Default: 3. |
Number of concurrent external processes |
The number of concurrent external processes at the Angles for SAP extraction. External processes are Table Split, Restructurer actions and Table unroller settings. Increasing/decreasing this setting will result in more/less load balancing. Please contact the Angles for SAP servicedesk before increasing this setting. Default: 3. |
Number of concurrent Clover graph extractions |
The number of concurrent Clover graph extractions at the Angles for SAP extraction used for non SAP downloads. Increasing/decreasing this setting will result in more/less load balancing. |
Maximum size per transported data block |
The maximum size (in Megabytes) the Function Module is allowed to use per block in the transport buffer. This setting is used for tuning performance. Default: 1. |
Long text length used by function module |
Long text fields from SAP tables are truncated to this length. Default: 200. |
Minimal column width for non-printable character replacement |
During the extraction, non-printable characters like Carriage return (CR) or Line feed (LF), are automatically replaced by a question mark (?) to make the data usable for Angles for SAP. This replacement process impacts the performance significantly if it is executed on every SAP table column that has the character type. To optimize speed, a standard minimum column width can be chosen to reduce the amount of data that needs to be processed in this way. Non-printable characters are replaced in character-type columns that are at least as wide as this specified width. The default value of 30 characters represents a good compromise between speed and problems encountered. You can reduce this width if you encounter too many interpretation problems during the import. When set to one, all character type columns are checked, resulting in a slower extraction. The performance impact depends on your system, the table layout, and the data itself. |
Max percentage of changes vs record count for delta replication download |
If many changes have been made to an SAP table that is set up for Angles for SAP delta replication, the download and the merge of the table can take a long time. It might be better in this case to just download the complete table and replace the existing one instead of performing a time-consuming merge. You can set the maximum percentage of the number of changes for the SAP table versus the record count of the corresponding local table. If the percentage of changes versus the record count, which is calculated in advance, exceeds the specified percentage, the table will be downloaded in full instead of being merged. Default: 50 |
External commands: Command for the deltamerger |
Detailed command line used when the call to the deltamerger is done by the EA ETL Sandbox.
Note:
Should only be changed by experts. Default: "<App>\Xtractor\EADeltaMerger.exe" "%sourcetable%" "%deltatable%" "%resulttable%" "%whereclause%" -logfile "EADeltaMerger_Slot%slot%_" |
External commands: Command for the tableindexer |
Detailed command line used when the call to the tableindexer is done by the Connection Settings. Note: Should only be changed by experts. Default: "<App>\Xtractor\EATableIndexer.exe" "%tablename%" -numkeyfields %numkeyfields% -logfromsize %logfromsize% -logfile "EATableIndexer_Slot%slot%_" |
External commands: Command for the download determiner |
Detailed command line used when the call to the download determiner is done by the Connection Settings. Note: Should only be changed by experts. Default: "<App>\Xtractor\EADownloadDeterminer.exe" "<WorkFolder>" "<ModelFolder>" "%definition%" "%actionlist%" -r "%saprelease%" |
External commands: Command for the schemabuilder |
Detailed command line used when the call to the schemabuilder is done by the Connection Settings. Note: Should only be changed by experts. Default: "<App>\Xtractor\EASchemaBuilder.exe" "%table%" "%definition%" |
Number of days to keep extraction reports |
After an extraction, reports are saved in a folder, normally the EADownload folder. To save disk space the reports are removed after a certain number of days. You can change the number of days with this setting. Default: 14. |