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:
Post a Comment