Forum Discussion
Connect to PostgresSQL on a server hosted locally with encrypted data
Hello every body, I'm fairly new to Power BI and I am focused on data analytics therefore technical issues are way out of my reach. I am trying to link my PowerBI to our DB which is hosted on...
Anonymous,
Are you able to decrypt the column in other postgreSQL GUI tool by writing the SQL statement?
Regards,
Lydia
Anonymous,
Are you able to decrypt the column in other postgreSQL GUI tool by writing the SQL statement?
Regards,
Lydia
Hey Anonymous, thanks for your help !
No we use pgcrypto and try to decrypt PBEwith MD5 & DES but we can't via SQL it says :
ERROR: Unsupported cipher algorithm
********** Error **********
ERROR: Unsupported cipher algorithm
SQL state: 39000
We don't understand why but it feels like we will have to change encryption...
Leonard