Import Data Connection to SAP Cloud Platform Open Connectors Query-Based Data Sources

You can create import data connections to several third-party data sources using SAP Cloud Platform Open Connectors. Follow these steps to create a connection to query-based data stored in a third-party cloud application.

Prerequisites

Note

If your SAP Analytics Cloud system is hosted on a data center located within China, this feature is not available.

To create connections to third-party data sources powered by Open Connectors, please integrate SAP Cloud Platform Open Connectors with SAP Analytics Cloud first. For more information, see Integrate SAP Cloud Platform Open Connectors.

Context

You can create a connection to import query-based data from the following third-party data sources:

  • Microsoft Dynamics CRM
  • NetSuite CRM 2018 Release 1
  • Autotask CRM
  • Close.io
  • ConnectWise CRM REST Beta
  • Infusionsoft REST
  • Insightly

Procedure

  1. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a Datasource dialog will appear.
  2. From the categories filter, select Open Connectors and select a query-based data connection under Acquire Data (see the list of data sources above).
  3. Depending on the connection you selected, follow these steps:
    Note
    In the steps below, if you need to use a redirect URL, use the following URL instead of the ones shown in the screenshots: https://bocauth.us1.sapbusinessobjects.cloud:443.

    Or if your SAP Cloud Platform landscape is operating in European Union (EU) Access mode (for data protection within the EU), use https://bocauth.eu1.sapbusinessobjects.cloud/.

    1. Microsoft Dynamics CRM: Enter a unique Connection Name, choose an Authentication Type, enter the Microsoft Dynamics CRM Tenant URL, OAuth Client ID in Azure AD, and the OAuth Client Secret in Azure AD, and then sign in to Microsoft using your account credentials.
      For more information on how to obtain the API Client ID and Client Secret, see Microsoft Dynamics CRM API Provider Setup.
    2. NetSuite CRM 2018 Release 1: Enter a unique Connection Name, choose an Authentication Type, enter a Sandbox name, email address and password, Account ID, and App ID, and then log on to NetSuite using your account credentials.
      For more information on how to obtain the API Key and Secret, see NetSuite 2018 CRM API Provider Setup.
    3. Autotask CRM: Enter a unique Connection Name, the Server URL, and a Username and Password, and then select Create.
      For more information on the connection details, see Autotask CRM API Provider Setup.
    4. Close.io: Enter a unique Connection Name, enter an API Key, and then log on to Close using your account credentials.
      For more information, see Close.io API Provider Setup.
    5. ConnectWise CRM REST Beta: Enter a unique Connection Name, and the other required connection details, and then log on to ConnectWise using your account credentials.
      For more information on the connection details, see ConnectWise CRM REST API Provider Setup.
    6. Infusionsoft REST: Enter a unique Connection Name, enter the OAuth API Key and the OAuth API Secret, and then sign in to Infusionsoft using your account credentials.
      For more information on how to obtain the API Key and Secret, see Infusionsoft CRM API Provider Setup.
    7. Insightly: Enter a unique Connection Name, enter the API Key, and then sign in to Insightly using your account credentials.
      For more information on how to obtain the API Key, see Insightly API Provider Setup.
  4. Choose Create.
    The new connection is added to the list of connections on the Connections screen.