Connect to PostgreSQL DB - JDBC driver setup

Modified on Mon, 13 Nov, 2023 at 12:00 PM

To make Omniscope able to connect to a PostgreSQL database it is first necessary to upload the jdbc driver in the admin app. This is a necessary step the first time Omniscope needs to connect to a PostgreSQL database, or when the PostgreSQL jdbc driver itself needs to be updated (for example after a DBMS update).



If the jdbc driver is not configured, Omniscope will be unable to connect to PostgreSQL, and it will show an error like in the in the image below.


To configure the jdbc driver for snow flake navigate to the admin app, then open the 'Database Drivers' section:


Next, scroll to PostgreSQL section, and follow the download link:


In the new page, download the appropriate version of the jdbc driver for the DBMS you are using.

 

To upload the jdbc driver to Omniscope go back in the 'Database Drivers' section of the admin app, scroll to the top of the page, select 'PostgreSQL' in the 'Database' dropdown, and chose the file downloaded earlier.



Finally click 'Upload' to upload the driver:



After the jdbc driver has been uploaded, Omniscope will be able to use it to connect to PostgreSQL:


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article