Use SAP Integration Suite Open Connectors

Use SAP Integration Suite Open Connectors capabilities with SAP Analytics Cloud to be able to import data from several third-party cloud applications, such as Dropbox and OneDrive.

Prerequisites

Before you use SAP Integration Suite Open Connectors, you will need to get an SAP Business Technology Platform (BTP) account and enable the Open Connectors service. To learn more about Open Connectors, see the SAP Open Connectors documentation. Contact your SAP representative to purchase and set up Open Connectors.

Note

To use Open Connectors, you need administrator rights.

Context

Follow these steps to use the SAP Integration Suite Open Connectors with SAP Analytics Cloud. Once you complete the integration, you and other users in your organization will be able to create import data connections to Open Connectors data sources. At the moment, the following data sources are available:

Query-based data sources
Autotask CRM
Close.io
ConnectWise CRM REST Beta
Infusionsoft REST
Insightly
Microsoft Dynamics CRM
NetSuite CRM 2018

Cloud Storage (document-based) data sources
Amazon S3
Box
Dropbox
Egnyte
Microsoft OneDrive
Microsoft OneDrive for Business
SFTP Element
SharePoint

Note

Keep in mind that Open Connectors uses cloud credits and may incur additional charges. These are the API requests that use cloud credits:

For query-based data sources
Action	Number of API requests
Loading the list of tables	1
Opening the query builder (Loading the list of filters and selectable data)	1
Opening a list-of-values dialog for a filter	1
Executing the query	1+ (Depending on the number of rows of data)
Editing the query	1+ (Depending on the number of rows of data)
Refreshing the model with an Open Connectors data source	1+ (Depending on the number of rows of data)

For document-based data sources
Action	Number of API requests
Opening folders	1+ (about 1 request for every 200 files per folder opened)
Acquiring the file	1
Refreshing the model with an Open Connectors data source	1

You can review your Open Connectors cloud credit usage in your SAP Integration Suite overview page.

Note

After you've integrated Open Connectors, you can pause or delete the account at any time to stop incurring charges.

When the account is paused, users in your workspace won't be able to use any Open Connectors data sources to refresh their models. They can continue using data they've already acquired though. For example, they can still see a model in a story, but can't refresh the data.

If the account is deleted, users won't be able to use existing connections to Open Connectors data sources, or models based on Open Connectors data sources.

Procedure

In SAP Analytics Cloud, from the side navigation, choose System Administration Data Source Configuration.
In the Open Connectors area, select Let's integrate your Open Connectors Account.
The Open Connectors dialog appears.
Select your SAP Business Technology Platform (BTP) Sub Account Region from the list.
The sub account region you want to integrate. For more information, see Account Model in the SAP BTP documentation.
Enter your Open Connectors User Secret.
The user secret assigned to you, when you created your SAP BTP account. For more information, see Authentication in the SAP BTP documentation.
Enter your Open Connectors Organization Secret.
The organization secret assigned to you, when you created your SAP BTP account. For more information, see Authentication in the SAP BTP documentation.
Enter your SAP BTP Global Account ID.
Enter your SAP BTP Subaccount ID.
Select Save Open Connectors Account.
Your Open Connectors account is integrated.
From the Data Source Configuration tab, you can pause your Open Connectors account or edit integration settings.

Results

From the Connections screen, users can now create import data connections to the available third-party data sources.