JDBC Reader Parameters

Add Named Database Connection: Named Connections store (in a central location) authentication information associated with a user.

For information about setting up and using named connections, please see:

Using Named Database Connections

The connection string for the database to which you are connecting. The precise format depends on the JDBC driver being used, but a connection string will always start with:

jdbc:<subprotocol>:

If not specified in the JDBC Connection String, enter the username and password to access the database.

This parameter defines the time, in seconds, after which a query will be terminated if it has not yet returned a result.

If set to zero, there is no timeout.

After you have completely specified the database connection, click the Browse button to select tables to import. A connection window appears while FME reads a table from the database.

Once the table list appears, you can select one or more tables, and then click OK to dismiss the window. The table name(s) will appear in the table list field in the Reader Parameters box.

This parameter exposes Format Attributes in Workbench when you create a workspace:

• In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
• In a non-dynamic scenario where you have multiple feature types, it is convenient to expose additional attributes from one parameter. For example, if you have ten feature types and want to expose the same attribute in each one, it is easier to define it once than it is to set each feature type individually in the workspace.