Reference

Authentication Sandbox (test.salesforce.com)

Description

No description available [API reference]

Instructions

Follow these steps to create a Salesforce External Client App (or a legacy Connected App) so the Data Cloud JDBC driver can authenticate. JDBC Bridge then exposes Data Cloud SQL to Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

WARNING: As of 21 Feb 2026 Salesforce no longer lets you create new Connected Apps. Use an External Client App. If you already have a Connected App, you can keep using it with username/password + consumer key/secret. Do not use a personal employee login for unattended jobs (Power BI refresh, Linked Server, ADF). Use a dedicated integration user.
  1. Sign in to Salesforce Setup as an administrator.
  2. Go to App Manager (or External Client Apps) and create a new External Client App / Connected App. Enable OAuth Settings.

  3. Callback URL (Redirect URI) must be exactly:

    https://zappysys.com/oauth

    INFO: Use this ZappySys capture page so the authorization code appears in the page title and URL during the 3-legged dance. Do not use localhost, a Salesforce "try it" page, or any other URL -- those often redirect again or drop the query string, so the code is not visible.
  4. Select OAuth scopes your org requires for Data Cloud query (typically includes Data Cloud / CDP query and API access). Save.
  5. Open Manage Consumer Details and copy Consumer Key (Client ID) and Consumer Secret (Client Secret).
  6. Paste username, password (plus security token if your org requires it), Client ID, and Client Secret into this Auth profile.
  7. If you complete a browser authorization, wait until the browser lands on https://zappysys.com/oauth and the code is in the title or address bar.
  8. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  9. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\Salesforce Data Cloud (Data 360)\jdbc-0.29.0-shaded.jar
Name: LoginHost

Label: Login host

Salesforce login host (e.g. test.salesforce.com). 		YES test.salesforce.com
Name: UserName

Label: User name

Sandbox integration username. 		YES
Name: Password

Label: Password

Sandbox password, plus security token if required. 		YES
Name: clientId

Label: Client ID (Consumer Key)

Consumer Key from the sandbox External Client App. 		YES
Name: clientSecret

Label: Client Secret (Consumer Secret)

Consumer Secret. Callback URL must be https://zappysys.com/oauth. 		YES
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. com.salesforce.datacloud.jdbc.DataCloudJDBCDriver). 		com.salesforce.datacloud.jdbc.DataCloudJDBCDriver
Name: dataspace

Label: Data space

Data Cloud data space. Default is default. 		default