Building the JDBC URL

Connection strings provide information about a data source and how to connect to that data source. The driver comes with a connection string builder that makes it easier to create and manage the contents of connection strings.

After downloading and installing the driver, double-click the .jar file in the lib folder. You can also manually run the .jar file, as shown in the following examples.

From Windows:

java -jar 'C:\Program Files\CData\CData JDBC Driver for Act! CRM 2024\lib\cdata.jdbc.actcrm.jar'

From macOS:

java -jar cdata.jdbc.actcrm.jar

Running the .jar file opens the Connection Properties dialog box. You can use this dialog box to build and test a connection string. Click Test Connection to test and validate the entered connection properties. Click Copy to Clipboard to copy the connection string for use within the application where the JDBC driver is being used.