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
Check Db connections	Verifies the connectivity with one or several databases.
Table exists	Verifies that a specified table exists on a database.
Columns exist in a table	Verifies that one or more columns exist in a database table.
Truncate tables...