We want to integrate OBIEE with SFDC, I want to understand how this can be done.
I have following options in mind, let me know your thoughts on this:
1. Create a channel to pump SFDC data in local database and then use ETL tool to massage this data and then use this in OBIEE
2. Use ETL tool to extract/transform and load data to local datawarehouse and source this massaged data into OBIEE
3. Connect directly to SFDC from OBIEE.
Of course I prefer 1st method, as in 2nd method I'll have to worry about commit/rollback as I am not sure about ETL tools capabilities to hold transactions over n/w for large data (will it be large). As for 3rd method, if OBIEE were to fire query across n/w it would have considerable performance hit.
Very important thing here would be to understand SFDC schema itself. If somebody could point me to easy tutorial to understand SFDC schema it would be great.
Thanks in advance, looking fwd for answers
Ganesh (newbie to SFDC)