Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Displaying Data from Oracle

  Asked By: Reed    Date: Jul 06    Category: Sharepoint    Views: 1790

One of the devs came to me wanting to know if I could create a webpart or
something else in SharePoint where he could run a customized report from a
table on an Oracle server. There is no web interface currently... heck he
hasn't even set the parameters for the report yet. But is there a way for
SharePoint OOB to do this? This is the first request I have had like this
and thought I would throw it at the listserv prior to my researching the
request myself.

I do know the Oracle server does have its own IP address, but I do not know
at this point where this table is located on the server or how many
columns/rows/etc are in the table in question.



3 Answers Found

Answer #1    Answered By: Bernice Puckett     Answered On: Jul 06

Yes SharePoint can display data  from an Oracle server  using OOB functionality.
Probably the easiest way to do this would be to create  an OLEDB database data
source in SharePoint Designer to retrieve the data and display it in a DataForm
web part. The one issue may be whether an OLEDB compliant driver is loaded onto
the Oracle server or not. These drivers are available free from Oracle, but I
believe they are an optional install.

You could also build a custom web  part using ADO.NET to retrieve and display the
data. Although this requires custom programming it would allow you to use
ADO.net's native Oracle drivers to contact the Oracle server. These would
provide a higher level of performance over the OLEDB drivers.

Answer #2    Answered By: Mackenzie Lewis     Answered On: Jul 06

Sharepoint as in MOSS 2007 with BDC...yes..very possible, may need some extra
post processing

Sharepoint as in WSS v3 with low level coding .... Yes but not exactly OOB...

Sharepoint as in WSS v3 with XML web  part of the data  is exposed by the Oracle
server as an XML data stream ..... possible with some extra effort

Otherwise... not inherently OOB

Answer #3    Answered By: Kurt Gilbert     Answered On: Jul 06

Already rolling with the devs on this.

Didn't find what you were looking for? Find more on Displaying Data from Oracle Or get search suggestion and latest updates.