Table of Contents

Search

  1. Preface
  2. Introduction to PostgreSQL Connector
  3. Connections for PostgreSQL
  4. Mappings and mapping tasks with PostgreSQL Connector
  5. PostgreSQL objects in mapping tasks
  6. Lookup transformation
  7. SQL transformation
  8. Migrating a mapping
  9. PostgreSQL SQL ELT optimization
  10. Data type reference

PostgreSQL Connector

PostgreSQL Connector

Migrating a mapping

Migrating a mapping

You can configure a connection and mapping in one environment and then migrate and run the mapping in another environment.
Data Integration
uses the configured runtime attributes from the earlier environment and runs the mapping successfully in the new environment.
You can also migrate mappings configured in advanced mode. After the migration, you can change the connection properties from the Administrator service, but you do not need to modify the mapping.
Consider a scenario where you develop a mapping in the development organization (Org 1) and then you migrate and run the mapping in the production organization (Org 2). After you migrate, you might want to use the same or a different connection endpoint or object path in Org 2. Based on your requirement, follow the guidelines in this section before you plan the migration.

0 COMMENTS

We’d like to hear from you!