locked
What are the trade-offs of integrating SharePoint 2007 with Oracle HR vs. Active Directory? RRS feed

  • Question

  • We had implemented SharePoint 2007 for our intranet and used AD as the system of record to authenticate our global users. We currently have content, e.g. Departments itemized within a SharePoint list, employees by department w/in a PDF, global/regional employee phone list in Excel, and org chart in PDF from Org Plus output for our US users. We have a business request to change the system of record from AD to Oracle HR for US users so that HR does not have to redundantly update Oracle HR then the SharePoint content items. Can you tell me what are the integration trade-offs, challenges, or benefits that an Oracle HR to SharePoint 2007 would entail?    
    Thursday, November 11, 2010 11:54 PM

Answers

  • MOSS standard is not enough - you need MOSS enterprise for BDC.

    BDC is a little advanced, but this is a good use for it. You can get a 3rd party tool from Lightening Tools that makes it easier to use.

    The way this is normally configured, you would have shareopint user profile imports pull data from AD as is, out of the box.

    User profile import would then supplement the AD pull with data from Oracle HR.  It could override nearly all the AD data if you want.


    --Paul Galvin, Computer Generated Solutions (CGS)
      Microsoft MVP - SharePoint
      Blogging @ http://www.mstechblogs.com/paul
      Twitter @ http://www.twitter.com/pagalvin
    Saturday, November 13, 2010 4:24 PM

All replies

  • If you're running MOSS enterprise, you could use BDC to update sharepoint with data from both AD and Oracle.  That way, you get the best of both worlds.

     


    --Paul Galvin, Computer Generated Solutions (CGS)
      Microsoft MVP - SharePoint
      Blogging @ http://www.mstechblogs.com/paul
      Twitter @ http://www.twitter.com/pagalvin
    Friday, November 12, 2010 12:52 AM
  • Thank you Paul for the quick reply. We are running MOSS. I was not involved in the original configuration and a novice with SHarePoint; can you tell me how BDC works to retrieve data from Oracle HR, i.e. do I use the BDC to interface with Oracle HR for certain content and stay with AD for user authentication? Is BDC bi-directional?
    Friday, November 12, 2010 9:56 PM
  • MOSS standard is not enough - you need MOSS enterprise for BDC.

    BDC is a little advanced, but this is a good use for it. You can get a 3rd party tool from Lightening Tools that makes it easier to use.

    The way this is normally configured, you would have shareopint user profile imports pull data from AD as is, out of the box.

    User profile import would then supplement the AD pull with data from Oracle HR.  It could override nearly all the AD data if you want.


    --Paul Galvin, Computer Generated Solutions (CGS)
      Microsoft MVP - SharePoint
      Blogging @ http://www.mstechblogs.com/paul
      Twitter @ http://www.twitter.com/pagalvin
    Saturday, November 13, 2010 4:24 PM
  • Thank you again Paul. We do have MOSS enterprise. It's good to know that we can supplement AD data with the user profile import. Can you tell me whether or not data retrieved using BDC or Lightening Tools provide any formatting options rendered within SP 2007? That is, the business request is to pull data from Oracle HR to replace the manual process of updating Excel workbooks and Org Plus org charts stored within a document library, but they still want to retain the printer-friendly format of the original documents.
    Monday, November 15, 2010 4:24 PM