Can SharePoint access a DB and pull info from it?

I'm looking at using Sharepoint to be the corporations document management
system. I was wondering if all the data from our products (i.e. size,
voltage, amps, etc...) that is stored into a SQL or MSQL database can be
generated into a document/webpage when requested?

Thanks in advance.
M.H.

Frode
Sat Jun 17 02:00:03 CDT 2006

Check out the Business Data Catalog features. It is very powerfull. I think
you will be suprised how easy it is.

Frode

"Mark" <markhughes@broan.com> wrote in message
news:574D6D1D-5CBD-4349-9253-A92C57FE38FC@microsoft.com...
> I'm looking at using Sharepoint to be the corporations document management
> system. I was wondering if all the data from our products (i.e. size,
> voltage, amps, etc...) that is stored into a SQL or MSQL database can be
> generated into a document/webpage when requested?
>
> Thanks in advance.
> M.H.

S
Sat Jun 17 06:55:32 CDT 2006

You can create an .aspx page to show data pulled from an external database
and link it with SharePoint. You can also create a web part to achieve this.
Third solution is to use a dataview web part to pull data from an external
DB and show it in SharePoint.

SSA
http://sharepointblogs.com/ssa

--
"Frode Sørhøy" <frode.sorhoy@avenir.no> wrote in message
news:Ooeq7AZkGHA.5036@TK2MSFTNGP04.phx.gbl...
> Check out the Business Data Catalog features. It is very powerfull. I
think
> you will be suprised how easy it is.
>
> Frode
>
> "Mark" <markhughes@broan.com> wrote in message
> news:574D6D1D-5CBD-4349-9253-A92C57FE38FC@microsoft.com...
> > I'm looking at using Sharepoint to be the corporations document
management
> > system. I was wondering if all the data from our products (i.e. size,
> > voltage, amps, etc...) that is stored into a SQL or MSQL database can be
> > generated into a document/webpage when requested?
> >
> > Thanks in advance.
> > M.H.
>
>

Engelbert
Sat Jun 17 08:53:28 CDT 2006

Business Data Catalog comes only with MOSS 2007 doesn't it ?

I'm assuming he has SPS 2003 as this is the .portalserver newsgroup and he
didn't say otherwise.

-------------

S.S. Ahmed's answer is just what I would have written.

I would tend to try his version 3 first (Mark: DataView web parts are
created by using FP 2003's Data menu item and "Add a View" etc. - I've found
it best to use a connection string to connect to the database and it will
work much more easily if your database is SQL Server.)

Engelbert

"Frode Sørhøy" <frode.sorhoy@avenir.no> wrote in message
news:Ooeq7AZkGHA.5036@TK2MSFTNGP04.phx.gbl...
> Check out the Business Data Catalog features. It is very powerfull. I
> think you will be suprised how easy it is.
>
> Frode
>
> "Mark" <markhughes@broan.com> wrote in message
> news:574D6D1D-5CBD-4349-9253-A92C57FE38FC@microsoft.com...
>> I'm looking at using Sharepoint to be the corporations document
>> management
>> system. I was wondering if all the data from our products (i.e. size,
>> voltage, amps, etc...) that is stored into a SQL or MSQL database can be
>> generated into a document/webpage when requested?
>>
>> Thanks in advance.
>> M.H.
>
>

markhughes
Mon Jun 19 13:11:01 CDT 2006

We do have Sharepoint Server. Thanks guys!

"Engelbert" wrote:

> Business Data Catalog comes only with MOSS 2007 doesn't it ?
>
> I'm assuming he has SPS 2003 as this is the .portalserver newsgroup and he
> didn't say otherwise.
>
> -------------
>
> S.S. Ahmed's answer is just what I would have written.
>
> I would tend to try his version 3 first (Mark: DataView web parts are
> created by using FP 2003's Data menu item and "Add a View" etc. - I've found
> it best to use a connection string to connect to the database and it will
> work much more easily if your database is SQL Server.)
>
> Engelbert
>
> "Frode Sørhøy" <frode.sorhoy@avenir.no> wrote in message
> news:Ooeq7AZkGHA.5036@TK2MSFTNGP04.phx.gbl...
> > Check out the Business Data Catalog features. It is very powerfull. I
> > think you will be suprised how easy it is.
> >
> > Frode
> >
> > "Mark" <markhughes@broan.com> wrote in message
> > news:574D6D1D-5CBD-4349-9253-A92C57FE38FC@microsoft.com...
> >> I'm looking at using Sharepoint to be the corporations document
> >> management
> >> system. I was wondering if all the data from our products (i.e. size,
> >> voltage, amps, etc...) that is stored into a SQL or MSQL database can be
> >> generated into a document/webpage when requested?
> >>
> >> Thanks in advance.
> >> M.H.
> >
> >
>
>
>