A database connection lets you access database data sources. With a database connection, you can read data from database tables, perform SQL queries or insert records into database tables. These actions are taken by the components using a database connection.
There are two ways of accessing a database:
Each database connection requires a JDBC driver. JDBC drivers for commonly used databases are included in CloverETL Designer.
|When using database connections in a CloverETL Server project, all database connectivity is performed server-side. One of the benefits is that database servers accessible from CloverETL Server can be also used from within CloverETL Designer.|
Database Connection Properties dialog is described in Database Connection Properties.
Access password can be encrypted. See Encryption of Access Password.
Database connection can serve as a resource for creating metadata. See Browsing Database and Extracting Metadata from Database Tables.
Remember that you can also create a database table directly from metadata. See Create Database Table from Metadata.