Question

Trying to sync data across from Oracle ESRI GeoDB to Postgres ESRI GeoDB - TROUBLES

  • 27 April 2018
  • 1 reply
  • 0 views

Badge

Hi there. Using a CSV to drive a process that will copy various featureclasses in various schemas to corresponding schemas in a postgres DB. Using a workspacerunner fed the input connection file, the output connection file, and the schema and tablename. Some variations have almost worked, but invariably none of the attributes transfer over and there are too many attribute columns. Please advise.

Thank you.


1 reply

Badge +6

Hi @andypcatbcc,

Do you get a specific error when running your translation? I would recommend breaking down the process if you haven't already. Try doing one table translation dynamically using your CSV to drive the process first. If you are able to get that working go from there.

If you haven't reviewed this article, I highly recommend it. I believe this is likely the best resource to get your translation working: https://knowledge.safe.com/articles/1046/dynamic-workflow-tutorial-destination-schema-is-de-1.html

I hope that helps!

Reply