Integrate SAP Cloud Platform Open Connectors

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

Prerequisites

Before you integrate SAP Cloud Platform Open Connectors, you will need to get an SAP Cloud Platform account and enable the Open Connectors service. To learn more about SAP Cloud Platform Open Connectors, see the SAP Cloud Platform documentation. Contact your SAP representative to purchase and set up Open Connectors.

Also, Open Connectors is available only in SAP Cloud Platform Cloud Foundry environments. A two-digit number in your SAP Analytics Cloud URL, for example eu10 or us30, indicates an SAP Cloud Platform Cloud Foundry environment.

Note
To integrate SAP Cloud Platform Open Connectors, you need administrator rights.

Context

Follow these steps to integrate your SAP Cloud Platform 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 Cloud Platform 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

  1. In SAP Analytics Cloud, go to Start of the navigation path (Main Menu) Next navigation step  System Next navigation step  Administration Next navigation step Datasource ConfigurationEnd of the navigation path.
  2. In the SAP Cloud Platform Open Connectors area, select Let's integrate your Open Connectors Account.
    The Integrate SAP Cloud Platform Open Connectors dialog appears.
  3. Select your SAP Cloud Platform Sub Account Region from the list.
    The sub account region you want to integrate. For more information, see Accounts in the SAP Cloud Platform documentation.
  4. Enter your Open Connectors User Secret.
    The user secret assigned to you, when you created your SAP Cloud Platform account. For more information, see Authentication in the SAP Cloud Platform documentation.
  5. Enter your Open Connectors Organization Secret.
    The organization secret assigned to you, when you created your SAP Cloud Platform account. For more information, see Authentication in the SAP Cloud Platform documentation.
  6. Enter your SAP Cloud Platform Global Account ID.
  7. Enter your SAP Cloud Platform Subaccount ID.
  8. Select Save Open Connectors Account.
    Your Open Connectors account is integrated.
  9. From the Datasource 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.
Related Information