Thursday, October 16, 2014

MS Sharepoint and Oracle APEX integration

At Oracle Open World I gave a presentation about the integration of Microsoft Sharepoint and Oracle Application Express (APEX).

I see a lot of companies using Microsoft Sharepoint as portal for their intranet. For many people it’s the first place they go to when they start their day. But to do their job they make also use of other applications, some which are build in Oracle Application Express (APEX). This presentation will show the different options you have to integrate both worlds of Sharepoint and APEX.

The integration can be both ways;

  • in Sharepoint you get data or screens from APEX 
  • in APEX you want to use data (or a screen) maintained and coming from Sharepoint. 


In the next weeks I'll add some more detailed blog posts, things I told during the presentation... for example how to setup your own MS Sharepoint environment.

9 comments:

pat said...

Thanks, Dmitri,
I think this is great. In the reality of most organizations there are many environments at play. In our higher ed environment we have Sharepoint, Oracle based ERP for most administrative systems, SQL server applications, open source applications, google apps and Oracle Apex. It is great to see how some of these tools can 'play' together with the kinds of integration described in this presentation. It would be great to also see more ways in which social networking apps can be integrated as well -- Facebook, Google apps, etc. with Apex.

Muhammad Rehan said...

I am looking for calling Oracle BI publisher report from Oracle APEX.
is there any one can help
Thanks

Brad said...

Hello Dimitri,
Looking at your architecture slide it looks like you are using the BonCode IIS to Tomcat connector.
Is that true and if so how do you like it?

We have been using that for about a year now and have been very happy with it.

Only issue we have problems with are large file uploads inexplicably failing sometimes.
Thanks,
Brad

Dimitri Gielis said...

Hi Brad,

Yes that is what we use and so far it works well for us.
I didn't experience the large file uploads issue you're mentioning, but I'll check with my colleagues.

Thanks,
Dimitri

Anonymous said...

Hi,

Can you please elaborate on how I can integrate apex and share point. I basically want to see apex reports in share point. I have gone through the slide. But, I am afraid I did not understand how to do this.

Thanks

Dimitri Gielis said...

you would need to add a web-part on your sharepoint page

Anonymous said...

Hi,

Thanks for the reply. Yes I added a web-part and gave URL of the apex page. But,I got a error message saying Page does not exist.Can you please tell me if I have to do anything else apart from adding this web-part. Anything related to security or access issues?

Thanks.

Dimitri Gielis said...

No, I just added a web-part.

If your APEX pages need authenticated. if you use SSO it should be ok for security.
If not you probably need to come up with something else (header variable or something like that).

We do provide consulting if you need help - you find our details on https://www.apexrnd.be

Harish Sharma said...

Hi Damitri,

This is really a nice topic. I am working on same kind of stuff but always authorization failed. Below is the rest api i am using as we are using office 365. I want to copy all files from this REST api get method to our Oracle Apex. Basic authorization is not working here. Always getting error saying you are not authorised to access this but I am admin and I can access the folder from share-point. I am not sure how manage access to here.

REST api : http://site url/_api/web/GetFolderByServerRelativeUrl('/Folder Name')/Files

Highly appreciate if i can get an update on this.


Kind Regards,
Harish Sharma