How to connect to Incorta from external sql query tools like DbVisualizer or PSequel
1) Make sure that the SQL app is enabled from Incorta CMC and adequate memory and cores assigned to it.
2) Start DbVisualizer.
Create a new PostgreSQL connection and configure the Database server as the Incorta server host name or IP address , Port can be 5436 (recommended, this is the engine port with spark fallback) or 5442 (routes directly to spark) . Make sure the ports are open.
Click on Ping Server and if that works then click on Connect.
3)Now connect to it and test a sql query , please note that schema and table names are case sensitive