Loading...

Integrating Salesforce with Data Cube Sources

If you use Salesforce, you can integrate Data Cube data sources with your Salesforce account to make data stored in your repositories available from the Salesforce platform. And while you can see Data Cube entities from the Salesforce platform, data remains in storage in your IT infrastructure and is not persisted in any way on Salesforce servers.

Before You Begin

  • Because you are exposing your data to an external service, ensure that your Web Console with Data Cube is configured for secured access using HTTPS.

    For more information, see Configuring Secured Access for the Web Console.

  • Before you can integrate Data Cube data connectors with external services, you must already have connected to and crawled data sources. For information about connecting and crawling data sources, see Getting Started with Data Cube.
  • You must have Lightning Connect enabled for your Salesforce account. Lightning Connect is the technology that allows external data to appear within the Salesforce platform. For more information, contact your Salesforce account representative.
  • For this procedure, you will need the following information:
    • Salesforce account credentials.
    • User credentials for a Data Cube user with access to the data source that you want to integrate with the external service.

Procedure

  1. Open your Salesforce portal and create a new external data source. For more information, refer to the Salesforce help article, Define an External Data Source for Salesforce Connect—OData 2.0 or 4.0 Adapter.
  2. Enter the following information about your Data Cube source into the Salesforce external data source fields:
    Field Required Value
    Type Select Lightning Connect: OData 2.0.
    URL Enter the following secure URL for your Web Console with Data Cube:

    https://WebConsoleURL/webconsole/service/OData/

    Identity Type Select Named Principal.
    Authentication Protocol Select Password Authentication and enter the credentials of the Data Cube user with access to the data sources that you want to integrate with Salesforce.

    Note: All of the data sources that are visible to the Data Cube account will be accessible to users from the Salesforce platform. To restrict the data sources that you want to integrate with Salesforce, create a new Data Cube user with access to only the data sources that you want to integrate with the Salesforce platform.

  3. Follow the Salesforce documentation to complete the procedure.