you can establish a JDBC connector.

https://docs.celonis.com/en/how-do-i-set-up-a-database-connection-.html

If the volume of data is small, you can also establish a connector with a Google Sheet

Hi Shaif... I feel your pain, at the moment Celonis has not a built-in solution to upload csv/excels in bulk and periodically.

We faced that problem and solved it usign python (we ran it in the ML Workbench, but you can use a external server)

You need:

• use sftp to connect to the folder. IIRC we used pysftp
• Iterate the files and upload them to Celonis
  • We used pandas to read the excels
  • Then the dataframe can be uploaded using create_table() https://celonis.github.io/pycelonis/2.0.3/reference/pycelonis/ems/data_integration/data_pool/?h=create_ta#pycelonis.ems.data_integration.data_pool.DataPool.create_table
  •  

HTH

I don't want to upload a lot of files just 1. Is the file upload feature deprecated? If so WHY?

Oh, my bad, I assumed you meant in bulk/repetitive.

To upload a single file just go to Data Integration, then the Data Pool you are using....

In the "diagram" , click in connection, add a new one, and select Upload a File



No Guillermo , i agree this was my requirement i confirmed it using servicedesk email id , they too said its not available. Can you tell me like if following solution is possible ? like you might put this file on Cloud folder and push to Celonis , can this works out , i mean at celonis end will there be table merged or each time cloud pushes the excel file data to celonis the old one gets replaced ?