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.
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.
Check out these BI Publisher tips including functions & calculations so you can understand more about the production and support of BI Publisher reports.
Ultimately the goal of commentary in OBIEE is to have a system for persisting feedback, creating a call to action, and recognizing the prolific users.