I would like to write KPIs back to a SQL server. Currently we only have 13 months of data in Celonis and it would be helpful to compare current KPIs with older ones.
Is it possible to write back to a SQL server and if so what methods have you used to do this?
Action Flows I guess... if there is not a jdbc connector for AF, you can always setup some API in the SQL server and call it using the http call of AF.
If not, then python and pycelonis and implement manually reading the Celonis kpi and writing them in SQL using jdbc
HTH
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
