locked
SharePoint BCS with Oracle Success Stories RRS feed

  • Question

  • Can anyone share their success stories with connecting an Oracle list using BCS? I would also like to know who had failures and for what reasons. Our company is making an effort to have this work for a business project. The plan is to have an Oracle list of about 100,000 rows and be able to search, view search results, view items and update 2 columns on that list. Therefore,  we would like to know what our chances of success are and what steps to do this.
    Dave
    • Changed type Clayton Cobb Saturday, June 11, 2011 5:55 PM Always use the Question Type so people can be rewarded for answering you
    Friday, June 10, 2011 4:32 PM

Answers

All replies

  • I personally don't have a success story to share connecting to Oracle sources, but we've connected to the typical SQL back-end, WCF services, ASMX services, flat files, etc.  With that said, I would venture to say that your chances for success would be very good leveraging Business Data Connectivity services.  Using Visual Studio to create BDC Models gives you the most flexibility on connecting to almost anything.  Below is an MSDN article on how to connect to an Oracle database through BCS:

    http://msdn.microsoft.com/en-us/library/ff464424(office.14).aspx

     


    Michael Moreno Blog: http://www.shaitown.com/blog
    Friday, June 10, 2011 4:38 PM
  • Michael, Thanks for your reply. I have that article already and am working with our development team to make this happen.


    Dave
    Friday, June 10, 2011 4:41 PM
  • I havent had the opportunity to do a Oracle LOB as of yet, but i have done other External Systems; the process however is the same as you are leveraging the modelling in either SPD or Visual Studio, the greater flexibility is in VS 2010 obviously as you can leverage API's from the External System if avaialble, thus keeping as much integrity to the origin as possible. I have a few examples on my blog. Hope that shed some light mate.

    Connect with Me!

    Fabian G. Williams | Twitter @FabianWilliams | Blog http://www.sharepointfabian.com | Email: fabian@adotob.com

    Adotob Logo

    Saturday, June 11, 2011 4:45 PM
  • Hi TekDave,

    We have lots of Oracle customers who use a BCS product from the company I work for, you can check out this post with an answer from my colleague (Dmitry) about all the ways of how you can go about connecting to Oracle:

    http://social.msdn.microsoft.com/Forums/en-US/sharepointbdc/thread/55cc4d28-8588-4294-8ecc-dbc6bd815836/

    Hope this helps

    Phill


    helpful? …please mark it so!

    Lightning Tools Check out our SharePoint Tools and Web Parts
    BCS Meta Man Automatic BCS Model Generation
    BCS Tester Man Open Source BCS test client
    Twitter LinkedIn
    Monday, June 13, 2011 8:52 AM
  • Hi Phil,

    Yes I have seen Dmitry's post several times. Thanks.

    Dave


    Dave
    Monday, June 13, 2011 11:47 AM
  • hi Dave,

    If you have seen the arcitle posted by Michael, What's the result?

    Thursday, June 16, 2011 12:13 PM
  • Yes, I have seen the article. We have our developers working this approach. They have the connection to the Oracle table made and can successfully return rows to SharePoint. We are having difficulties crawling the data however. That is the place where we are stuck right now.
    Dave
    Thursday, June 16, 2011 12:44 PM