Creating JDBC Legacy Output Connector

Allows periodical dumping of records from a Kafka topic into a JDBC database.

1. On the Data Source tab, select Output > JDBC Legacy in the Connector drop-down list.
2. Define or select the following properties:
   • JNDI Name

     Enter the JNDI resource name to be used.

     NOTE: The JNDI resource name needs to be on the form:

     java:/comp/env/jdbc/[resourcename]

   • URL

     Enter the URL specific to the database’s JDBC driver, the Driver Class Name specific to the driver, and the User Id and Password.

3. Select the appropriate SQL Dialect in the drop-down list to be able to generate the correct SQL for the required data repository.

   You can select any of the following SQL dialects: AnsiSQL, MySQL, Oracle, SQL Server, SAP IQ, SAP ASE, Netezza, Vertica, SQLite, HadoopHive, DB2, PostgreSQL, Impala, Redshift, Informix, Teradata, dBase, SparkSQL.

4. Enter the source Table (can be parameterized).
5. You may opt to use the toolbar to complete the data source definition.
6. Click  . The new data source is added in the Data Sources list.

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support