Salesforce (beta)

Follow these steps to connect your Salesforce instance to Select Star.

For instances operating within a non-publicly accessible environment, such as a private network, please refer to our guide on Integrating Private Network Data Sources for detailed instructions and best practices.

1. Create a service account for Select Star

We recommend creating a dedicated service account for Select Star with metadata-only roles and permissions.

  • Go to Settings → Setup → Users → Users and click New User

    • Last Name selectstar

    • Email Your email

    • User License Salesforce Integration

    • Profile Minimum access - API Only Integrations (note: if you select the minimum access profile, an administrator will need to obtain the Security Token for you)

  • Click the Save button

  • Click Continue

2. Required permissions

These are the permissions you will need to fetch the metadata from Salesforce.

  • API Access: You must have the API Enabled permission in your Salesforce organization

  • Object Permissions: You must have read access to the Salesforce objects that you want to ingest

3. Get your security token

The Salesforce Security Token is required to access the metadata through APIs.

  • Login to an account with administrator privileges.

  • Go to Settings → Setup → Users → Users

  • Locate the API-only user and click the Login button

  • Click on the username and select My Settings

  • From the Personal section, select Reset My Security Token

  • Click the Reset Security Token

  • The new token will be sent to the email address of the API-only user.

If there is no option to login next to the edit button, you need to enable the “Administrators Can Log in as Any User” option in the Setup menu:

  • Go to Settings → Setup → Login Access Policies

  • Select the Administrators Can Log in as Any User checkbox.

  • Click Save.

If you need further assistance please check this doc on how to get the security token.

4. Create a new data source in Select Star

  • Display Name - The Name you want to give to your new data source

  • Username - The user's username

  • Password - Your password

  • Security Token - Your security token

  • Salesforce API Version - You can specify the API version if needed, follow the steps mentioned here to get the API version (default 42.0)

  • Salesforce Domain - You can specify the domain you want to use to access the platform (default login)

Select Star currently does not support Popularity and Lineage for this integration. If needed, please feel free to contact us so we can explore alternative solutions.

Your metadata should start loading automatically, once the sync is complete, you'll be able to see it in Select Star.

See the link below for more information on how to navigate through data warehouses.

Getting Started: Data Warehouse

Last updated