Until last post I explained extraction topics using own Postgres database. I think it is better to test extraction functions with changing database by yourself. But it is hard to manually input data record that is meaningful as event log.
From now on I will move to transformation topic. To explain this, I think it is required to prepare source system that has user interface, database and API to connect to Celonis EMS, to easily generate event log and extract it.
I would like to introduce Planio as source system. This is cloud hosting system using Redmine, that is open source project management web application. I already used Planio for some months and I feel it is sinple and powerful solution to manage my team.
At the top page of Planio you can create your environment by clicking Start your free trial button, that has no charge if you change to Bronze (free) plan after initiation of environment. If you successfully create your enviornment, you can see below screen as me (I can see Japanese text but you may see different language).
To generate your event log with free license restriction (only one project), first I should delete existing project website-redesign. I click tile at the home page to move to project top page, then click trash button.
After that I can create new project. From top left + button, I can create new project. I named Prototype production of XYZ project.
Next I would like to create issue. From + button, I can create new issue too. This time simply enter Subject Prepare Kick off then create issue. Then new issue number (in my case 8) is registered.
Finally to create change log, click Edit button and change status then submit change. Change history is displayed as note #1.
Next time I would like to setup Extractor Builder in Celonis EMS to extract event log from Planio.
Kaz