Setting up your data connections

If your job will read or write an external data source, then you must set up data connections.

You can save the details of these connections as data connection objects. Data connection objects store the information needed to connect to a particular database in a reusable form. See Connecting to data sources.

You use data connection objects together with related connector stages to define a connection to a data source in a job design. You can also use data connection objects when you import metadata.

If you change the details of a data connection when designing a job, these changes are reflected in the job design. When you compile your job, however, the data connection details are fixed in the executable version of the job. Subsequent changes to the job design will once again link to the data connection object.