Learn more
 

Ready to get started?

Download a free trial of the SAP Ariba Procurement ODBC Driver to get started:

 Download Now

Learn more:

SAP Ariba Procurement Icon SAP Ariba Procurement ODBC Driver

The SAP Ariba Procurement ODBC Driver is a powerful tool that allows you to connect with live data from SAP Ariba Procurement, directly from any applications that support ODBC connectivity.

Access SAP Ariba Procurement data like you would a database - read, write, and update SAP Ariba Procurement 0, etc. through a standard ODBC Driver interface.

In this article

Related articles

Viewing SAP Ariba Procurement Data in RAD Studio Data Explorer


How to view SAP Ariba Procurement data in RAD Studio Data Explorer using the CData ODBC Driver for SAP Ariba Procurement.

Embarcadero RAD Studio provides a development environment for Delphi and C++Builder applications. With the CData ODBC Driver for SAP Ariba Procurement, you gain access to live SAP Ariba Procurement data within RAD Studio, abstracting the data into tables, views, and stored procedures that can be used to both retrieve SAP Ariba Procurement data. This article will walk through connecting to SAP Ariba Procurement using the Data Explorer.

Configure a Connection to SAP Ariba Procurement

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.

Connecting to SAP Ariba Procurement Data Using Data Explorer

You can create a simple application for displaying SAP Ariba Procurement data by utilizing the CData FireDAC Components for SAP Ariba Procurement and a new VCL Forms Application:

  1. Open the Data Explorer in RAD Studio and expand FireDAC.
  2. Right-click the ODBC Data Source node in the Data Explorer.
  3. Click Add New Connection.
  4. Enter a name for the connection.
  5. In the FireDAC Connection Editor that appears, set the DataSource property to the name of the ODBC DSN for SAP Ariba Procurement.
  6. Back in the Data Explorer, expand the views for the connection.

  7. Create a new VCL Forms application and drag a view (for example: Orders) onto the form.

  8. Select the OrdersView object on the form and set the Active property to true.

  9. Right-click on the object, bind visually, and link everything (*) to a new control (TStringGrid).

  10. Arrange the TStringGrid on the form and run the application to see the Orders data.