skip to main content
Configuring Hybrid Data Pipeline for JDBC : Getting started with the JDBC driver
  

Try Now

Getting started with the JDBC driver

JDBC provides an API that Java applications can use to access a database using Structured Query Language (SQL). The Hybrid Data Pipeline Driver for JDBC, which is compliant with JDBC 4.0 and earlier specifications, works with the Hybrid Data Pipeline connectivity service to provide SQL access to supported data stores from any JDBC application.
The Hybrid Data Pipeline Driver for JDBC connects to a Hybrid Data Pipeline data source, which in turn, connects to the data store. The DataDirect connectivity service executes JDBC calls from the application and supports operations on data such as queries, inserts, updates, deletes, invocation of stored procedures and queries of meta data.
Once you have installed the Hybrid Data Pipeline Driver for JDBC, obtaining data with a JDBC application requires the following general steps:
1. Log in to the Hybrid Data Pipeline dashboard and create a data source. A data source defines how to connect to a data store.
2. Optionally, test the connection to the data store as described in Testing the JDBC connection to a Hybrid Data Pipeline Data Source.
3. Configure your application to connect to the Hybrid Data Pipeline Driver for JDBC data source as described in Connecting from an Application to Hybrid Data Pipeline.
As you configure the Hybrid Data Pipeline data source, the JDBC data source, and your application, you will be working with several sets of credentials and connection parameters.
As part of the JDBC URL, the application passes in the user name and password for your Hybrid Data Pipeline account. It also passes in the data source name as the Hybrid Data Pipeline Data Source. If the credentials for the data store are not saved in the data source, the application will need to supply them as part of the URL.
* Testing the JDBC connection to a Hybrid Data Pipeline Data Source
* Connecting from an Application to Hybrid Data Pipeline
* Connecting Through a Proxy Server
* Driver and Data Source Classes