Question
Pycelonis to extract and pull data from analysis/datapool to external MySQL or similar
Hallo,
as pycelonis states:
Using this package you can programmatically interact with Analyses, Workspaces, Data Models, Data Pools and other Celonis objects. The package also allows pushing and pulling data to and from Data Pools and Data Models.
I would like to programmmatically interact with celonis analysis (mainly) and extract the data for other purposes and to other sources.
That means, the statement suggests to me the possibility to extract the data from Celonis into an external database like say MySQL.
I dont find a supporting material on this in the documentation.
Can someone shed a bit more light into the darkness here?
Hi ,
You can follow the documentation here: Pulling data from Analysis pycelonis 1.5.1 documentation
This library is pre-installed in ML workbench so you can also use it to write your program.
Best,
Noor
Hi Noor.
I am aware of that Docu page, thank you for the note.
The problem ist, when I get the pandas frame:
df = component.get_data_frame()
df.head()
how can I push it out of the Celonis server into MySQL instance on another Server in the Network?
That is the question.
+5Hi,
To achieve this, you can use the pandas library along with the sqlalchemy library for connecting to MySQL.
```
import pandas as pd
from sqlalchemy import create_engine
from sqlalchemy import URL
url_object = URL.create(
"postgresql+pg8000",
username="dbuser",
password="kx@jj5/g", # plain (unescaped) text
host="pghost10",
database="appdb",
)
engine = create_engine(url_object)
df = pd.DataFrame({'name' : ['User 1', 'User 2', 'User 3']})
df.to_sql(name='users', con=engine)
```
references:
[1] Pandas to_sql
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.