Connecting to Salesforce Data Cloud in DBeaver

This guide explains how to establish a connection between DBeaver and your Salesforce Data Cloud. DBeaver provides built-in drivers for Data Cloud, including one based on the Data Cloud Query API and a legacy version using the Data Cloud Query V2 API.

• Install DBeaver from https://dbeaver.io/download.
• Configure a Connected App in Salesforce. See Configure and Establish an OAuth Session. Configure the Connected App for the JWT Bearer Flow or the Username-Password Flow, as needed.

1. Open DBeaver: Launch the DBeaver application.

2. Create New Connection: Go to Database -> New Database Connection.

3. Select Driver: In the connection dialog, search for and select Salesforce Data Cloud, and then click Next.

4. Configure Connection (Main Tab): The connection dialog appears. On the Main tab, enter:

   • Username (All Flows): Your Salesforce username, which corresponds to the userName property.
   • Password (Username-Password Flow Only): If using the Username-Password Flow, enter your Salesforce password followed immediately by your security token (no spaces). This combined value is required for authentication.

5. Configure Driver Properties (Driver Properties Tab): Go to the Driver properties tab. Configure the necessary properties based on your chosen authentication flow.

   • Add New Property: Right-click in the blank area under User Properties, and select Add new property.

   • Enter Property Name: Enter the required property name, such as clientId or clientSecret, and click OK.

   • Enter Property Value: Click in the value field next to the newly added property and enter the corresponding value.

   • Required Properties (All Flows):

     • clientId: The Consumer Key from your Connected App
     • clientSecret: The Consumer Secret from your Connected App

   • Required Property (JWT Bearer Flow Only):

     • privateKey: The private key associated with your Connected App. Ensure correct configuration. See OAuth 2.0 JWT Bearer Flow.

   • Optional Properties: For a list of additional configurable properties, see Optional Properties.

6. Finish Connection: Click Finish.

7. Verify Connection: Your new Salesforce Data Cloud connection should appear in the DBeaver Database Navigator.

You can query and interact with your Salesforce Data Cloud data through DBeaver. For example, you can use SQL queries to retrieve specific data or create visualizations of your data. See the Get Started with Data Cloud SQL guide. Refer to the DBeaver documentation for information on using its features.

To connect to multiple data spaces, create a new connection for each data space.