JDBC connector
When using the JDBC connector, you can choose between using a PostgreSQL, MySQL or Hive databases. Based on the connector type you choose, there are mandatory fields where you must provide the correct information.
- Template: jdbc
- Using either PostgreSQL, MySQL or Hive as databases. When you use the JDBC connector, you must specify the JDBC database which are going to be used for the connection.
Using the JDBC connector
You can access and import the templates of the JDBC connector from Streaming SQL Console:
- Navigate to the Streaming SQL Console.
- Navigate to , and select the environment where you have created your cluster.
- Select the Streaming Analytics cluster from the list of Data Hub clusters.
- Select Streaming SQL Console from the list of services.
The Streaming SQL Console opens in a new window.
- Select Console from the main menu.
- Click Templates under the SQL window.
- Select the JDBC template.
The template is imported to the SQL window.
- Provide information to the mandatory fields of the template.
- Click Execute.