Database

To use database tables as datasources, select Database and define the database and tables.

To add a new connection, proceed as follows:

1. Click Add to open the Database Wizard dialog box.
2. Type in a name for the bookmark in the Name field, which will show on the list of database connections available in the Preferences window. Click Next to continue.
3. Fill in the User id and Password fields. Select the relevant Database Type from the list. If needed, select the relevant database version from the Version drop-down list. Then, type in specific database URL information:Hostname, Port, and DBname.
   Information noteNote: If you want to use a custom JDBC URL, select the Use Custom JDBC Url check box and fill the Url field with the relevant JDBC URL.
4. Click Check to check the connection.

   If a library or driver (.jar file) is missing, a dialog box is displayed inviting you to install it.

   When the required library or driver is installed, close the window and click Check again to check the connection parameters.

   Talend Studio provides multiple approaches to automate the installation. For further information, see Installing external modules to Studio.

5. Click Next to continue.
6. Click Select to define in the list the tStatCatcher, tLogCatcher and tFlowMeterCatcher tables where the activity monitoring information will be retrieved from.

   An error message will appear in case of any connection error or failure.

7. Click Finish to validate your configuration.

If you use project settings or Job settings for activity monitoring, make sure that the database tables selected here match what you have configured in the Stats & Logs settings. For more information about the project settings or Job settings, see Enabling activity monitoring.

If you use the tStatCatcher, tLogCatcher and tFlowMeterCatcher components for activity monitoring, make sure that the connected Output components are of database type (Databases folder, on the Palette).