Creating an extended integration for SAP Ariba purchase orders

Sync Oomnitza with SAP Ariba to gain visibility of purchase order data.

Before you start

You must retrieve the following information from SAP Ariba to create credentials and add the integration:

SAP Ariba Network ID. See How do I find my SAP Business Network ID. 

SAP Ariba domain. Enter https://openapi.ariba.com for US or https://eu.openapi.ariba.com for EU.

SAP Ariba URL. The SAP Ariba login URL. Enter https://ariba.com for US or https://api-eu.ariba.com for EU.

Client ID and secret. See Create OAuth Secret for Client Application in Setup steps for SAP Ariba Procurement.

To easily find the records that are uploaded to Oomnitza, it's best practice to create a dedicated user account for each integration. This will make it easier for you to retrieve the records that are uploaded to Oomnitza from the vendor application. 

Creating integration users 

Adding OAUTH credentials

Make life easier and add your credentials to Oomnitza before you create the integration.  

1. In Oomnitza, click Configuration > Security > Credentials.
2. Click Add new credential (+).
3. Search for the integration, and then click the forward arrow > to select the integration.
4. Enter your client credentials and any other additional information.
5. Click Authenticate. You are prompted to log in to authorize your request.
6. Click CREATE.

Adding the integration

1. Click Configuration.
2. On the Integrations: Overview page, click Add new integration . 
3. Enter purchase as the search criteria.
4. Add the SAP Ariba Purchase Orders load.
5. Click Edit integration details .
6. Edit the name of the integration.
7. By default, the Line Items checkbox is selected. If you deselect the checkbox, Oomnitza retrieves a list of invoices. It will not retrieve the line items that are linked to invoices.
8. As Installation type, Cloud is selected.
9. As Integration preferences, Create and Update is selected.
10. Select the integration user that you added.

11. Select the name or names of the integration contacts.  Integration contacts will receive an in-app notification and an email:

    1. When the integration fails

    2. When the integration fails to complete within 24 hours

    3. When the scheduled integration fails to run

12. Enter the SAP Ariba domain.
13. Enter the SAP Network ID.

Adding credentials

1. Click Edit credential details .
2. Select the credentials that you created.

Scheduling the integration

By default, data is synced once every day. Change the interval or the time so that the data is synced when your system isn't busy.

1. Click Edit .
2. Save your changes.

Mapping

1. Click Edit mappings .
2. Click SMART MAPPING.

Drag and drop

You can map additional fields to Oomnitza.

1. Drag and drop the fields in the Oomnitza column.
2. Rename the field.
3. Make your changes.
4. Save your changes.

Mappable fields

You can map the following fields to Oomnitza:

Attachment Count
Balance Amount
Balance Approx
Balance Conversion Date
Balance Currency Code
Blanket
Blanket Purchase Order ID
Buyer Ariba Network ID
Company Code
Connector Sync Time
Created At
Customer Ariba Network ID
Customer Name
Dashboard Status
Dispute ID
Document Number
Document Status
EndPoint ID
Hide Amount
Invoiced Amount
Invoiced Amount Approx
Invoiced Amount Conversion Date
Invoiced Amount Currency Code
Is Release
ISO Country Code
Number Of Invoices
Order Date
Payload ID
Payment Terms Explanation
Purchase Order Amount
Purchase Order Approx
Purchase Order Closed
Purchase Order Conversion Date
Purchase Order Currency Code
Purchase Order Ship To City
Purchase Order Ship To Code
Purchase Order Ship To Country
Purchase Order Ship To Postal Code
Purchase Order Ship To State
Purchase Order Ship To Street
Purchase Order Version
purchasing Agent Name
Purchasing Group Code
Purchasing Organization Code
Release Required
Revision
Scheduling Agreement
Service ID
Settlement
Ship To Name
Status
Supplier Ariba Network ID
Supplier Name
System ID
Transport Terms
Transport Terms Description
Vendor ID

Selecting sync keys

You must select at least one field as the sync key field. To ensure that the sync runs successfully, the field must contain unique values such as the serial number of an asset record or the email address of a user record. Records that do not contain a value for the sync key are skipped.   

See Configuring multiple sync keys.

Launching the integration

Your integration is in Draft mode until the required mandatory fields are added. When added, click Launch to activate your integration. 

Next

When the sync is complete, you can review the data that is collected. See Viewing financial data.

Related articles

Editing financial integrations
Viewing financial data
Tutorial: Accessing expense, invoice, and purchase order data from the menu