JDBC
The Java Database Connectivity (JDBC) API provides universal data access from the Java programming language. Using the JDBC API, you can access virtually any data source, from relational databases.
The connector can be used for SQL databases, on-premise (SQL Server Managed Instance), as an input data source or output data sink for Spark jobs.
Steps to create Datastore for JDBC#
Click on the action button (
) from the Datastores section in Left Navigation and select JDBC connector. Alternatively user can launch from Create New Datastore link in Activity authoring UI or Copy Data tool.Enter the Datastore name for the new datastore and click Ok
Update the connection name or leave the default. You can refer to Connection and Environments for more details
Users have to choose from two options like Custom or Standard.
Enter the connection details properties as described below:
If Standard is chosen :#
| Property | Description | Required |
|---|---|---|
| Vendor | Users have to choose SQL server from given options like SQL server, MySQL, Oracle, PostgreSQL. | Yes |
| Driver Class | Selecting Vendor this property is automatically fielded by Guzzle. | Yes |
| Hostname | Hostname of selected server. | Yes |
| Port | On which port selected server is running. | Yes |
| Database | Name of Database. | Yes |
| Username | Username of server. | Yes |
| Password | Password to connect to MySQL server. For specify password the following options are available: 1. Manual: Provide password directly. 2. Azure Key Vault: To use Azure key vault feature user have to integrate Key Vault with Guzzle for that visit here. Give value of the key vault name and secret name where password is stored in Azure Key Vault instance. | Yes |
Below gif represents created JDBC datastore :
If Custom is chosen :#
| Property | Description | Required |
|---|---|---|
| Driver Class | Selecting Vendor this property is automatically fielded by Guzzle | Yes |
| Hostname | Hostname of selected server | Yes |
| Jdbc URL | JDBC URL for connecting to SQL server Example: jdbc:mysql://<hostname>/ <databaseName> The URL can optionally contain database name, username and other connection properties. | Yes |
| Username | Username of server | Yes |
| Password | Password to connect to MySQL server. For specify password the following options are available: 1. Manual: Provide password directly. 2. Azure Key Vault: To use Azure key vault feature user have to integrate Key Vault with Guzzle for that visit here. Give value of the key vault name and secret name where password is stored in Azure Key Vault instance. | Yes |
