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?

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

Hi Ali,

thank you for your question.

Please note that Snap (now Celonis free plan) is the free version of Celonis and there are limited number of connectors available.

Thanks and best regards,