Copy Data from PostgreSQL to InterBase Automatically

1. Launch Advanced ETL Processor

• Create a PostgreSQL Connection with host, port, database name, username, and password
• Create an Interbase Connection by specifying the database file and credentials

2. Create a New Transformation

Right-click on a transformation group and select New to begin creating your data pipeline.

3. Configure Reader

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

4. Configure Writer

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

5. Map and Format Fields

• Map PostgreSQL fields to Interbase columns
• Apply data type conversions or transformations as needed

6. Run the Transformation

Click the Run button (Green Arrow). Data will be copied from PostgreSQL to Interbase with validation, logging, and monitoring included.