0

How to connect to Incorta from external sql query tools like DbVisualizer or PSequel

We can use external sql query tools like DbVisualizer or PSequel to connect to Incorta and run postgres sqls against the Incorta data. Here are the steps to enable it - 

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

  

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 mths agoLast active
  • 21Views
  • 1 Following

Product Announcement

Incorta 5 is now Generally Available