This is the second part of a two part post. The first part can be seen here
Now that we have SSO setup and working, we now need to create and import the application definition.
I’m not going to go into to much detail on how to create a application definition, but there are various tools available that you can use (BDC Meta Manager, Microsoft Business Data Catalog Definition Editor which is part of the SharePoint Server 2007 SDK)
Here are the key parts of the application definition you need to be aware of.
I have added the XML to a Word document which can be downloaded here (Sorry WordPress doesn’t let me upload XML files)
Below are the properties used by SharePoint to connect to the database. You need to use the SSO ID specified in Part One when you setup SSO
If your primary source…
View original post 213 more words