Ready for Dataiku 10? Try out the Crash Course on new features!GET STARTED

Connection Between Dataiku DSS and PostgreSQL

Alexx
Level 2
Connection Between Dataiku DSS and PostgreSQL

I tried to connect DSS and PostgreSQL, everyhting seems fine until i try to Import tables to dataset. 
I get the following error :

"An invalid argument has been encountered : Postgress connection JDBC URL is not set", i dont know where I should get the JDBC URL and where to set it.

Operating system used: Windows 10

Operating system used: Windows 10
0 Kudos
3 Replies
AlexT
Dataiker
Dataiker

Hi @Alexx ,

Can you please try removing the "Use custom JDBC URL" checkbox. This would then allow you to enter the hostname/ip and port of you PostgreSQL install.Screenshot 2021-12-13 at 12.22.49.png

Thanks,

 

Alexx
Level 2
Author

Ok, I did that and now it's even wort, it's an error in french that says that the password is incorrect .

0 Kudos
AlexT
Dataiker
Dataiker

Hi,

The error is in French because of the locale of the VM. Either way it suggests that username/password are incorrect. 

If you have PostgreSQL access you can try re-running :

psql -h localhost
CREATE DATABASE dku;
\c dku
CREATE SCHEMA dku_churn;
CREATE USER matthieu WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_churn TO matthieu;
CREATE SCHEMA dku_tshirt;
CREATE USER dku_tshirt_admin WITH PASSWORD 'Password';
GRANT ALL PRIVILEGES ON SCHEMA dku_tshirt TO dku_tshirt_admin;
\q
0 Kudos