Verifying a connection, running DDL scripts, and doing other useful tasks
When you work with databases, before performing CRUD operations, you may want to run other useful tasks, for example, verify if a database is accessible, clean up some tables before execution, and more. Look at the following sample job:
Sample job that runs some database-related tasks
This job verifies the connectivity with a database connection. If the database is accessible, it creates a table—as soon as the table doesn't exist. After that, it executes a Transformation. If the database is not available, a message is written to the log.
Besides these, there are some other job entries that can be useful for database-related tasks. The following table summarizes them:
Job entry | Purpose |
| Verifies the connectivity with one or several databases. |
| Verifies that a specified table exists on a database. |
| Verifies that one or more columns exist in a database table. |
|