Creating a data source definition entry
Configure the JDBC Gateway for access to data sources.
Before you begin
Also, the compliant JDBC driver should be added to the JDBC Gateway. See Adding JDBC driver information for a data source.
About this task
Procedure
- In the JDBC Gateway administrative console, click the Add New Data Source button.
-
In the JDBC Gateway dialog, complete the following fields.
Field Action Location Enter the location name. A valid value is a string 1 - 16 characters. For example: ORCL. Note: This value must match the LOCATION value that will be specified for the corresponding data source definition in the Data Virtualization Manager server configuration file.Connection Parameters Enter the JDBC connection information, as follows: - JDBC Driver: Specify the library for the JDBC driver that will be used to access the data source. Select a library from the drop-down list, or click the ellipsis (…) option to the right of the field to open the Select JDBC Driver dialog where you can create additional JDBC driver libraries. (For more information, see Adding JDBC driver information for a data source.)
- JDBC URL: Specify the URL that points to the data source to which you
want to connect. The format for the URL can be displayed in the drop-down list if a JDBC URL
template was supplied when the driver was configured. Note: You can also use the Build URL by URL-Template dialog box to form the correct string. Click Build URL to open the Build URL by URL-Template dialog box. 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. This feature is available if a JDBC URL template was provided when the driver was configured.
- Advanced: Click Advanced to specify any driver-specific connection string keywords and their values that will be used for the data source. The list of available advanced properties will change depending on both the type of driver being used, and the version of the driver. For information on any keywords that are required by a selected database driver, see the documentation for the driver.
Set User Information Click Set User Information to provide authorization information used when accessing the data source. Provide the following information on the User Information dialog: - User ID and password are required: Select this option to require the use of a user ID and password when accessing the data source. If the data source allows access without a user ID and password, selecting this option will override that allowance.
- Allow users to save password: Select this option to allow users to save passwords.
- Allow users to change password: Select this option to allow users to change passwords. (Note: This option is for Db2 only.)
- User name and Password: Specify the user ID and password that will be used to access the data source. The user ID and password that you specify when connecting to the data source are used to authorize the user.
Test Connection Click Test Connection to test the connection to the data source. If you have specified any information incorrectly, you will not be able to connect. - Click Finish.