Wednesday, August 19, 2009

BDC Metadata for SQL Server 2000 Adventure Works db

BDC Metadata for SQL Server 2000 Adventure Works db Here is the metadata for SQL Server 2000 Adv Works DB.I searched a lot for Adv Works 2005 metadata but the msdn samples for 2005 have very elementary stuff in there without filters etc.I needed something a bit more complex and with the tables named product ,customer etc and not dimproduct or dimcustomer.Most sample metadata has the latter tables and I can't find a similar adv works 2000 db. Finally I found this metadata in a msdn link which does work with the current Adv Works Cycles 2000 db.You can download the sample db from the following link: http://www.microsoft.com/downloads/details.aspx?FamilyID=487C9C23-2356-436E-94A8-2BFB66F0ABDC&displaylang=en
The metdata is as in the link below:Note the mode of authentication that worked for me is RevertToSelf.
The only thing you need to add below is your server name as indicated in the tag.
http://msdn.microsoft.com/en-us/library/ms497572.aspx

Hope it works for everyone...working with the BDC is a true test of patience :)

No comments: