Hello, I would like to be able to call a table in an sde according to the choice of the upstream user. And then retrieve the fields from this table.
Is it possible with PythonCaller? Thank you 
Question
Open table with python caller
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.
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.
I doesn't work. I'm with Safe to see why but for the time being we don't know why i doesn't work. That's why I asked myself if it was possible to replace the FeatureReader by a pythoncaller
I would definitely recommend getting the regular reader/writer mechanisms in FME to work, because everything else is going to be a workaround and somewhat more of a hassle to maintain.
That said, it is possible to use Python-specific database modules to read directly from the underlying SDE database (e.g. Oracle or PostGIS), but you need to know what you're doing and dealing with the geometries is a bit of a hassle. I would definitely not recommend going that route unless you have a very specific reason and you know the why's and how's.
ok thank you david. I thought that was easier but ok i will wait a answer from Safe.
I think that is the best long-term solution, for sure.