Skip to main content
Question

Can FME access a PostreSQL FDW?

  • June 22, 2021
  • 2 replies
  • 20 views
pbyhistorian
Contributor
Forum|alt.badge.img+3

When I add a Reader in FME Workbench 2019.2, I cannot connect to a PostgreSQL FDW (Foreign Data Wrapper). I can select (check) the FDW schema, but I cannot open the list of tables. (The FDW is in a PostgreSQL table and I can access the PostgreSQL schemas just fine.)

 

DataGrip can open the FDW schema and its tables just fine using the exact same connection (host, database, username, and password).

 

There seems to be almost nothing in Google about FME and PostgreSQL FDW. Is it impossible, or is it just too obvious for me to figure out?

2 replies

pbyhistorian
Contributor
Forum|alt.badge.img+3
  • pbyhistorianContributor
  • Author
  • Contributor
  • 12 replies
  • June 23, 2021

Yes, it was too obvious for me to figure out.

 

I left the schema box unchecked and included the schema name in the table name. It's working now.

pbyhistorian
Contributor
Forum|alt.badge.img+3
  • pbyhistorianContributor
  • Author
  • Contributor
  • 12 replies
  • June 24, 2021

Yes, it was too obvious for me to figure out.

 

I left the schema box unchecked and included the schema name in the table name. It's working now.

Curious thing though: if I so much as touch the Reader's User Attributes list, or change "Attributes to Read", the geometry field disappears from the Attribute list and will only come back by using Undo.


Community Stats

32,066
Posts
121,750
Replies
39,692
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.