skip to main content
Getting started
 

Try DataDirect Cloud Now

Getting started

JDBC™ provides an API that Java applications can use to access a database using Structured Query Language (SQL). The DataDirect Cloud Driver for JDBC, which is compliant with JDBC 4.0 and earlier specifications, works with the DataDirect Cloud connectivity service to provide SQL access to supported cloud data stores from any JDBC application.
To access cloud data using DataDirect Cloud you must first obtain a Progress ID and evaluate or purchase DataDirect Cloud. The relationship between the DataDirect Cloud Driver for JDBC and the connectivity service is shown in the following figure.
The DataDirect Cloud Driver for JDBC connects to a DataDirect cloud Data Source, which in turn, connects to the cloud 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 DataDirect Cloud Driver for JDBC, obtaining cloud data from a JDBC application requires the following general steps:
1. Log in to the DataDirect Cloud dashboard and create a Data Source. A Data Source defines how to connect to a cloud data store. Watch a short video on how to create a data source.
2. Optionally, test the connection to the cloud data store as described in Testing the JDBC connection to a cloud Data Source.
3. Configure your application to connect to the DataDirect Cloud Driver forJDBC data source as described in Connecting from an application.
As you configure the DataDirect Cloud Data Source, the JDBC data source, and your application, you will be working with several sets of credentials and connection parameters. The following diagram shows which credentials are stored in the DataDirect Cloud connectivity service Data Source, which are specified by the application, and how the values map.
Graphic shows the sending credentials for the data source
As part of the JDBC URL, the application passes in the user name and password for your DataDirect Cloud account. It also passes in the Data Source name as the Database Name. If the credentials for the cloud 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 cloud Data Source
* Connecting from an application
* Connecting through a proxy server
* Driver and Data Source classes
* Connection URL