search sql 2005 db from moss 2007 farm

Dear Friends,

Idea is to search a sql 2005 database from intranet based moss 2007 farm,
this sql 2005 database is sitting inside the network and is hosted on win 2003 server.
(this is one of the databases that is hosted on some server).

kindly advise.
 
LVL 10
Minesh ShahSharePoint & all about itAsked:
Who is Participating?
 
Jerryuk007Connect With a Mentor Commented:
The two tools to create BDC (Business Data Catalog) which I would recommend are:
MOSS BDC Design Studio (from http://www.simego.com/Products/MOSS-BDC-Design-Studio)
and BdcMetaMan (from http://www.lightningtools.com/bdc-meta-man/default.aspx)

Both of them have simple user-friendly interface to get you started.

J.
0
 
Kobe_LenjouCommented:
And what exacly is your problem?
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
there is no problem, i want to drag it!
idea is to search a database, from sharpoint search, which resides in network but out of the farm.

ANY assistane would be highly appriciated.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Minesh ShahSharePoint & all about itAuthor Commented:
to search content of various data inside the sql database
0
 
Kobe_LenjouConnect With a Mentor Commented:
So is your problem connecting to the database, or searching in a non-sharepoint db?
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
exactly.
0
 
Jerryuk007Commented:
One way to do it might be to create BDC (Business Data Catalogs), then create Search Scopes based on the BDC(s) you created.

If you are looking for lookups within an InfoPath Form then you can open a direct connection (OLEDB/ODBC) from within the Form to any MSSQL Server to resolve a specific field.

J.
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
thank you so much friends,
i was just wondering if there are any good links to strat up to search non-sharepoint sql 2005 database from moss 2007 search.
0
 
Jerryuk007Commented:
Do you know already which fields you are going to search or do you want some kind of free-hand SQL Tool or ManagementStudio Interface within SharePoint?

J.
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
yes i know the fields.
0
 
Jerryuk007Commented:
Then all you need to do is to create a BDC, then create a Search Scope on that BDC (basically indexing it) which would allow searching it like any other indexed data.

J.
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
could you please locate me to start with create a BDC....
0
 
Minesh ShahSharePoint & all about itAuthor Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.