Create a SAP Commerce source connection in the UI

The following tutorial walks you through the steps to create a SAP Commerce source connection to bring SAP Subscription Billing contacts and customer data using the Adobe Experience Platform user interface.

Getting started getting-started

This tutorial requires a working understanding of the following components of Experience Platform:

If you already have a valid SAP Commerce account, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.

Gather required credentials gather-credentials

In order to connect SAP Commerce to Experience Platform, you must provide values for the following connection properties:

For more information, please refer to the SAP Commerce documentation.

Create a Platform schema create-platform-schema

Before creating a SAP Commerce source connection, you must also ensure that you first create an Experience Platform schema to use for your source. See the tutorial on creating a Platform schema for comprehensive steps on how to create a schema.

Expand the following section to view an example schema.

{
  "_extconndev": {
    "addresses": [
      {
        "addressUUID": "{ADDRESS_UUID}",
        "city": "Burnaby",
        "country": "Canada",
        "email": "chandni@acme.com",
        "houseNumber": "27",
        "isDefault": false,
        "phone": "123-456-7890",
        "postalCode": "V3J 1X9",
        "state": "British Columbia",
        "street": "Beresford"
      }
    ],
    "changedAt": "1687204041",
    "changedBy": "vero@acme.com",
    "contactNumber": "123-456-7980",
    "corporateInfo": {
      "company": "acme"
    },
    "createAt": "1687204041",
    "createdBy": "vero@acme.com",
    "customReferences": [
      {
        "id": "Sample value",
        "typeCode": "Sample value"
      }
    ],
    "customerNumber": "Sample value",
    "customerType": "Sample value",
    "defaultAddress": {
      "addressUUID": "Sample value",
      "city": "North Vancouver",
      "country": "Canada",
      "email": "chandni@acme.come",
      "houseNumber": "34",
      "isDefault": false,
      "phone": "123-456-7890",
      "postalCode": "V7H 2P1",
      "state": "British Columbia",
      "street": "Maple"
    },
    "externalObjectReferences": [
      {
        "externalId": "{EXTERNAL_ID}",
        "externalIdTypeCode": "{EXTERNAL_ID_TYPE_CODE}",
        "externalSystemId": "{EXTERNAL_SYSTEM_ID}"
      }
    ],
    "markets": [
      {
        "active": false,
        "country": "USA",
        "currency": "USD",
        "marketId": "Sample value",
        "priceinfo": {
          "incoterms": "{INCO_TERMS}",
          "incotermsLocation": "{INCO_TERMS_LOCATION}",
          "priceGroup": "{PRICE_GROUP}",
          "priceListType": "{PRICE_LIST_TYPE}"
        },
        "salesArea": {
          "distributionChannel": "{DISTRIBUTION_CHANNEL}",
          "division": "{DIVISION}",
          "salesOrganization": "{SALES_ORGANIZATION}"
        }
      }
    ],
    "personalInfo": {
      "firstName": "Chandni",
      "lastName": "Kaur"
    }
  },
  "_id": "/uri-reference",
  "_repo": {
    "createDate": "2004-10-23T12:00:00-06:00",
    "modifyDate": "2004-10-23T12:00:00-06:00"
  },
  "createdByBatchID": "/uri-reference",
  "modifiedByBatchID": "/uri-reference",
  "personID": "{PERSON_ID}",
  "repositoryCreatedBy": "kevin@acme.com",
  "repositoryLastModifiedBy": "kevin@acme.com"
}

Connect your SAP Commerce account connect-account

In the Platform UI, select Sources from the left navigation bar to access the Sources workspace. The Catalog screen displays a variety of sources with which you can create an account.

You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search option.

Under the eCommerce category, select SAP Commerce, and then select Add data.

The Connect SAP Commerce account page appears. On this page, you can either use new credentials or existing credentials.

Existing account existing-account

To use an existing account, select the SAP Commerce account you want to create a new dataflow with, then select Next to proceed.

New account new-account

If you are creating a new account, select New account, and then provide a name, an optional description, and your credentials. When finished, select Connect to source and then allow some time for the new connection to establish.

Select data select-data

Finally, you must select the object type that you want to ingest to Platform.

Next steps next-steps

By following this tutorial, you have established a connection to your SAP Commerce account. You can now continue on to the next tutorial and configure a dataflow to bring data into Platform.

Additional resources additional-resources

The sections below provide additional resources that you can refer to when using the SAP Commerce source.

Mapping mapping

Platform provides intelligent recommendations for auto-mapped fields based on the target schema or dataset that you selected. You can manually adjust mapping rules to suit your use cases. Based on your needs, you can choose to map fields directly, or use data prep functions to transform source data to derive computed or calculated values. For comprehensive steps on using the mapper interface and calculated fields, see the Data Prep UI guide.

Mapping configurations for your dataflow will differ depending on your schema and the object type that you select to ingest.