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.

As a nice side note, I am referrencing a video that I recently found on YouTube for installing Informatica 8.6x on a Linux server.  Later I will post more detailed screenshots from my own installation but for now I figured this is great insight to be shared.

The below video(s) are from a tutorial on Informatica PowerCenter 8 that we did a few months back.  This is now in its new formatted blog page.

Read the full story