The following table shows the URL formats for DataDirect Connect XE for JDBC drivers, where:

  • server_name, for the Hive driver, specifies the server IP address or host name (if your network resolves host names to IP addresses) 1
  • server_name, for Salesforce, specifies the URL that identifies a Salesforce instance. If you do not specify an instance, login.salesforce.com is used as the value.
  • The integer value that appears after the server name is the port number on which the database is listening.
    Note: Port number does not apply to Salesforce unless you are connecting through a proxy server. See Connecting Through a Proxy Server for details.
Table 1. URL Formats for DataDirect Connect XE for JDBC Drivers
Driver URL Format
Driver for Apache Hive 
jdbc:datadirect:hive://server_name:54000;User=user_name;
Password=password
Salesforce2 
jdbc:datadirect:sforce://server_name;User=user_name;Password=password;
SecurityToken=value
1 You can use the ping command to verify this feature (for example, ping server1). Verify that the correct IP address is returned in the reply from the command.
2 If the Salesforce instance is configured for a security token, you will be required to supply one. See SecurityToken for details.