How to connect to PostgreSQL / SDE

Hi,

 

 

 

I'm trying to write to an ArcGIS SDE database in PostgreSQL. I have:

• FME Workbench 2018.1 64 bit
• ArcGIS Desktop 10.4.1
• ArcGIS Desktop 10.4.1 Background Geoprocessing 64 bit
• ArcGIS Pro 2.2

 

First, I got this error:

Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set}

 

I solved this by setting the SDEHOME variable to C:\\Program Files\\ArcGIS\\Pro, so that the 64 bit SDE dll's can be found.

But now I get:

Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.}

 

The 64 bit PostgreSQL client dll's are in C:\\Program Files\\ArcGIS\\Pro\\bin, but I'm not sure how to instruct FME to use these.