JDBC™ provides an API that Java applications can use to access a database using Structured Query Language (SQL). The Hybrid Data Pipeline Driver forJDBC, 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 forJDBC 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 forJDBC, 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.
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.
