JDBC Writer

Properties that can be configured for the JDBC Writer.

Syntax Use this component to write data to relational databases such as MySQL, MS SQL Server, DB2, Oracle, SAP MaxDB, and SAP HANA.
JDBC Writer Properties
Table 1: Data Writer Properties
Property Description
Database Type Select the database type.
Database Driver Path Enter the location of the JDBC driver path. For example, to write to the Oracle database, you need to specify the location of the Oracle JDBC jar (C:\ojdbc6.jar)
Database Machine Name Enter the name of the machine on which the database is installed.
Port Number Enter the database or service port number.
Database Name Enter the name of the database.
User Name Enter the database user name.
Password Enter the password for the database user.
Table Type Enter the type of the table. This property is applicable when writing to the SAP HANA database.
Table Name Enter the table name.
Overwrite, if exists Select this option to overwrite the table if it already exists.