Skip to main content
  • EN

Hi All,

I created a SchemaMapper lookup table in PostgreSQL and used it to map schemas in two scenarios.

  1. When I used ESRI SDE feature class as a reader and PostgreSQL as a writer the SchemaMapper mapped all and no problem
  2. When I used SQLExecutor reading from Microsoft SQL Server database that creates a query from four tables and writing to a Single PostgreSQL table, the SchemaMapper outputs the results as unmapped. I have used AttributeExposer transformer and it still didn't change. please see the screen shot below:

Can anyone please help me fix the issue or let me know if I'm missing anything?SchemaMapper issueThank you in advance

My first hunch would be to check the case of the attribute names in both scenarios, remember that FME is case sensitive when comparing attribute names. Also make sure your SchemaMapper doesn't reference fme_feature_type, in which case you'll have to set it yourself after the SQLExecutor.

Thanks david_r, setting fme_feature_type worked for me.

Reply


Community Stats

30,177
Posts
114,552
Replies
37,839
Members
Terms & ConditionsCookie settings
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.