Parameterize Connections
This page shows how to parameterize an SAP connection.
Parameterize a Connection Manager
The properties of a Connection Manager can be parameterized. Follow the steps below to set up project parameters for Connection Manager properties:
- Right-click a Connection Manager and select Parameterize... from the context menu. The window "Parameterize" opens.
- Select the property you want to parameterize.
- Select the option Use existing parameter to assign a parameter to the selected property or select the option Create New Parameter to create a new parameter.
- In the section Scope select Project to create a project parameter.
- Click [OK]. The new project parameter is now available under Project.params in the "Solution Explorer".
For more information on package and project parameters, see Microsoft Documentation: Integration Services (SSIS) Package and Project Parameters.
Properties of XTRACT
The XTRACT Connection Manager has the following properties:
| Property Name | Description |
|---|---|
| AppServer | Host name or IP address of the SAP application server. |
| AttachesSapGui | Set to True for Reports and BAPIs that require an installed SAP GUI. |
| Client | The three-digit number of the SAP client between 000 and 999. |
| InstanceNumber | A two-digit number between 00 and 99. |
| InternalTableFunction | The function module used for Xtract IS’ internal communication with SAP, e.g., retrieving metadata. |
| Language | The logon language for the SAP system, e.g., EN for English or DE for German. |
| LegacyStorageMode | Enables backward compatibility. SAP connection parameters are no longer stored as Connection Strings, but as Properties. |
| LoadBalancingEnabled | Enables load balancing (SAP message server). |
| LogOnGroup | SAP Logon group for Load Balancing. |
| MessageServer | Name or IP address of the SAP message server. |
| Name | Name of the Connection Manager. |
| Password | Password of the SAP user. |
| PasswordObfuscated | If LegacySorageMode is enabled, this property determines if the password is stored as plain text or if it is masked. |
| RfcLibrary | Select an RFC library to establish an RFC connection to an SAP system. |
| SncEnabled | Enables Secure Network Connection (SNC). |
| SncLibraryPathX64 | The complete path to the library location for 64 bit systems. |
| SncLibraryPathX86 | The complete path to the library location for 32 bit systems. |
| SncPartnerName | The SAP Partner Name configured for the SAP application server, e.g., p:SAPserviceERP/do_not_care@THEOBALD.LOCAL |
| SncQualityOfProtection | The SNC level of protection, e.g., 9 - Maximum |
| SystemId | A three-digit System ID, e.g., MSS. |
| TraceDirectory | A local path to a folder, where you want to save the debug information. |
| User | Name of the SAP user. |
Properties of XTRACT_ODATA
The XTRACT_ODATA Connection Manager has the following properties:
| Property Name | Description |
|---|---|
| OdataBaseUrl | The base URL (protocol, hostname and port) of your SAP system, e.g. http://sap-erp-as05.example.com:50000 for on-premises systems and https://my123456.s4hana.cloud.sap for cloud systems. |
| OdataPassword | Password of your SAP user. |
| OdataUsername | When connecting to an SAP on-premises system, enter the username of an SAP dialog user. When connecting to an SAP private or public cloud system, enter the username of an SAP Communication User. |
Sensitive Environment Variables in SSISDB Catalog
Environment variables in the SSISDB catalog can be used in combination with project parameters to achieve the following:
- Parameterize SSIS packages after deploying to the server.
- Encode sensitive data, e.g., SAP passwords.
Follow the steps below to set up a sensitive environment variable for an XTRACT Connection Manager property:
- Configure an XTRACT Connection Manager that uses project parameters, see Parameterize a Connection Manager.
- Deploy the project to an SSISDB catalog.
- Create an environment in the SSISDB catalog.
- Create a sensitive variable in the environment properties.
- Open the configuration menu of the project. The project parameters from step 1 are available in the parameter list.
- Click [...] to assign a sensitive environment variable to a project parameter.
- Execute a package using the environment.
Related Topics
- XTRACT Connection Manager
- SAP Connection with SNC
- Microsoft Documentation: SSIS Catalog
- Microsoft Documentation: Access Control for Sensitive Data in Packages
Last update: February 16, 2026