Recently digging into the strategy and best practice of installing the OBIEE Applications, mainly the DAC and Informatica components, I see two common issues arise more often that any others. One has to do with the Informatica Integration Service not matching the correct locale such at UTF-8 or MS Windows Latin, etc. preventing it from starting and the other has to do with the Informatica or DAC user not able to call the core integration tools pmrep and pmcmd. This issue is common on Linux/Unix environments but not so much on a Windows server environment.
Here is a really easy way to verify information about an Informatica PowerCenter’s current status. You need not be an administrator or even logged into any part of the Informatica PowerCenter environment. Using the default or custom port of Informatica PowerCenter, enter the following URL:
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.
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.
My name is Christian Screen, a Business Intelligence mastermind working with mainly Oracle and Microsoft technologies. The views expressed here are my own and do not reflect the views of Oracle, Microsoft, or my employer.
