Setup Connection with Source as Postgres

1. Go to Connections in the Fivetran Dashboard.
2. Click Add connection.
3. Search and select Postgres.
4. Click Setup.
5. Choose the Teradata destination configured in the previous step.
6. Fill in the PostgreSQL source details.
7. Enter the required connection details.
8. Host: Provide PostgreSQL instance hostname
9. Port: Provide Port Number
10. User: PostgreSQL instance username
11. Password: PostgreSQL instance password
12. Database: Target database name
13. Connection method: Choose a connection method based on your PostgreSQL setup. Refer to the PostgreSQL Setup instructions for more information about the available connection methods. This guide uses the Connect directly connection method.
14. Update Method: Choose your incremental sync method. This guide uses the Logical Replication sync method.
15. Click Save & Test and confirm the connection success.
16. Click on Continue to begin the initial data load. Wait until the sync status changes to Initial sync complete.