Sticking with a solid need for integrating sales, performance, and compensation data from distributed data sources I chose one that one that has been relatively absent from this attempt, Oracle Data Integrator.  The detail in this tutorial was too extensive to be placed in a basic blog post and is readily available as a PDF for download.  Please take note that unfortunately this a relatively straighforward integration with some deviations and patches.  Oracle presented this integration as ready but as you can see from this tutorial that that declaration was not 100% accurate.  However, with some step-by-step patching and careful procedural fine tuning the integration is indeed possible and value rich.
Read the full story

I’ve been integrating SalesForce.com with OBIEE and some other data warehousing projects for clients for some time now and had a moment to throw this tutorial together.  Also, I mentioned earlier in the year that I would definitely be providing a few blog posts on this topic of SalesForce.com integration.  And, What better way to start off than by explaining with another tutorial video? Since the Informatica Video series is the most viewed post on http://www.artofbi.com right now, I figured I’d keep that trend going.

Below is the video tutorial which will be a precursor to the full OBIEE / SalesForce.com integration.  Today I am showing the quick and dirty ability to connect to SalesForce.com via Informatica 8.6 PowerCenter in order to push up some new account data. I’ll get into the weeds sometime down the road.

Integrating OBIEE and SalesForce.com from ArtOf BI on Vimeo.

Conclusion

Informatica is a great tool for ETL and clearly the only way to fly with the OBIEE pre-builts. This video tutorial shows one how to get rolling with their own base integration using one of the many SalesForce.com objects, Account. If you have any questions, or comments, post them as usual and I’ll try to get back to you as soon as I can.