It appears I cannot create a data job that extracts from a DB View. Is that correct? Is there a way to make that happen? It is easier to create the data within the SQL Tables vs bringing it into Celonis and then doing all the conversion. Mostly because I need to convert Key fields to get them to allow relationships. Is there a way around this or do we really have to ETL the data in Celonis? Worse case we create the views and dump the tables into XLS and import. I was hoping for something easier. Thank you.
Hi Mike,
It is possible to make exports of Views, at least from my experience in SQL / Azure SQL / Oracle databases. It could be that the schema of the View is different or your account does not have permissions.
Let me know whether that helps! Otherwise there are other possibilities to get data into Celonis.
+4Thank you. Our database is DB2, so maybe that is the issue. The ID we are using to connect created the views :) Maybe DB2 is just different enough to not allow this??
Hi Mike,
I don't think that would be the problem. Please make sure that you search for your Views in the correct capitalisation (e.g. 'ViewForMe' --> '%ViewFor%' or 'ViewForMe"'): the Search Table function in the Data Extractor is capital-sensitive. I have often had troubles finding tables as well ;)
+4Thanks for that suggestion. That did not work. When I search, it does not even bring up the known table when I put the % around it. I even enter the first letter and it brings up tables, including system tables, but not the view. UNless internal the view is named differently. I honestly am not sure at this point. I have a ticket open with Celonis as this is an issue for us beyond a simple test. Thanks
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.