SAP Open Connectors

Resources

We're glad that you're trying out SAP Open Connectors and hope you use this section to learn where to find more information and get familiar with our terminology.

Documentation and Resources

If you have found your way to this page, you're at least familiar with our documentation. We have many resources available to help you create integrations. Here in the Help Center, you can find API reference documentation, knowledgebase articles, guides that provide detailed instructions, and documentation about each of our connectors.

Use the search at the top of the page to find information anywhere in the Help Center. 

As you use the Help Center, and especially as you work through the Getting Started guide, we encourage you to provide feedback so we can give you the best docs experience possible.

Definitions

An API Hub (Hub) provides uniform APIs to access a collection of resources enabling one-to-many API access to multiple API providers. For example, the CRM hub provides normalized access to multiple CRM application services including Salesforce, Microsoft Dynamics, Netsuite CRM, Sugar CRM, Zoho CRM, and Autotask (we call a connection to each service an connector). Your application can write to the “One” uniform API and get access to “Many” application services in that category. Within the CRM Hub, SAP has normalized the API calls to multiple resources such as Accounts, Contacts, Leads, Opportunities and more. Hubs represent the intersection of resources across the connectors within that category of application services.

We normalize our API calls for all endpoints, to enable calls between services e.g., Salesforce to HubSpot. However, with this feature, certain endpoint resources cannot be mapped for each hub.

  • Hubs provide uniform APIs to access any collection of connectors or a set of resources.
  • Hubs enable “One-to-Many” access to an entire category of services.
  • Hubs are accessed using a consistent RESTful API with a JSON payload regardless of the technology used at the endpoint.
  • Hubs rapidly translate calls into the semantic and data structure required by each endpoint.
  • Hubs provide a uniform set of interactive API documentation that developers use to access the resources in the Hub.
  • Hubs combine resources from multiple categories providing a consistent set of APIs and documentation to access any collection of resources (e.g., combine Salesforce, Box, and QuickBooks API resources into a Hub).

Connector Instance

An authenticated connector instance is a single authenticated connection between SAP and an account at an API provider such as a Salesforce, Marketo, or Netsuite. An authenticated connector instance can access all the objects, fields, and data for that account — including custom data. An authenticated connector instance is created when a user successfully connects to the endpoint by providing an instance name, the required authentication credentials for that connector, and optional event configuration.

Bulk

Bulk APIs enable you to move large amounts of data. SAP Open Connectors provides the ability to upload and download data in bulk from an endpoint in a normalized way. We leverage the provider bulk endpoints whenever available. But, when the API provider has no bulk endpoints, we provide a pseudo bulk service for uploading and downloading data from the endpoint. For uploads, we accept a file, and then create objects at the endpoint on a record-by-record basis. For downloads, we execute a search API against the endpoint, and loop through all results until we have retrieved all the data. SAP stores the files (encrypted) on SAP servers for a maximum of seven days.

OCNQL

OCNQL stands for Open Connectors Query Language, the search and filter language used by SAP Open Connectors to standardize searching across all our different connectors. Many APIs support some form of searching in their APIs but they’re almost all different, so we have standardized a common way to search across all our connectors. SAP translates the OCNQL to the endpoint’s searching syntax, however at times, OCNQL supports more than the endpoint.

Common Resource

A common resource is a stand-alone resource, created and defined by a user with the intention of creating a one-to-many transformation. Common resources define normalized fields that you can use in place of specific connectors to facilitate one-to-many integrations. You map fields from connector resources to the common resource fields to create transformations.

Discovery Service

SAP includes a comprehensive data discovery service that provides normalized metadata, such as the list of field names and types. Additional information, if available from an endpoint, may also be obtained such as: display name, read-only, etc. If an endpoint doesn’t provide discovery service APIs, SAP will still provide a minimum set of metadata about the given resource (e.g., name and type). SAP also allows you to discover custom fields (as long as the values are not empty), by supplying an object Id when a native discovery service is not available. The Discovery Service is used along with the Transformation Service to normalize the responses across endpoints.

Connector

Connectors are pre-built API integration that enables a connection into a specific API Provider endpoint (e.g., Salesforce, Quickbooks, or Marketo). All connectors start with a normalized set of features, including authentication, resources, paging, errors, events and search. At the hub level, we also seek to support the richer set of APIs that an application provides, even when not all the connectors in that category share that resource. For example, Salesforce Sales Cloud has APIs that many other CRM services do not support. You can find these APIs that are specific to just Salesforce in the documentation for that connector

  • Connectors share common services including discovery, search query, pagination, bulk uploading and downloading, logging, and interactive documentation.
  • Methods are normalized and accessible through RESTful APIs.
  • Complete data payloads are returned in JSON and available to transform and normalize to a common resource.
  • SAP keeps each connector up-to-date with changes at the endpoint.
  • Each connector is a multi-tenant connector supporting an unlimited number of authenticated accounts with no additional code required.

Endpoint

A unique URI that represents a resource and includes the HTTP method and resource. it includes the method (GET, PUT, PATCH), the base URL, and the resource.

Event

An action that occurs at an API provider associated with an authenticated connector instance and is monitored either through Polling or Webhooks.

Formula Instance

A specific instance of a formula template configured with explicit variables and associated with specific connector instances.

Formula Template

A formula template is a reusable workflow that is independent of the connector and includes the triggers, steps, and variables for a formula instance to execute the workflow. The steps in a formula template accomplish a wide variety of use cases across different services, such as keeping systems in sync, migrating data between systems, and automating business workflows.

OAuth Proxy

The OAuth Proxy feature gives you the capability to have multiple environments, such as development, QA, etc, with one endpoint application. For example some vendors only allow one callback URL per application. The proxy will allow for the same callback URL to be used with multiple application endpoints. You would then use the proxy address as the Callback URL instead of your own Callback URL. This permits multiple endpoint applications to one callback URL.

Payload

The data returned from an API response. Or, the body of an API request.

Resource

An object or entity that can be accessed via a URI request.

Transformation

A Transformation is the result of mapping an API provider resource to a common resource. This allows you to define the fields to include in a specific resource, map those fields to the fields containing the same data in the provider resource, and then transform the data to match the common resource.