A JDBC URL includes the following elements:

protocol:[//hostname:port][;property=value[;...]]

A HybridDataPipelineDataSource property specifies the data source to which you want to connect. For example, the following example URL assumes:

  • A data source name of myOraDS
  • The data store credentials are stored in the myOraDS Data Source
  • Encryption is not required

jdbc:datadirect:ddhybrid://myhost:8080;hybridDataPipelineDataSource=myOraDS;encryptionMethod=noEncryption

The URL elements to connect to a data source defined in the Hybrid Data Pipeline dashboard are described in the following table.

Table 1. JDBC URL Elements
URL Element Description Value
Protocol The protocol for the Hybrid Data Pipeline connectivity service. jdbc:datadirect:ddhybrid 
HostName The DNS name of the machine where Hybrid Data Pipeline is installed. myhost 
Port Port that the Hybrid Data Pipeline service is listening to. 8080 
property=value Optional connection properties for the driver. HybridDataPipelineDataSource is the only required connection property. The name of the Hybrid Data Pipeline data source is saved in your Hybrid Data Pipeline account.

For more information on other optional connection properties, see Connection Properties.