Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Can a BDC app span multiple databases?

  Asked By: Heena    Date: Apr 23    Category: Sharepoint    Views: 1612

I'm wondering if there is a way to create a BDC appliction / LOBSystem that sources data from multiple databases?

I want to source Customer data from MS CRM, and customer Order data from an Oracle database. Ideally I'd like to have Customer and Order entities in the one BDC so that I can show the combined info in Sharepoint.

I've seen a solution that uses Linked Servers, but I doubt I will be allowed to configure linked servers in my deployment environment.



1 Answer Found

Answer #1    Answered By: Chris Daniel     Answered On: Apr 23

I found the answer in the BDC FAQ (duh!)...


Simply put... No, an application definition can only connect to one database. Also, both SourceEntity and DestinationEntity of an association must be in the same LobSystem.

Didn't find what you were looking for? Find more on Can a BDC app span multiple databases? Or get search suggestion and latest updates.