If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

SAP RFC

Prerequisites

To connect to your SAP application, SAP Java Connector binaries (sapjco3.jar and libsapjco3.so) must be provided to Data Processing Engine (DPE). In on-premise deployments, data source drivers are located in the lib/jdbc folder in the DPE installation directory (typically /opt/ataccama/one/dpe).

Ataccama cannot redistribute SAP Java Connector binaries. To obtain the required binaries, contact your SAP representative.

The SAP RFC connector does not support the definition of logon groups for logon load balancing.

Create a source

To connect to SAP RFC:

Navigate to Data Catalog > Sources.
Select Create.
Provide the following:
- Name: The source name.
- Description: A description of the source.
- Deployment (Optional): Choose the deployment type.
  
  You can add new values if needed. See Lists of Values.
- Stewardship: The source owner and roles. For more information, see Stewardship.

Alternatively, add a connection to an existing data source. See Connect to a Source.

Add a connection

Select Add Connection.
In Select connection type, choose Others > SAP RFC.

Provide the following:

Name: A meaningful name for your connection. This is used to indicate the location of catalog items.
Description (Optional): A short description of the connection.
Hostname: The domain name or IP address of the SAP server.
System number: The application instance number of the SAP system. This is a two-digit number used for connecting to the server.
SAP router: Points to the SAProuter used to connect to the server. The following format is used: (/H/host/S/service/W/pass)*. Both the service port (/S/) and the password (/W/) are optional.
Client ID: A 3-digit number that specifies which profile is used when logging in the given user or group to the SAP server.
Table class: Specifies which tables are queried. The following options are available: APPLICATION, CUSTOMER, VIEW, CUSTOM_QUERY, BAPI.

If you select CUSTOM_QUERY, you also need to provide the query that will be applied in Table list query.

The SAP RFC connector also reads the following SAP tables to retrieve information about the database schema: DD02V, DD03M, and DD05Q.
Table name filter (Optional): Lets you filter tables by name. The default value is %, which matches any string.
Table list query: The custom query used to filter tables if CUSTOM_QUERY is selected in Table class.

Data read function (Optional): The name of the SAP function for querying data. By default, the standard RFC_READ_TABLE function is used.

There are some limitations to the RFC_READ_TABLE, as follows:

The size of the table that can be read is limited (512-character row limit). Tables exceeding the limit are not supported.
Paging is not supported. Reading of bigger tables might fail.
The authorizations assigned to the user calling the function are not considered: SAP authorization checks are bypassed.

If necessary, consider creating a new function in SAP. For example Z_READ_TABLE, a custom implementation that has to be imported into SAP.

Batch rows (Optional): The number of records that are read in a single batch. Default value: 2000.

In Additional settings, select Allow exporting and loading of Data if you want to export data from this connection and use it in ONE Data or outside of ONE.

If you want to export data to this source, you also need to configure write credentials as well.

Consider the security and privacy risks of allowing the export of data to other locations.

Add credentials

Select Add Credentials.
Provide the following:
- Name (Optional): A name for this set of credentials.
- Description (Optional): A description for this set of credentials.
- Username: The username associated with the SAP account.
- Password: The password for the SAP account.
Set the credentials to be used as default (Set as default).

One set of credentials must be set as default for each connection. Otherwise, monitoring and DQ evaluation fail, and previewing data in the catalog is not possible.

Add write credentials

Write credentials are required if you want to export data to this source.

To configure these, in Write credentials, select Add Credentials and follow the corresponding step depending on the chosen authentication method (see Add credentials).

Make sure to set one set of write credentials as default. Otherwise, this connection isn’t shown when configuring data export.

Test the connection

To test and verify whether the data source connection has been correctly configured, select Test Connection.

If the connection is successful, continue with the following step. Otherwise, verify that your configuration is correct and that the data source is running.

Save and publish

Once you have configured your connection, save and publish your changes. If you provided all the required information, the connection is now available for other users in the application.

In case your configuration is missing required fields, you can view a list of detected errors instead. Review your configuration and resolve the issues before continuing.

Next steps

You can now browse and profile assets from your SAP RFC connection.

In Data Catalog > Sources, find and open the source you just configured. Switch to the Connections tab and select Document. Alternatively, opt for Import or Discover documentation flow.

Or, to import or profile only some assets, select Browse on the Connections tab. Choose the assets you want to analyze and then the appropriate profiling option.

Was this page useful?