When you migrate, you can choose one of the following options to update the object path:
Option 1. Update the connection properties to reference the new object
When you import the mapping to the new environment, you can change the existing
connection in the
Review Connections
section to one that has
access to the specified schema and table in the new environment.
Option 2. Override the properties from the
advanced properties
Before the migration, specify the required schema and table name for the object from
the new environment in the advanced properties of the mapping in the earlier
environment. After the migration, when you run the mapping, the Secure Agent uses
the configured advanced parameters to override the object specified in the mapping
imported from the earlier environment.
Option 3. Parameterize the properties in the mapping
You can choose to parameterize the advanced attributes, such as the schema and table name
before the migration. You can configure input parameters, in-out parameters, and
parameter files in the mapping.
If you have used in-out parameters, you can change the schema and table attributes using the
parameter file so that the changes are applied when the task runs.
You can't override the input parameters from the parameter file in the advanced properties. You
need to use the in-out parameter to override the value from the parameter file.
Parameterizing only the advanced properties, but not the object in the mapping
If you want to parameterize only the advanced properties and use them at run time, select a
placeholder object in the object properties within the mapping, and then
specify an override for this placeholder object in the advanced
properties.
Ensure that the placeholder object contains the same
metadata as the corresponding table that you specify as an override.
When you run the mapping, the value specified in the advanced property
overrides the placeholder object.
Parameterizing both the object and the advanced properties
If you want to keep both the JDBC V2 object type and the advanced fields parameterized, you
need to leave the
Allow parameter to be overridden at
runtime
option cleared in the input parameter window while
adding the parameters, and then select the required object at the task
level. When you run the task, the values specified in the advanced
properties take precedence.
ASK INFAPreview
