Import Data Connection to SAP Cloud Platform Open Connectors Cloud Storage Data Sources

You can create import data connections to several file-based data sources using SAP Cloud Platform Open Connectors. Follow these steps to create a connection to data stored in a file-based 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 file-based 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 cloud storage data from the following file-based data sources:

  • Dropbox
  • Microsoft OneDrive
  • Amazon S3
  • Egnyte
  • Box
  • SFTP Element

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 Cloud Storage 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. 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.
      For more information on how to obtain the API Key and Secret, see Dropbox API Provider Setup.
    2. 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.
      For more information on how to obtain the API Key and Secret, see Microsoft OneDrive API Provider Setup.
    3. 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.
      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.
    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.
      For more information on how to obtain the Egnyte Subdomain, API Key, and Secret, see Egnyte API Provider Setup.
    5. Box: Enter a unique Connection Name, and the other required connection details, and then log on to Box using your account credentials.
      For more information on the connection details, see Box API Provider Setup.
    6. SFTP Element: Enter a unique Connection Name, and then enter a user name, password, and host name.
      For more information, see SFTP API Documentation.
  4. Choose Create.
    The new connection is added to the list of connections on the Connections screen.