Database Connections
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:
- You have a client on your computer that connects to a database located on some server by means of some client utility. This approach is used in bulkloaders.
- You use a JDBC driver.
Each database connection requires a JDBC driver. JDBC drivers for commonly used databases are included in CloverETL Designer.
![[Note]](figures/note.png) | Note |
|---|---|
Database Connections in CloverETL Server ProjectsWhen 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.
Internal: See Internal Database Connections.
External (shared): See External (Shared) Database Connections.
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.