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. This account must be a normal user with direct login credentials and not an SSO-based user. Using an SSO-based user (such as one managed by Okta) can cause authentication issues, as the API access requires a dedicated username and password that is not subject to external identity provider restrictions.
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
To fetch metadata from Salesforce, you need the following permissions:
API Access β Required to allow API access in your Salesforce organization.
Object Permissions β Required to read the Salesforce objects being ingested.
View Setup and Configuration β Required to fetch metadata such as Field Definitions.
3. Get your security token
The Salesforce Security Token is required to access the metadata through APIs.
Ensure that the account used for API access is a normal user with direct login credentials and not an SSO-based user.
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 for this integration.
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.
Last updated
Was this helpful?