How to do reverse engineering o na customer DB to understand where the data is ?

Question

I'm looking to understand how a customer DB contains the information required for Process Mining (case, activity, related tables) from a completely unknown system. We have access to a DBA who can provide information such as GraphML files but we do not have direct access to the DB to do reverse engineering. Is there a tool on the market that will allow us to recreate a data model from data extracted from the customer DB. We've tried spark and other tools but we really need one that can map tables and relationships (including foreign keys).

Thank you

mateusz.dudek14 · Answer

Hi,

It depends on DB type/technology. Can you provide more info?

Usually the first step is to have access to GUI of the application using that DB, best test version - not production one. Then you should create create document with highly unique atribute (name, note, id - anything needed) like "XWDUWHWUHDQUHDUQDHUQHDUQHDUQH!*£&!*£&JHDJSHDSDHSJHSDJCNCXMNNJ3232" or anything else which there will be no chances will be stored anywhere in that database already.

For SQL server I had scripts/queries for searching such unique values which helped me find table containing that value. If you'll inject it in different places (different types of items, fields that are needed and so on), you'll slowly build map of a system comparing with thing seen by regular/operational user. The rest is just hacking mindset + googling. You can also try to investigate list of views that will consist of multiple tables in DB itself - that may provide you with useful knowledge.

Best Regards,

Mateusz Dudek

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN