This section describes how you can connect PostgreSQL with Exasol and then load data. The driver for PostgreSQL is pre-installed with Exasol. You can see the driver details in the EXAoperation (Configuration > Software > JDBC Drivers tab).
Run the following statement to create a connection.
CREATE OR REPLACE CONNECTION JDBC_POSTGRESQL
IDENTIFIED BY 'Exasoltest';
Run the following statement to test the connection.
To view the SQL Server to Exasol migration script, refer to the GitHub repository.