SAP OData connection

To access your data in SAP OData, create a connection asset for it.

Use the SAP OData connection to extract data from a SAP system through its exposed OData services.

Supported SAP OData products

The SAP OData connection is supported on SAP products that support the OData protocol version 2. Example products are S4/HANA (on premises or cloud), ERP, and CRM.

Create a connection to SAP OData

To create the connection asset, you need these connection details:

Credentials type:

  • API Key
  • Basic
  • None
Note: SAP OData connections require SSL/TLS encryption. Use an `https://` URL for the SAP Gateway. If your SAP system uses a self-signed certificate, you must upload the certificate during connection setup.

Encryption:
SSL certificate (if required by the database server)

For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

Obtain the SSL certificate

To connect securely, you might need to upload the SSL certificate used by your SAP OData server.

  • Contact your SAP or system administrator to obtain the certificate.
  • If unavailable, you can extract the certificate using tools like openssl or a browser. However, this method is not recommended for production environments due to security risks.
  • SSL certificate (if required by the database server)
Note: If your SAP system uses a certificate signed by a trusted Certificate Authority (CA), you typically do not need to upload a certificate.

SAP OData setup

See Prerequisites for using the SAP ODATA Connector for the SAP Gateway setup instructions.

Use OData with a Satellite connection

You can connect to SAP OData through a Satellite endpoint if your connector supports it.

  • If the connector supports Satellite, the Configure Satellite option is available in the connection UI.
  • If not, you can manually configure the Satellite endpoint by using the following format for the SAP Gateway URL:
Note: SSL certificate validation might fail when routing through a proxy. Ensure that the certificate is valid and trusted, or disable certificate validation if your environment allows it.

Restrictions

  • For Data Refinery, you can use this connection only as a source. You cannot use this connection as a target connection or as a target connected data asset.
  • For SPSS Modeler, you cannot create new entity sets.

Troubleshooting

An error usually indicates an authentication issue. Check the following:

  • The username and password are correct.
  • The user has the required permissions in the SAP system.
  • The SAP Gateway path is correct.

SSL certificate validation errors

If you receive SSL-related errors:

  • Confirm that the certificate is uploaded and trusted.
  • Try toggling the Validate SSL certificate option in the connection settings.

Learn more