Set database-specific options

Use the Advanced option in the Database Connection dialog box to configure properties associated with how SQL is generated. With these properties, you can set a standard across all your SQL tools, ETL tools, and design tools.

1. Open the Database Connection dialog box in PUC or PDI.

2. Click Options in the left pane.

   The Parameters table appears as shown as shown below:

3. In the next available row of the Parameters table, enter a valid parameter name and its corresponding value. For JDBC database-specific configuration help, click Help.

   A new browser window opens and displays additional information about configuring the JDBC connection for the database type that is currently selected in the General pane.

4. Click Test.

   A success message appears if the connection is established.

5. Click OK to close the connection test dialog box.

6. To save the connection, click OK to close the Database Connection dialog box.