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
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.
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. Note Two redirect URLs are needed:
|
Microsoft OneDrive for Business | For more information on how to obtain the API Key and Secret, see Microsoft OneDrive for Business API Provider
Setup.
Note Two redirect URLs are needed:
|
SFTP Element | For more information, see SFTP API Documentation. |
SharePoint | For more information on how to obtain the API Key and Secret, see SharePoint API Provider Setup.
Note
The SharePoint user will need sufficient permissions for accessing the OAuth application; otherwise the message “An error occurred while retrieving the authentication code from SharePoint” may appear, or access_denied may appear in the redirected URL. To check whether a user has the required permissions, paste this URL in a browser, replacing the variables with the information that was entered in the connection dialog: https://<SharePoint Site Address>/_layouts/15/OAuthAuthorize.aspx?client_id=<OAuth API Key>&response_type=code&scope=<MS OAuth Scope> If the SharePoint user doesn't have the required permissions, access_denied will appear in the URL. One way to grant the required permissions is to assign the user the Admin role for the main SharePoint site, or assign Full Control for the team sites. Please consult with Microsoft if you need to fine tune the SharePoint user settings. |
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