Title: Business Data Catalogue presentation to CSPUG
1A PAYGLOBAL PRESENTATION
Donald Harman
2Overview Intro
Business Data Catalogue investigation
Investigate the BDC Business Data Catalogue
Case to use for proof of concept. Search through
another business system i.e. Pivotal using the
BDC and Enterprise Search of MOSS 2007 Face
business data in another manner than the Pivotal
UI Issues and development steps. Why did I
choose this method rather than a report?
3Issues in Pivotal
Issues within Pivotal You need to know the
number or description name, then once you have
issue you can then click on individual
development steps to walk through the steps of
where this Issue is at
4Why go there?
- So whats my point?
- Make issues easier to search.
- Learn more about the data and use it better.
- Can we capture this data better and improve our
information.
5The pain
- Microsoft Business Data Catalogue
- BDC Meta Man
- And the winner was.
6BDC Metaman
Source PMP Research
7A little of SQL knowledge helps
SharePoint did not like Binary IDs The BDC
Metaman definition file is an XML file within
this file I was able to manipulate the SQL query
part of the file. Whenever I had a BinaryID I
cast it as an Integer CAST (Issue_Id as Int)
AS Issue_Id I was well pleased with this as I
was able to successfully import the definition.
But there was more I also had to change the
type descriptors as wellltTypeDescriptor
TypeName"System.Int32" Name"Issue_Id"
IdentifierName"Issue_Id" /gt MOSS now liked
the file. I ended up using filters which you can
set up with the tool.
8Filtering
9Lock and load.
10The Entities
The Tables are now entities with a relationship
to the development steps
11Add the content to be crawled
Add Content Source
12One I have previously prepared
SharedServices gt Search Settings gt Content Sources
13Add them web parts
14The parts
- Search am html part which sends me to the
Issues page - ltDIV onkeydown"JavaScriptif(event.keyCode13)
SubmitGoogleSearch()" noWrapgtltA
href"http//pgl-80/SearchCenter/Pages/Issues.aspx
" target_blankgtlt/AgtltINPUT idq maxLength254
size24gtltIMG onmouseup"this.src'/_layouts/images
/icongo02.gif'" onmousedown"this.src'/_layouts/i
mages/icongo03.gif'" onmouseover"this.src'/_layo
uts/images/icongo02.gif'" style"CURSOR hand"
accessKeys onclickJavaScriptSubmitGoogleSearch(
) onmouseout"this.src'/_layouts/images/icongo01
.gif'" alt"Execute search" src"http//pgl-80458
6/_layouts/images/icongo01.gif" alignabsMiddle
border0gtltINPUT idnewPage typecheckboxgtNewlt/DIVgt
15The Issue Part
The Issue list
16The Issue Part
now viewed by severity visual conditional
formatting
17SharePoint Designer
- Set up filtering and conditional formatting
18Issues Search results
Search page
19Click through to the Issue plus more
20See the development steps as well
21Might get the BDC tool in the next budget!
- Conclusion
- Some folk were way impressed.
- Some folk still want to view stuff in a
spreadsheet. - Still got many battles to win.
- Next step is presenting a business case for other
benefits. - Perhaps a dashboard of Search results from
different systems. - Documentation Development Finance Lists
that can grab data from different areas and use
shared lists rather than siloed spreadsheets - Some wins so far with MOSS
22Past success
23Success in progress
24Early adopter
25Thats all folks