Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

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
  11. Troubleshooting

PostgreSQL Connector

PostgreSQL Connector

Use the same object path for the migrated mapping

Use the same object path for the migrated mapping

If you want the migrated mapping in Org 2 to use the same object path as in Org 1, you must maintain the same schema and table in the PostgreSQL connection for Org 2.
For example, if you have two different connections, Connection1 used for Org 1 and Connection2 used for Org 2, the object path for the schema and table name must be the same in both the connections:
Connection1: SCHEMA1/TABLE1
Connection2: SCHEMA1/TABLE1
In this scenario, you do not need to override the schema and table in the advanced properties.

0 COMMENTS

We’d like to hear from you!