skip to main content
Getting Started : Using the Drivers : Connecting Using the JDBC Driver Manager : Specifying Connection URLs : URL Format: DataDirect Connect XE for JDBC
  
URL Format: DataDirect Connect XE for JDBC
Syntax
jdbc:datadirect:sforce:[//server_name][;property=value[;...]]
where:
server_name
Is the URL of the Salesforce instance to which you want to connect, for example, login.salesforce.com or test.salesforce.com. If you do not specify, login.salesforce.com is used as the value.
property=value
Specifies connection properties. Multiple properties are separated by a semi-colon. For a list of connection properties supported for each driver and their valid values, see the appropriate driver chapter.
The install_dir/samples directory, where install_dir is your product installation directory, contains a sample application that illustrates the steps of connecting to a Salesforce instance.
The following table shows some typical driver connection URLs for each driver.
Table 7. Example URLs for DataDirect Connect XE for JDBC
Driver
URL Format
Driver for Apache Hive
jdbc:datadirect:hive://server1:10250;User=test;
Password=secret
Greenplum
jdbc:datadirect:greenplum://server1:5432;DatabaseName=jdbc;
User=test;Password=secret
Salesforce
jdbc:datadirect:sforce://login.salesforce.com;User=test;
Password=secret
jdbc:datadirect:sforce://test.salesforce.com;User=test;
Password=secret1
jdbc:datadirect:sforce:User=test;Password=secret2

1 This example shows a connection URL for connecting to a Salesforce sandbox instance.

2 Because this example does not specify a Salesforce instance, login.salesforce.com is used as the default value.