Copy Data from PostgreSQL to a database available through ODBC Automatically

1. Launch Advanced ETL Processor

• Create a PostgreSQL Connection using host, port, database name, username, and password
• Create an ODBC Connection by selecting an existing DSN (Data Source Name) or setting up a new one

2. Create a New Transformation

Right-click on a transformation group and choose New to begin your workflow.

3. Configure Reader

• Double-click the reader to open Reader Properties
• Select the PostgreSQL connection
• Choose a table or use a SQL SELECT query

4. Configure Writer

• Double-click the writer to open Writer Properties
• Select the ODBC connection
• Choose the target table and define insert mode (append, replace, truncate)

5. Map and Format Fields

• Map PostgreSQL fields to ODBC destination fields
• Apply data type conversions and transformations as necessary

6. Run the Transformation

Click the Run button (Green Arrow). The data will be transferred from PostgreSQL to your ODBC-connected destination with built-in error handling and audit logging.