Connect to postgresql

3 posts / 0 new
Last post
im-alexandre
Offline
Joined: 02/28/2020 - 19:25
Connect to postgresql

Hi guys, 
I want to import my data to a postgresql database so then Access it using IDEA.
It's hard to find a tutorial showing how to Setup The connection.
Someone can help me?
I don't use IDEA, but I'm responsible for taking data from severa sources (including webscraping) and delivery it to IDEA users. 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi im-alexandre,

Unfortunately I have never done anything like this so I can't be of help.  Something like this I would suggest you send a ticket to the IDEA help desk and they would be able to help you out.

idemnos's picture
idemnos
Offline
Joined: 06/17/2016 - 13:25

Hi there.
First, you need to keep in mind that idea uses odbc to manage connections to database managers as SQL SERVER, SYBASE, ORACLE and POSTGRESQL. So you need to be sure about if you have installed postgre drivers in the PC you are using idea, and if your version is 32 or 64 bits, drivers have to be the same type.
Second, use this tutorial and try to complete them. When you finish, comment the result.
https://help.interfaceware.com/v6/connect-to-postgresql-from-windows-wit...
Hope it help.