Database Connections

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 access to a database:

Each database connection requires a JDBC driver. JDBC drivers for commonly used databases are included in CloverETL Designer.

[Note]Note
Database Connections in CloverETL Server Projects

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 connections can be internal or external (shared). Internal database connection can be converted to external one and back.

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 resource for creating metadata. See Browsing Database and Extracting Metadata from Database Tables.

Remember that you can also create database table directly from metadata. See Create Database Table from Metadata.