For a test, I created this simple Talend job
the tRowGenerator generates a row with int column and is staged to temporary database on postgres.
The issue occurs whenever I run the job. The tDBOutput component thinks it uses the SQL Server connection, but I know it uses the PostgreSQL database connection.
If I swap the SQL Server initialization to the end of the pre-job, the job runs successfully.
However, if I add an SQL Server tDBInput or tDBOutput component and PostgreSQL happens to be initialized at the start of the tPreJob, they are considered as if they are using the PostgreSQL connection.
What am I missing here..