Data Connection dialog box - Parameters page

Use the Parameters page to specify what type of data connection object that you are creating.

About this task

All data connection objects are associated with a particular type of stage. The parameters associated with that stage are displayed and you can choose whether to supply values for them as part of the data connection object. You can choose to leave out some parameters; for example, you might not want to specify a password as part of the object. In this case you can specify the missing property when you design a job using this object.

You can create data connection objects associated with the following types of stage:

  • Connector stages. You can create data connection objects associated with any of the connector stages.
  • Parallel job stages. You can create data connection objects associated with any of the following types of parallel job stages:
    • DB2/UDB Enterprise stage
    • Oracle Enterprise stage
    • Informix® Enterprise stage
    • Teradata Enterprise stage
  • Server job stages. You can create data connection objects associated with any of the following types of server job stages:
    • ODBC stage
    • UniData stage
    • Universe stage
  • Supplementary stages. You can create data connection objects associated with any of the following types of supplementary stages:
    • DRS stage
    • DB2/UDB API stage
    • Informix CLI stage
    • MS OLEDB stage
    • Oracle OCI 9i stage
    • Sybase OC stage
    • Teradata API stage

Procedure

  1. Choose the type of stage that the object relates to in the Connect using Stage Type field by clicking the browse button and selecting the stage type object from the repository tree. The Connection parameters list is populated with the parameters that the connector stage requires in order to make a connection.
  2. For each of the parameters, choose whether you are going to supply a value as part of the object, and if so, supply that value.

Results

You can also specify that the values for the parameters will be supplied via a parameter set object. To specify a parameter set in this way, step 2 is as follows:

  • Click the arrow button next to the Parameter set field, then choose Create from the menu. The Parameter Set window opens.

For more details about parameter set objects, see Making your jobs adaptable.