Salesforce
This documentation describes the integration of MindsDB with Salesforce, the world’s most trusted customer relationship management (CRM) platform. The integration allows MindsDB to access data from Salesforce and enhance it with AI capabilities.
Prerequisites
Before proceeding, ensure the following prerequisites are met:
- Install MindsDB locally via Docker or Docker Desktop.
- To connect Salesforce to MindsDB, install the required dependencies following this instruction.
Connection
Establish a connection to Salesforce from MindsDB by executing the following SQL command and providing its handler name as an engine.
Required connection parameters include the following:
username
: The username for the Salesforce account.password
: The password for the Salesforce account.client_id
: The client ID (consumer key) from a connected app in Salesforce.client_secret
: The client secret (consumer secret) from a connected app in Salesforce.
Optional connection parameters include the following:
is_sandbox
: The setting to indicate whether to connect to a Salesforce sandbox environment (true
) or production environment (false
). This parameter defaults tofalse
.
To create a connected app in Salesforce and obtain the client ID and client secret, follow the steps given below:
- Log in to your Salesforce account.
- Go to
Settings
>Open Advanced Setup
>Apps
>App Manager
. - Click
New Connected App
, selectCreate a Connected App
and clickContinue
. - Fill in the required details, i.e.,
Connected App Name
,API Name
andContact Phone
. - Select the
Enable OAuth Settings
checkbox, set theCallback URL
to wherever MindsDB is deployed followed by/verify-auth
(e.g.,http://localhost:47334/verify-auth
), and choose the following OAuth scopes:
- Manage user data via APIs (api)
- Perform requests at any time (refresh_token, offline_access)
- Click
Save
and thenContinue
. - Click on
Manage Consumer Details
underAPI (Enable OAuth Settings)
, and copy the Consumer Key (client ID) and Consumer Secret (client secret). - Click on
Back to Manage Connected Apps
and thenManage
. - Click
Edit Policies
. - Under
OAuth Policies
, configure thePermitted Users
andIP Relaxation
settings according to your security policies. For example, to enable all users to access the app without enforcing any IP restrictions, selectAll users may self-authorize
andRelax IP restrictions
respectively. Leave theRefresh Token Policy
set toRefresh token is valid until revoked
. - Click
Save
. - Go to
Identity
>OAuth and OpenID Connect Settings
. - Ensure that the
Allow OAuth Username-Password Flows
checkbox is checked.
Usage
Retrieve data from a specified table by providing the integration and table names:
Run SOQL queries directly on the connected Salesforce account:
The above examples utilize salesforce_datasource
as the datasource name, which is defined in the CREATE DATABASE
command.
Was this page helpful?