.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Sharepoint 2010 Business Intelligence integration with datasources other than MS SQL Server

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :SharePoint
I want to Implement Business Intelligence by SharePoint 2010 on top of data sources other than MS SQL Server or MS Analytics Services ( cubes ), for example Oracle RDBMS and Oracle OLAP ( cube ) or Teradata. Quesiton : Is there any way to do this, if the is, how do I bring metadata to sharepoint BI or how do I make SharePoint BI to see other data source. I've looked at Busines Data Connectivity in Visual Studio, but that is more for two way integration and didn't seem like a good or easy way just to bring new data sources to SharePoint BI I found some tool from third party company "BDC Meta Man" which created metadata layer for Oracle RDBMS in SharePoint, but I thought there must be a way to do it by using Microsoft tools

View Complete Post

More Related Resource Links

Developer Training: Business Intelligence SharePoint 2010

SharePoint 2010 provides a flexible platform to expose business intelligence (BI) functionalities for end users by using platform capabilities, all through a familiar user interface. This training module shows how.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Video: What is Business Intelligence in SharePoint 2010?

Learn about the SharePoint 2010 Business Intelligence (BI) tools for bringing information together for analysis and collaboration to support business decisions. Available tools include status indicators; chart Web Parts, PerformancePoint Services, Excel Services, BI Search, and Visio Services. (Length: 11:51)

Video: SharePoint 2010 Business Intelligence (BI) Primer

If you are new to BI, this video will get you up to speed quickly. You will learn about some of the new BI features in SharePoint 2010, such as Excel Service and PerformancePoint Services. (Length: 11:51)

Video: Excel Services and SharePoint 2010 Business Intelligence

In this video you will learn how to create BI applications using Excel Services. (Length: 10:26)

Video: PerformancePoint Services and SharePoint 2010 Business Intelligence

PerformancePoint Services is all about surfacing data to users in a dashboard format to allow users to create business decisions based on the dashboard information. (Length: 11:51)

Creating Custom Business Connectivity Services Connectors Using SharePoint Server 2010

Learn how to create a Business Connectivity Services (BCS) custom connector to integrate data sources into SharePoint Server 2010.

SharePoint 2010 AD FS 2.0 Integration - login works then fails, looping back to the adfs server

Hello, I setup SharePoint 2010 Claims auth with AD FS 2.0 following this post: http://blogs.technet.com/b/speschka/archive/2010/07/30/configuring-sharepoint-2010-and-adfs-v2-end-to-end.aspx.  I have no access to the ADFS server, but I think they followed the steps as outlined.  If I do an iisreset (or just recycle the app pool of the SharePoint site) I can login successfully using the remote credentials.  Also I can under security in SharePoint search for and find users and roles from the remote ADFS server. If I close my browser, open a new browser and go to the site I am prompted to login again (this is fine).  I do, using the same credentials, and the login fails because I am redirected between the SP and ADFS servers until the ADFS server stops the redirecting.  I have been doing some digging and I found this post: http://blogs.technet.com/b/speschka/archive/2010/08/09/setting-the-login-token-expiration-correctly-for-sharepoint-2010-saml-claims-users.aspx, which describes the situation I have in point # 3 at the bottom.  I have tried setting the token time out as low as 1 second but this hasn't helped. I have also, just to see, tried setting all the other lifetime settings to 1 second - but no luck.  Because the initial login works I think the setup is correct, but something is maintaining some state that is causing the loop

Sharepoint Server 2010: Reporting Services Integration - 401: Unauthorized


Hi everybody,

I know - there are lot's of articels, posts, etc.. about configuring Reporting Services in Sharepoint 2010 and I feel like I read them all hundred times at least... but none of them helped me solving my problem.


I have the following Scenario at a customer:

Servername / Functionality

db01 / MsSQL 2008 R2 server (also contains the ReportServer DB - of course it's type is Sharepoint Integrated)

app01 / Sharepoint 2010 Server (Complete Installation) - used as Indexing Server and running some other Service, Central Administration, Reporting Server

*fe01 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

*fe02 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

*member of Windows NLB


I configured Reporting Services Integration in Central Admin and everything worked perfectly correct - no errors - strike!.

But now comes the "funny" part:


If I open a Report on a Sitecollection like http://app01:1234/ the report is getting rendered and presented - yeah!

But if I open a Report on a Sitecollection like http://NLB-URL/ the report throws an error (damn!):

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

SharePoint 2010 and BCS: Using Business Connectivity Services in SharePoint 2010


Kirk Evans shows how to take advantage of SharePoint 2010 Business Connectivity Services (BCS) to develop solutions with deep integration of external data and services. BCS builds upon its BDC predecessor in the key areas of presentation, connectivity, tooling and lifecycle management.

Kirk Evans

MSDN Magazine December 2009

SharePoint Enterprise Search Migration Tool for SharePoint Server 2010

Use this tool when you upgrade to SharePoint Enterprise Search to migrate search-related data, such as best bets, search scopes, and site collection search settings.

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Sample: SharePoint Server 2010: Aggregating Data Using BCS and .NET Assemblies

Use the BCS Data Aggregation sample with BCS in SharePoint Server 2010 and to aggregate data from two external systems.

FAST Search for SharePoint Server 2010 SDK

Learn how to develop and deploy search solutions in SharePoint Server 2010.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend