Many user are eager to know how to connect PerformancePoint Services for Microsoft SharePoint Server 2010 to Oracle data sources with the use of Microsoft Business Connectivity Services? So I thought to start this thread, so that more members will add some content into it. The following is a summary of what you do in this scenario.
While performing some operational processes examined as purchasing, replenishment, distribution, or shipping, you might want to include Oracle data to support a business intelligence function examined as reporting, monitoring, or analyzing.
- Create a model file and external content type to describe how SharePoint Server connects to Oracle and retrieve inventory data.
- Publish the list data to SharePoint Server.
- Configure security.
- Create your site, dashboard, and KPIs by using PerformancePoint Services.
- Create a SharePoint list data connection for PerformancePoint Services.
Bookmarks