Connecting to a JDBC data source

To access JDBC data sources, you must define a connection by using the properties in the Connection section on the Properties page.

Before you begin

  • Create the isjdbc.config driver configuration file and specify information about the drivers in this file.
  • Define a job that includes a JDBC Connector stage.

Procedure

  1. To open the stage editor, on the job design canvas, double-click the JDBC Connector stage icon.
  2. On the Properties page, specify values for the connection properties. In the URL property, specify the URL string for the JDBC data source in the driver-specific format.
  3. In the Username and Password connection properties specify the credentials of the user to authenticate and authorize for the connection. Note that some drivers support including username and password values directly in the URL connection string. For more information, see your driver documentation.
  4. In the Attributes property specify any additional driver-specific connection properties for your driver. For example, if the driver supports SSL connections, provide the SSL connection properties here. Each driver specific connection property should be entered as a separate line in property_name=property_value format. Note that some drivers support including driver specific connection properties directly in the URL connection string. For more information, see your driver documentation.
  5. Click OK to save the details.