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
Thanks for your answer I had seen this post but it did not work for me :/
I will precise my issue:
We are using Jasypt lib to encrypt data and PBEWithMD5AndDES algorithm
We have installed pgcrypto extension and tried to call that function on encrypted column, but it did not work.
If you have a solution for me that would be amazing!
Anonymous,
Are you able to decrypt the column in other postgreSQL GUI tool by writing the SQL statement?
Regards,
Lydia