SAP Connector
Configures SAP connector defaults and SAP-specific import behavior.
Use this page to find the SAP Connector settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| SAP AC Custom Function Name | SAP_AC_CUSTOM_FUNCTION_NAME | Z_XTRACT_IS_TABLE | SAP custom function name for AnalyticsCreator. The default SAP function is RFC_READ_TABLE. |
| SAP Automatic Date Conversion | SAP_AUTOMATIC_DATE_CONVERSION | 0 | SAP automatic date conversion. 0 - No, 1 - Yes. |
| SAP Deltaq Autosync | SAP_DELTAQ_AUTOSYNC | 1 | 0 - Disable, 1 - Enable. |
| SAP Deltaq Transfermode | SAP_DELTAQ_TRANSFERMODE | T | I - IDoc, T - tRFC. |
| SAP Description Language | SAP_DESCRIPTION_LANGUAGE | E | SAP language to get table and field descriptions. |
| SAP Max Record Count | SAP_MAX_RECORD_COUNT | 1000 | Max count of records returned by SAP. |
| SAP P Type Additional Length | SAP_P_TYPE_ADDITIONAL_LENGTH | 1 | SAP: sometimes the length of the P type columns should be increased by this parameter. |
| SAP SSIS Custom Function Name | SAP_SSIS_CUSTOM_FUNCTION_NAME | Z_XTRACT_IS_TABLE_COMPRESSION | SAP custom function name for Theobald connector in SSIS packages. Please read Theobald documentation about XtractIS to get the correct function name. |
| SAP Substitution Date Value | SAP_SUBSTITUTION_DATE_VALUE | 1970-01-01 | SAP value for invalid date (YYYYYMMDD) in case automatic date conversion is on. |
| SAP Substitution Maxdate Value | SAP_SUBSTITUTION_MAXDATE_VALUE | 2099-12-31 | SAP value for 9999XXXX date (YYYYMMDD) in case automatic data conversion is on. |
| SAP Substitution Mindate Value | SAP_SUBSTITUTION_MINDATE_VALUE | 1970-01-01 | SAP value for 0000XXXX date (YYYYMMDD) in case automatic data conversion is on. |
| SAP Theobald Version | SAP_THEOBALD_VERSION | 0 | 0 - match the SQL Server version, or a number (2008, 2012, etc.). |