Salesforce Data Source
This article includes information about how to install the JDBC driver for Salesforce, how to connect to a Salesforce database, and a list of the Salesforce data types that supports. With the JDBC driver installed, the Salesforce data source is available as an option in the connection wizard when creating an API.
This article includes information about how to install the JDBC driver for Salesforce, how to connect to a Salesforce database, and a list of the Salesforce data types that
CA Live API Creatorsupports. With the JDBC driver installed, the Salesforce data source is available as an option in the connection wizard when creating an API.
In this article:
Install the JDBC Driver for Salesforce
The self-contained, single-user version of
CA Live API Creatorthat is based on Jetty includes the JDBC driver for Salesforce. The JDBC driver is located in the
%JETTY_HOME%/caliveapicreator/lib/extdirectory. If you have installed this version of
CA Live API Creator, no additional steps are required to install the JDBC driver.
If you have installed
CA Live API Creatoron another Java container, such as Apache Tomcat, copy the
cdata.jdbc.salesforce.jarJAR file (the JDBC driver) that is located in the
databaseDriversdirectory into the directory that is based on the Java container on which you have installed
CA Live API Creator:
Copy the JDBC driver into the
Copy the JDBC driver to the
<Your WebLogic Domain Directory>/libdirectory.
Add the JDBC driver to your Web application server.
Using the WebSphere administrative console, create a JDBC provider for the driver in the server.
For more information about how to create a JDBC provider, see the IBM WebSphere documentation.
For more information:
Connect to a Salesforce Database
You can connect to your Salesforce database using the following methods:
- (If you have not created your API yet) When you create your API.For more information about how to create an API, see Creating APIs.
- (If you have an existing API) By adding a connection to a Salesforce data source.For more information about how to add a connection to a data source, see Database Connectivity.
The following procedure details how to connect to your Salesforce database when creating your API.
Connect to one of your Salesforce instances using the Salesforce JDBC driver that you have added as a library in API Creator.
Prerequisites:Before you connect to one of your Salesforce instances, verify that you have completed the following:
- You know your Salesforce connection information.
- You have a Salesforce user name and password. For example, [email protected]
- You have a generated Salesforce security token.For more information about how to generate the security token, see the Salesforce documentation.
- You have ensured that your Salesforce account has the API Enabled permission set.
- You have determined which production, sandbox or dev environment you are going to use.
Follow these steps:
- In API Creator, on the APIs page, clickCreate New API.The connection wizard opens.
- ClickDatabase First.
- SelectSalesforceas the data source type.
- Complete theUsername,Password, andSecurity Tokenfields based on the information for your Salesforce account.
- (Optional) If you want to connect to a Salesforce sandbox environment, select theUse Sandboxcheckbox and then enter the name of the sandbox in theSandbox Namefield.Your username is appended with a period(.) followed by the sandbox name.
You are connected to the Salesforce database.
Salesforce Supported Data Types
You can read and write the following Salesforce data types:
Salesforce requires Transport Layer Security (TLS) encryption protocol version 1.1 or higher. You can enable TLS 1.1 and TLS 1.2 explicitly by adding the following line to your startup command for Apache Derby or Tomcat:
For more information: