Thread Details
  • State Not Answered
  • Replies 2 replies
  • Subscribers 354 subscribers
  • Views 33798 views
  • Users 0 members are here
Forum Actions
Related

Database

Benjie Monterde

Hello everyone. 

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. 

Thank you. 

Parents
  • 0

    - 

    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.

Reply
  • 0

    - 

    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.

Children