Database Connector

The Database connector is a simplified version of the JDBC Connector. The Database connector is intended to provide a more user-friendly user interface to configuring a database. All advanced parameters are removed from the connector configuration form and the most commonly used parameters are the only available ones.

For behaviour, Connector Modes and so forth, see the appropriate sections of the JDBC Connector. Specifically, for information on where to place driver libraries in order to be able to set up a connection to a database system, see Understanding JDBC Drivers; however, the Database connector automates some of the process of creating a JDBC URL.

Configuration

The Database Connector requires the following parameters:

Database Type

This section prompts you for hostname, port and database parameters. Based on the database type dropdown selection the jdbcDriver and jdbcSource parameters are generated.

Username

Signon to the database using this username; only the tables accessible to this user will be shown. This reflects the jdbcuser parameter of the JDBC connector.

Password

The password used in the signon for the user.

Table Name

The name of the table you wish to access with this connector. We can use the Select button to query the database for accessible tables, provided you are able to signon to the database.