OLAP Cubes in BIDS for Salesforce and PRISM
-
Hi everyone! I'm starting a project on BIDS. I want to create cubes based on replication databases for Salesforce and PRISM as data sources Does anyone had an experience with Salesforce reports developing? I will very appreciate for any suggestions you might have! Thanks in advance. Kind Regards Karina
-
Hi everyone! I'm starting a project on BIDS. I want to create cubes based on replication databases for Salesforce and PRISM as data sources Does anyone had an experience with Salesforce reports developing? I will very appreciate for any suggestions you might have! Thanks in advance. Kind Regards Karina
It's entirely doable, our EDW team does it. Loosely 1) Pull data from SalesForce.com into a staging environment (we use their dbamp application to do it) 2) Pull data from Prism into a staging environment (AS400 ODBC connection) 3) Pair the data together into Facts and Dimensions. Log data miss matches for user reporting Both systems should have customer numbers that match up, it entirely probably some where Salesforce.com is getting your Prism Customer numbers (or should be). 4) Once a solid data model has been built generating a cube off of that data is then easy. For more conceptual information -> http://en.wikipedia.org/wiki/Data_warehouse[^]
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.