Skip to main content
Question

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

  • April 27, 2018
  • 1 reply
  • 20 views

Forum|alt.badge.img

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

trentatsafe
Safer
Forum|alt.badge.img+6
  • Safer
  • April 27, 2018

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!