I would like to ask if there is anyone here who have experience doing this task.
The task is.
To capture data from different modules and dump them into a custom module to create a denormalized table.
Are you going to use a tool such as tray.io or are you programming by hand?
If you use tray.io. or another PaaS solution, you can map the fields. You can run via scheduler or via Sugar Web Logic Hooks, etc.
If your program is done by hand, you can either write a Scheduler Task or you can queue via a SugarJob or a combination of both. What you don't want to do is add a logic_hook which will transform the data in real-time. This will slow down the use of Sugar by the user.