Hi guys,i have been using the snap version. i want to connect the mysql database to celonis. but in connection section there is not any microsoft database like sql and mysql. is it possible to connect celonis to mysql? if yes how can i do that?

Question

Hi guys,
i have been using the snap version. i want to connect the mysql database to celonis. but in connection section there is not any microsoft database like sql and mysql. is it possible to connect celonis to mysql? if yes how can i do that?

deleted.delet27 · Answer

Hi,

I'm not sure if snap version has machine learning workbench. If it does, use python to connect to the data base you need (A), convert data to pandas data frame (B) and push into data pool (C). You can schedule script runs (ML workbench app scheduling).

A) https://pynative.com/python-mysql-select-query-to-fetch-data/

B) https://medium.com/analytics-vidhya/importing-data-from-a-mysql-database-into-pandas-data-frame-a06e392d27d7

C) https://celonis.github.io/pycelonis/1.7.1/tutorials/api_tutorial/02_Pushing_and_Editing_Data_in_Pool/#3-create-a-pandas-dataframe

You can also write a ticket - maybe you'll receive access to extractor.

Best Regards,

Mateusz Dudek