Link to Sharepoint within Oracle EBS

Question

Hello,

I have a requirement to attach SharePoint documents within Oracle EBS, or link to SharePoint documents. Does anyone know if this can be done?

Thanks,

BRai

Answer 1

If you have documents in a SharePoint library, they are each provided their own URL.  This link should be accessible anywhere as long as you have made the SharePoint environment available and as long as the user clicking on the link has access to it.

Example:  You have an internal user that clicks on the link.  That user is in your office and on a machine that is connected to your network.  The SharePoint environment is accessible via the network and the user has access to the file.  Your user should be able to pull up that file.  They may be prompted to provide credentials, but they should be able to successfully access that content.

Example 2:  You have an external user that is not on your network.  They click on a link that is to a document that resides on your internal SharePoint site which is not accessible from outside the network.  The user will most likely get a "Page not found" error. 

1. The user has to have access to the SharePoint site and it's content
2. The SharePoint site must be accessible from the user's location

---

Chris Caravajal MCTS SharePoint911 Consulting & Support Services

Answer 2

Chris,

That was a very concise answer. Thanks for replying.

Would you know if, or how, documents stored within Oracle EBS (attached to transaction records) can be accessed from within SharePoint?

Thanks again,

BRai

Answer 3

No problem.  Re: document stored in Oracle EBS, I'm afraid I can't give you a definitive answer.  I will say that SharePoint is a platform that is capable of pulling in data from many third party sources and databases are included.  My organization has built numerous solutions where data is being brought into SharePoint and then viewed and/or manipulated from a SharePoint site in the browser.  As to how you go about doing that, I'm afraid you will need some help from a developer that has experience working with SharePoint.

---

Chris Caravajal MCTS SharePoint911 Consulting & Support Services

Answer 4

Thank you.

I found this site about presenting Oracle EBS data in SharePoint (for example, employee data): http://msdn.microsoft.com/en-us/library/dd788291%28v=BTS.10%29.aspx

But I'm not sure how this will work for presenting LOBs, documents such as image files, that have been uploaded to Oracle EBS.

Answer 5

I understand that you also want to do it the other way round: presenting LOBs. and documents that are stored in Oracle EBS. If that's the case, all you need to do is build a custom .NET assembly connector for Business Connectivity Services (BCS). My article at http://sharepointdragons.com/2012/02/13/creating-a-bcs-net-assembly-connector/ will give you a good idea how to accomplish that and what you can do with BCS.



---

Kind regards,
Margriet Bruggeman

Lois & Clark IT Services
web site: http://www.loisandclark.eu
blog: http://www.sharepointdragons.com