SAP ODP Connection Options private preview
  • Dark
    Light

SAP ODP Connection Options private preview

  • Dark
    Light

Note

This component is available for private preview from version 1.66 of Matillion ETL. Please consult your welcome pack for details on submitting feedback on this component.

Overview

This page documents the additional connection options for the SAP ODP Extract component in Matillion ETL.

This component is available in a private preview state for Matillion ETL for Snowflake. Please consider this documentation a work-in-progress, and expect updates to the component page (linked above) and this page.

Not all of the properties below are presently available, as made clear in certain table rows with a notice.

To set any of these connection options in SAP ODP Extract:

  1. Double-click the component's Connection Options parameter.
  2. Click + to add a single connection option and select from the dropdown, or click Add All.
  3. Set the value of each connection option.

Properties

Property Description
Authentication Type Default value is CONFIGURED_USER. This means that a username and password must be specified directly. If you wish to enable single sign-on (SSO) via principal propagation, set the value to PrincipalPropagation; in this case, you don't need to provide jco.client.user and jco.client.passwd. This parameter is optional. SSO is not available for this connector currently during private preview.
Alias User Not available for this connector currently during private preview.
Code Page Defines the code page used to convert the logon parameters. Should be used in special cases only. The default for JCo is 1100. Read Languages, Code Pages, and Conversions to learn more.
PCS Not available for this connector currently during private preview.
R3 Name System ID (SID) of the SAP system. For ECC, this parameter is usually EC3. For S/4Hana, it is usually S4H. The R3 name is used with load balancing, but can also be used in SAP systems that have a dedicated application server. Specify a value if you wish to differ from the ECC and S/4Hana defaults. This parameter is optional.
Sticky As Host Not available for this connector currently during private preview.
Sap Router String for the IP or DNS address and port number of the SAP router (if a router is in place). The syntax is /H//S/. For example, /H/32.0.226.0/S/3299. Read Uses and Functions of SAProuter.
My Sap Sso2 SAP cookie version 2 as a logon ticket for SSO authentication. SSO is not available for this connector currently during private preview.
Get Sso2 SSO is not available for this connector currently during private preview.
X509 Certificate Public key for an X509 certificate with SNC, generated by SAP. Without SNC: provide the file path to the file of the X509 certificate.
OIDC Bearer Token Not available for this connector currently during private preview.
Ext Id Data Not available for this connector currently during private preview.
Ext Id Type Not available for this connector currently during private preview.
L Check Not available for this connector currently during private preview.
Network Options include High Speed Connection (LAN by default) or Low Speed Connection.
Serialization Format Not available for this connector currently during private preview.
Delta Use the table delta management to reduce the quantity of data sent via the network, especially if dealing with large RFC table parameters. The default value is 1, which enables the feature. When 1, only appended, deleted, and updated table rows are transferred back to the caller. A value of 0 disables the feature, meaning the whole table parameter is sent back to the caller. Parameter is only relevant if jco.delta_management RFC protocol is turned on. Recommended to be used in special cases only.
SNC Mode SNC mode. 0 for off; 1 for on. If SNC configuration is desired, set to 1; else considered 0.
SNC SSO Boolean to use SSO with SNC. 1 means SNC with SSO. 2 means SNC without SSO.