Connect to SAP Ariba Procurement Data in DBArtisan

The CData ODBC Driver for SAP Ariba Procurement seamlessly integrates SAP Ariba Procurement data into database management tools like DBArtisan by enabling you to access SAP Ariba Procurement data as a database. This article shows how to create an data source for SAP Ariba Procurement in DBArtisan and execute queries. You can then edit data visually and execute standard SQL.

Integrate SAP Ariba Procurement Data into DBArtisan Projects

If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

In order to connect with SAP Ariba Procurement, set the following:

• ANID: Your Ariba Network ID.
• ANID: Specify which API you would like the provider to retrieve SAP Ariba data from. Select the Buyer or Supplier API based on your business role (possible values are PurchaseOrdersBuyerAPIV1 or PurchaseOrdersSupplierAPIV1).
• Environment: Indicate whether you are connecting to a test or production environment (possible values are TEST or PRODUCTION).

Authenticating with OAuth

After setting connection properties, you need to configure OAuth connectivity to authenticate.

• Set AuthScheme to OAuthClient.
• Register an application with the service to obtain the APIKey, OAuthClientId and OAuthClientSecret.

  For more information on creating an OAuth application, refer to the Help documentation.

Automatic OAuth

After setting the following, you are ready to connect:

APIKey: The Application key in your app settings. OAuthClientId: The OAuth Client Id in your app settings. OAuthClientSecret: The OAuth Secret in your app settings.

When you connect, the provider automatically completes the OAuth process:

1. The provider obtains an access token from SAP Ariba and uses it to request data.
2. The provider refreshes the access token automatically when it expires.
3. The OAuth values are saved in memory relative to the location specified in OAuthSettingsLocation.

You can then follow the steps below to register SAP Ariba Procurement data as a database instance in your project:

1. In DBArtisan, click Data Source -> Register Datasource.
2. Select Generic ODBC.
3. Enter a name for the data source and select the DSN.
4. Finish the wizard to connect to SAP Ariba Procurement data. SAP Ariba Procurement entities are displayed in the Datasource Explorer.

You can now work with SAP Ariba Procurement data as you work with any other database. See the driver help documentation for more information on the queries supported by the SAP Ariba Procurement API.