Understanding Integration Basics

Objective

After completing this lesson, you will be able to explain the basics of Integration.

Integration Basics

The graphical process flow between ERP and SAP Ariba is displayed.

Integration is the transfer of data from one system to another.

An example of transferring data from one system to another could be:

  • Extracting data from an ERP (or other backend system) on a scheduled basis and pushing that data into an SAP Ariba Procurement solution, with limited (or no) human intervention.

And then

  • Exporting/downloading data from the SAP Ariba procurement solution and loading that data into the ERP (or other backend system) -- on a scheduled basis …again…with limited, or no, human intervention.

The type of data that you’re exchanging depends on the systems you’re using.

SAP Ariba Integrations

SAP Ariba integration between SAP ERP and non- SAP ERP is displayed.

Master vs. Transactional Data

Master Data

  • Represents core operational business data that is agreed to be shared across an organization, some examples are:
    • Supplier data
    • User groups
    • Inventory
  • This data is agreed upon information shared across an organization
  • Master Data is used by SAP Ariba to build and process data in transactions

Transactional Data

  • Represents electronic business documents, some examples are:
    • Requisitions
    • Invoices
    • Receipts
    • Purchase Orders
  • Some of these electronic documents can be:
    • Exported from SAP Ariba and used to create corresponding transactions in an external system (usually ERP)
    • Created in SAP Ariba via integration using data from an external source

Master Data Example

Integration allows us to keep master data in sync between customers’ source systems and SAP Ariba with little-to-no effort or lag time.

The integration between HR and SAP Ariba Solution is displayed.

Master data scenario: A Human Resources manager enters data into the HR system to create a new "User profile". Through data integration between systems, the User Profile is automatically created in the SAP Ariba solution.

Transactional Data Example

Integration also allows for handoff of one business process to another between applications through transactional data.

The transactional data integration is displayed.

Transactional data scenario: When an electronic invoice is reconciled (or flagged as "okay to pay") in SAP Ariba, via integration, it can automatically create and issue payment via an ERP system.

Integration Method vs. Connection Protocol

Integration Method is the "standard language" - how the business data is structured based on documents like POs/Invoices.

You can think of comparing cXML to EDI like you would compare English to French—it’s just a different way of saying the same thing.

Integration MethodExample using "language" analogy
cXMLGerman
EDIFrench
CIGTranslator

Connection Protocol is the "communication method"- the WAY transactions are sent from one system to another.

Returning to the language analogy, if you are going to speak French, will it be via phone or email?

Connection ProtocolExample using "mechanisms" analogy
cXML is via HTTPSEmail
EDI is via AS2 or VANPhone
CIG is via SOAP/ODATA etc.Video Chat

Let’s review what is meant by integration method & connection protocols – so we can better establish how CIG improves them.

An Integration Method is a standard formatting language or "computer language" used to structure business data in business documents like POs and Invoices. You can think of comparing cXML to EDI like you would compare English to French—it’s just a different way of saying the same thing. Here we give a basic analogy using human languages. As you can see, where cXML and EDI are similar to speaking some languages, CIG is able to process "all of the languages" in the analogy.

A Connection Protocol is the mechanism used to communicate the transactions– the WAY transactions are sent from one system to another. Returning to the language analaogy, if you are going to speak French, will it be via phone or email?

(cXML is via HTTPS) (EDI is via AS2 or VAN), maybe CIG is like video chat – where it’s faster to communicate than the other options.

Data Transfer Options

The Data Transfer Options are displayed.

Batch File Channel

Used for Non-SAP integrations.

Back-end system: Non- SAP ERP (.csv) files uploaded/downloaded over HTTPS.

Overview:

  • Transfer multiple record/files in a single batch.
  • Scheduled upload/download process.
  • Leverage Integration Toolkit to transfer files between systems.

Batch File Channel -Comma-separate (.csv) files uploaded or downloaded over HTTPS - Multiple records/files in a single batch -Scheduled upload/downloaded processes -Can leverage Integration Toolkit to transfer the files between systems.

Web Services

Can be used for SAP integrations, but generally used for Non-SAP integrations.

Back-end system: BOTH SAP ERP and/or S/4HANA on-premise & Non- SAP ERP cXML messages sent over HTTPS.

Overview:

  • One record/file per message.
  • Customer middleware application is required to send/receive messages.
  • Real-time process- documents are pushed to external system as soon as they are created in Procurement and vice-versa.

Web Services (SOAP) -XML messages sent over HTTPS - One record per discreet message -A middleware application is required on customer’s side to send/receive these messages (e.g., PI, BizTalk, TIBCO, etc.) -Real-time process—documents are pushed to external system as soon as they are created in Procurement and vice-versa.

SAP Ariba Cloud Integration Gateway(CIG)

Integrates SAP Ariba to SAP.

Back-end system: SAP ERP and/or S/4HANA on-premise.

Integration Basics: Best Practices

  • Integrate master data with batch loads
  • Integrate transactional data with real-time loads
  • Use the Administration User Interface or the Data Dictionary to verify what data – both standard and custom – can be loaded into SAP Ariba Procurement
  • Create custom Flex Master Data when custom tabular data is required within the SAP Ariba solutions
    • These can be loaded through integrations

Consider deploying CIG to make integration more efficient and less time consuming.

Log in to track your progress & complete quizzes