Skip to main content
Question

Can FME access a PostreSQL FDW?

  • Jun 22, 2021 11:53 PM UTC
  • 2 replies
  • 86 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
  • Author
  • Contributor
  • Jun 23, 2021 12:08 AM UTC

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
  • Author
  • Contributor
  • Jun 24, 2021 2:15 PM UTC

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.