Syntax

jdbc:datadirect:drivername://server_name:port[;property=value[;...]]

where:

drivername
is the name of the driver, for example, sforce.
server_name
is the IP address or TCP/IP server name of the server to which you are connecting. For Salesforce, 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.
port
is the number of the TCP/IP port.
Note: Port number does not apply to Salesforce unless you are connecting through a proxy server. See Connecting Through a Proxy Server for details.
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 following table shows some typical driver connection URLs for each driver.

Note: 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.
Table 1. Example URLs for DataDirect Connect XE for JDBC
Driver URL Format
Driver for Apache Hive 
jdbc:datadirect:hive://server1:10250;User=test;
Password=secret
Salesforce1 
jdbc:datadirect:sforce://login.salesforce.com;User=test;
Password=secret
jdbc:datadirect:sforce://test.salesforce.com;User=test;
Password=secret2
jdbc:datadirect:sforce:User=test;Password=secret3
1 If the Salesforce instance is configured for a security token, you will be required to supply one. See SecurityToken for details.
2 This example shows a connection URL for connecting to a Salesforce sandbox instance.
3 Because this example does not specify a Salesforce instance, login.salesforce.com is used as the default value.