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.
- Type: source/sink
- The following fields are mandatory to use the connector:
url: The URL of the JDBC database. No default value is specified.
table-name: The name of the JDBC table in the database that you need to connecto to. No default value is specified.
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.
- Go to your cluster in Cloudera Manager.
- Click on SQL Stream Builder from the list of Services.
- Click on the SQLStreamBuilder Console.
The Streaming SQL Console opens in a new window.
- Click Create Job or select a previous job on the Getting Started page.
- Click Templates at the SQL Editor.
- Select the JDBC template.
The template is imported to the SQL window.
- Provide information to the mandatory fields of the template.
- Click Execute.