Home | Table of Contents | Database Connections | CloverETL 4.6.1
--- | --- | ---
Prev | Connections | Next

## 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:

- 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
##### 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.

- 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 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.

Prev | Up | Next
Connections | Home | Table of Contents | Internal Database Connections