Creating a relational data source

You must add configuration information to your repositories for all relational data sources.

1. In the Repositories view, on the Data Sources tab, click Create a Data Source. The Create New Data Source wizard opens.
2. In the wizard, select Relational and click Next.
   The Add new relational data source name and connection parameters page opens.
3. In the Data Source Name field, specify the name for the data source.
4. In the JDBC Driver field specify the library for the JDBC driver that will be used to access the database that is hosting the repository storage. You can select from a drop down list of libraries that you defined when you set up the JDBC driver information. You can use the ellipsis (...) to the right of the field to open the Select JDBC Driver dialog where you can create additional JDBC driver libraries.
   Note: If you work with a Db2® for z/OS® database, you can use the Direct DRDA Connection. In contrast to JDBC libraries, the Direct DRDA Connection comes with QMF and does not require additional driver installation.

   You can enable the use of SSL certificates for the Direct DRDA Connection to make the connection secure.

   Note: The Direct DRDA Connection is supported only for DB2 for z/OS version 9 and later. Do not use it for Db2 LUW or DB2® for iSeries.

   See Using DRDA to connect to database repositories and data sources for more information.

5. In the JDBC URL list, specify the URL that points to the database that hosts the repository storage within which the repository to which you want to connect resides.

   The format for the URL can be displayed in the list.

   Note: You can also use the Build URL by URL-Template dialog to form the correct string.

   Click Build URL to open the Build URL by URL-Template dialog. From the JDBC URL drop-down list, select the template. In the table, specify the server, port, and database information and click OK. The result URL string is added to the JDBC URL list.

6. Click Advanced to specify any driver-specific connection string keywords and their values that will be used when connecting to this shared repository. For information on any keywords that are required by a selected database driver, consult the specific driver's documentation.
   Note: For the DB2® Type 4 UDB driver, to receive extended SQL exception error messages, check the retrieveMessagesFromServerOnGetMessage option in the Advanced JDBC Settings window.
7. Optional: To configure a PassTickets-based Single Sign-on connection between QMF and Db2 for z/OS database, click Single Sign-on.
8. If you use the Direct DRDA Connection, bind packages by clicking the Bind Packages button.
9. Click Set User Information.
   The User Information window opens.
10. Select the User ID and password are required check box to specify that user information will be requested each time this data source is accessed. This check box can be left clear if the data source does not require logon information, or if the logon information is obtained using some other means, such as Kerberos or Windows authentication.
11. Select the Try to use repository login and password to connect to this data source check box to specify that before requesting logon information from the user, the current repository login and password will be used to try and connect to the data source (such as the case in Kerberos security).
12. Specify the user ID and password that will be used to access the data source in the User name and Password fields. Click OK.
    The User Information window closes and control returns to the Create Relational Data Source wizard.
13. To test the connection, click Test Connection.
14. Click Next. The second page of the Create Relational Data Source wizard opens where you will enable the QMF catalog plug-in for the data source.