We now have a copy of the database in postgres, so I'm just opening an issue to add my test connection work and (if needed down the road) scripts to compare the databases.
On my local computer I’m able to authenticate and execute queries in the zdt database.
On the linux machine (analytics server) I’m able to authenticate but not able to execute queries against the zdt database.
On the linux machine (analytics server) I am able to authenticate and execute queries against the the lead database, so I don’t think it’s a driver issue.
We now have a copy of the database in postgres, so I'm just opening an issue to add my test connection work and (if needed down the road) scripts to compare the databases.