Required parameters
When deploying the JDBC to JDBC ReadyFlow, you have to provide the following parameters. Use the information you collected in Prerequisites.
| Parameter name | Description |
|---|---|
| Destination Database Connection URL | Specify the JDBC database connection URL used to connect to your destination database. May contain database system name, host, port, database name and some parameters. The exact syntax of a database connection URL is specified by your DBMS, for example, jdbc:mysql://hostname:port/database for MySQL databases. |
| Destination Database Driver | Upload the database driver jar file for your destination database. |
| Destination Database Driver Class Name | Specify the destination database driver class name. For example, com.mysql.jdbc.Driver for MySQL databases. |
| Destination Database Password | Specify the destination database password. |
| Destination Database Table Name | Specify the destination database table name. |
| Destination Database User | Specify the destination database user. |
| Filter Rule | Specify the filter rule expressed in SQL to filter database records. Records matching the filter are written to the destination. The default value forwards all records. |
| Source Database Connection URL | Specify the JDBC database connection URL used to connect to your source database. May contain database system name, host, port, database name and some parameters. The exact syntax of a database connection URL is specified by your DBMS, for example, jdbc:mysql://hostname:port/database for MySQL databases. |
| Source Database Driver | Upload the database driver jar file for your source database. |
| Source Database Driver Class Name | Specify the source database driver class name. For example, com.mysql.jdbc.Driver for MySQL databases. |
| Source Database Incremental Fetch Column | Specify the column that should be used to track state as new data lands in the source table. |
| Source Database Password | Specify the source database password. |
| Source Database Table Name | Specify the source database table name. |
| Source Database User | Specify the source database user. |
