Since we released our first Beta, we have been working on various examples to demonstrate the capabilities and benefits of a resource oriented approach to data integration.
One of the examples we have been working on is a data mart for SugarCRM opportunity analysis. We have now published that example on our content download site, packages.snaplogic.org , where you can download it, and try it out. (You will also need a SnapLogic server installation, to run the pipelines.)
The general idea behind data marts is simple – they are subject specific alternatives to a full blown data warehouse. The primary benefits of using a separate database to analyze an operational system are the ability to look at a snapshot of the constantly changing data, and the offloading of the queries to a separate database which is optimized for analysis using a star [Read more...]