MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Getting Oracle to work through SSO/BDC

  Asked By: Nicholas    Date: Sep 06    Category: MOSS    Views: 1212

We have information in an Oracle database that we have to expose
through a MOSS 2007 site. Has anyone gotten SSO/BDC to work properly
with Oracle? If so can anyone share steps/procedures?

Seems to be a topic thats hard to find information on. I have been
researching for weeks but can't find any defintive answer.



5 Answers Found

Answer #1    Answered By: Tricia Mullins     Answered On: Sep 06

Video on using BDC Meta Man to connect to Oracle.


Answer #2    Answered By: Himanshu Gohil     Answered On: Sep 06

I have a post that goes along with Nicks one using BDC MetaMan to connect to
Oracle. You can get it here:

www.helloitsliam.co.uk/Downloads/Articles/MOSS2007" target="_blank" rel="nofollow">www.helloitsliam.co.uk/Downloads/Articles/MOSS2007%20

<www.helloitsliam.co.uk/Downloads/Articles/MOSS2007" target="_blank" rel="nofollow">www.helloitsliam.co.uk/Downloads/Articles/MOSS2007%20-



it may be useful.

Answer #3    Answered By: Ashton Schroeder     Answered On: Sep 06

I viewed the webcast and pdf document. I tried
what was in there but am getting errors. Saying that the parameter
was invalid...Seems to be security related when I check the
SharePoint logs. We can hit the Oracle database  and retreive
information from it using a test asp.net application so I know that
we have access to the database.

Now I have a question. The webcast and PDF sample have Oracle and
SharePoint on the same server. Is there anything different that has
to be done when they are on seperate servers? I read somewhere that
SSO has to be used in that case?

Answer #4    Answered By: Iris Ballard     Answered On: Sep 06

We are currently getting ready to undergo the same thing. I am also
interested in people's experiences with this.

Answer #5    Answered By: Jamila Guthrie     Answered On: Sep 06

Since we're dealing data stored on a Oracle database, I would assume this
would be non-SharePoint line-of-business data we need access to.

As a "Best Practice", I would recommend exposing the Oracle data via web
services. This will allow you to manage access to the line-of-business
data. It also removes the database  design complexities from everyone.
Once completed, I would then hook up the BDC to the web services instead
of directly to Oracle.

Didn't find what you were looking for? Find more on Getting Oracle to work through SSO/BDC Or get search suggestion and latest updates.