POSTGRESQL

For on premise installation, Data Lake connection is not required.

To setup POSTGRESQL as data warehouse, you need to follow below steps

1. Navigate to Settings.

2. Click on Destination

3. Click on Setup Data Warehouse.

4. Insert all the data warehouse specific credentials, along with a name and description for the connection.

5. Click on Validate and then Create to save the data warehouse connection.

Host	Host name of the database
Port	Port of the database
DB Name	Name of the database
Default Schema	Default schema created in database by xGen
User	Username to access database
Password	Password associated with the username
JDBC URL Params	Additional properties to pass JDBC URL string when connecting to database
SSL Connection	Encrypt data using SSL.
SSL Modes	SSL connection modes.
SSH Tunnel Method	Whether to initiate SSH tunnel before connecting to the database