Import Data Connection to SAP Open Connectors Cloud Storage Data Sources

You can create import data connections to several file-based data sources using SAP Integration Suite Open Connectors capabilities. Follow these steps to create a connection to data stored in a file-based cloud application.

Prerequisites

To create connections to file-based data sources powered by Open Connectors, please integrate SAP Open Connectors with SAP Analytics Cloud first. For more information, see Use SAP Integration Suite Open Connectors.

You may need to refer to the following documentation before creating the connection (see Step 3 below):

Data Source

Additional Information

Amazon S3

For more information on how to obtain the Access Key ID, Secret Access Key, Bucket Name, and Region Endpoint, see Amazon S3 API Provider Setup.

Box

For more information on the connection details, see Box API Provider Setup.

Dropbox

For more information on how to obtain the API Key and Secret, see Dropbox API Provider Setup.

Egnyte

For more information on how to obtain the Egnyte Subdomain, API Key, and Secret, see Egnyte API Provider Setup.

Microsoft OneDrive

For more information on how to obtain the API Key and Secret, see Microsoft OneDrive API Provider Setup.

Microsoft OneDrive for Business

For more information on how to obtain the API Key and Secret, see Microsoft OneDrive for Business API Provider Setup.

  • SharePoint and OneDrive for Business can share the application setup through the Microsoft Azure portal.

  • API permission requires Delegated permissions, SharePoint > MyFiles.Read.

SFTP Element

For more information, see SFTP API Documentation.

SharePoint

SharePoint and OneDrive for Business can share the application setup through the Microsoft Azure portal.

Context

You can create a connection to import cloud storage data from the following file-based data sources:

  • Amazon S3

  • Box

  • Dropbox

  • Egnyte

  • Microsoft OneDrive

  • Microsoft OneDrive for Business

  • SFTP Element

  • SharePoint

Procedure

  1. From the side navigation, choose Connections Start of the navigation path Next navigation step End of the navigation path (Add Connection).
    The Select a data source dialog will appear.
  2. From the categories filter, select Open Connectors and select a Cloud Storage data connection under Acquire Data (see the list of data sources above).
  3. Depending on the connection you selected, follow these steps:
    1. Amazon S3: Enter a unique Connection Name and your Amazon Access Key ID, Secret Access Key, Bucket Name, and Region Endpoint, and then log on to Amazon using your account credentials.
    2. Box: Enter a unique Connection Name, and the other required connection details, and then log on to Box using your account credentials.
    3. Dropbox: Enter a unique Connection Name, the Dropbox API Key, and the Dropbox API Secret, and then log on to Dropbox using your account credentials.
    4. Egnyte: Enter a unique Connection Name, The Egnyte Subdomain, OAuth API Key, and the OAuth API Secret, and then log on to Egnyte using your account credentials.
    5. Microsoft OneDrive: Enter a unique Connection Name, the OneDrive OAuth API Key, and the OneDrive OAuth API secret, and then sign in to Microsoft using your account credentials.
    6. Microsoft OneDrive for Business: Enter a unique Connection Name, OneDrive for Business Site Address, OAuth API Key, and the OAuth API Secret, and then log on to OneDrive for Business using your account credentials.
    7. SFTP Element: Enter a unique Connection Name, and then enter a user name, password, and host name.
    8. SharePoint: Enter a unique Connection Name, SharePoint Site Address, OAuth API Key, OAuth API Secret, MS OAuth Scope, and Use Scope, and then log on to SharePoint using your account credentials.
  4. Choose Create.
    The new connection is added to the list of connections on the Connections screen.