locked
SharePoint 2007 connection to Oracle RRS feed

  • Question

  • Hi Dmitry,

    I would like to connect directly to Oracle from SharePoint 2007. (I am able to connect via ODBC through excel worksheets but that entails a 2 step process.) I had thought that SharePoint Designer might enable me to do this. From reading the thread many of the comments suggested that this might not be possible.

    I have come across a few related topics and will continue research. However I am new to SharePoint 2007 and am really look for a 'How to' step by step guide to achieve SharePoint connection to Oracle.

    I might be in the wrong forum.

     

    Thanks

     

     


    Taiwo 

    Wednesday, June 8, 2011 8:43 PM

Answers

All replies

  • Hi Taiwo,

    You may follow one of the following approaches:

    1. Manually create a Application Definition File for Connecting to Oracle Databases from the beginning http://msdn.microsoft.com/en-us/library/aa673236%28v=office.12%29.aspx
    2. Create a Web service to provide an interface to the external data exposed in the database. Create an Application Definition File for this web service.
    3. Use SharePoint Designer 2007. Please look at this thread http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/f2b97973-59db-4484-9c0b-42d3b54161d7

    You can also try out the product provided by the company where I work for, and name of that product is BDC Meta Man. It will allow you to generate application definition file automatically as soon as you drag and drop database tables to the design surface,

    It supports Oracle and ODBC.

    Please look at these blog posts:

    http://www.lightningtools.com/bdc-meta-man/business-data-catalog-oracle.aspx

    http://www.lightningtools.com/blog/archive/2010/03/04/how-to-connect-sharepoint-bdc-to-oracle-through-tns.aspx

    Hope this makes sense.


    Dmitry

    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts
    • Marked as answer by Peng Lei Friday, June 17, 2011 1:55 AM
    Wednesday, June 8, 2011 9:22 PM
  • People wondering why I am allowing the suggestion of an own product in the previous post, please consider the following points.

    a) Dmitry writes a lot of useful posts that do not suggest a product from his company

    b) This post first suggests several ways to solve the problem without needing a third-party product.

    c) The final section was very clear that the product being suggested was from the poster's own company. (or rather the one he works for)

     

    Moderator pre-SP 2010 forums.

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Thursday, June 9, 2011 8:33 AM
  • Mike,

    as I said before (in a moderated / removed thread): There are lots of other possibilities to connect Oracle tables directly to SharePoint lists. Several 3rd party vendors offer such solutions (not only the company mentioned above). Some of this solutions are very easy to manage from the users point of view - without any configuration and programming. That could be helpful for customers, that are looking forward to solve issues, that still exists with OOB data integration in SharePoint.

    But it's in the moderators responsibility to allow to link to some vendors and to others not.

     

     

    Thursday, June 9, 2011 9:15 AM
  • The entire history of SharePointFrank posts to the pre-SP 2010 forums is that none of my above a), b) and c) criteria have ever applied.

    If you want to not have all your posts deleted as spam you should start by creating a track record in answering posts without suggesting any of your own products.

    Only once I have seen that (by many such helpful posts over a long period of time) will I even consider letting posts from you in which you propose your own products stay in the forums.

    Mike Walsh (Moderator pre-SP 2010 forums)


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Thursday, June 9, 2011 9:52 AM