Hey team,
For a migration topic, I would like to know whether it is possible to extract all the source tables used in a data model. I know that it is possible to extract the final tables of the data model via PyCelonis, but I am interested in the source tables. In a old ECC system.
Thanks for the help !
+8Hi Antoine,
maybe I am misunderstanding the question, but it surely seems to be achievable with PyCelonis as well.
E.g. you could get all tables of that datapool with get_tables() (https://celonis.github.io/pycelonis/2.4.0/reference/pycelonis/ems/data_integration/data_pool/#pycelonis.ems.data_integration.data_pool.DataPool.get_tables)
Then you could sort trough them to identify the ones you are interested in. Here is where I didn’t get what exactly you are interested in. So the following are just starting points for you:
I saw for example an attribute “data_source” on them, or you could compare them to the ones you found using a second query of a datamodel object with .get_tables().
Hi Manuel,
Thanks for you reply. The issue was the version of the Celonis we were using was not recent enough to go that deep with pycelonis apparently. But thanks for the documentation, will help in the future !
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.