Create a SugarCRM Accounts & Contacts source connection in the UI

This tutorial provides steps for creating a SugarCRM Accounts & Contacts source connection using the Adobe Experience Platform user interface.

Getting started

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

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

Gather required credentials

In order to connect SugarCRM Accounts & Contacts to Platform, you must provide values for the following connection properties:

Credential
Description
Example
Host
The SugarCRM API endpoint the source connects to.
developer.salesfusion.com
Username
Your SugarCRM developer account username.
abc.def@example.com@sugarmarketdemo000.com
Password
Your SugarCRM developer account password.
123456789

Create a Platform schema

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

The SugarCRM Accounts & Contacts supports multiple APIs. This means that you have to create a separate schema, depending on the object type that you are leveraging. See the examples below for both accounts and contacts schemas:

Accounts
Platform UI screenshot showing an example schema for Accounts
Contacts
Platform UI screenshot showing an example schema for Contacts

Connect your SugarCRM Accounts & Contacts 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 CRM category, select SugarCRM Accounts & Contacts, and then select Add data.

Platform UI screenshot for catalog with SugarCRM Accounts & Contacts card

The Connect SugarCRM Accounts & Contacts account page appears. On this page, you can either use new credentials or existing credentials.

Existing account

To use an existing account, select the SugarCRM Accounts & Contacts account you want to create a new dataflow with, then select Next to proceed.

Platform UI screenshot for Connect SugarCRM Accounts & Contacts account with an existing 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.

Platform UI screenshot for Connect SugarCRM Accounts & Contacts account with a new account

Select data

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

Object type
Description
Accounts
The companies with whom your organization has a relationship with.
Contacts
The individual people with whom your organization has an established relationship.
Accounts
Platform UI screenshot for SugarCRM Accounts & Contacts showing configuration with Account option selected
Contacts
Platform UI screenshot for SugarCRM Accounts & Contacts showing configuration with Contacts option selected

Next steps

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

Additional resources

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

Guardrails guardrails

The SugarCRM API throttle rates are 90 calls per minute or 2000 calls per day, whichever happens first. However, this restriction has been circumvented by adding a parameter into the connection spec that will delay request time so that the rate limit is never reached.

Validation validation

To validate that you have correctly set up the source and SugarCRM Accounts & Contacts data is being ingested, follow the steps below:

  • In the Platform UI, select View Dataflows beside the SugarCRM Accounts & Contacts card menu on the sources catalog. Next, select Preview dataset to verify the data that was ingested.

  • Depending on the object type you are working with, you can verify the aggregated data against the counts visible on the SugarMarket Accounts or Contacts pages below:

Accounts
Screenshot from the SugarMarket Accounts page displaying list of accounts
Contacts
Screenshot from the SugarMarket Contacts page displaying list of contacts
NOTE
The SugarMarket pages do not include the deleted object counts. However, data retrieved through this source will also include the deleted count, these would be marked with a deleted flag.
recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089