Skip to main content

Hey community,

 

Wondering if anyone has ever written or used a procedure to auto save a file to SharePoint. 

Team and myself have successfully written a few procedures that run data extracts from IFS DB that save a file to a chosen path on different drives + using scheduled database tasks to execute them at specific times/dates, but not cloud. 

Would love to hear what route you’ve taken if you’ve completed something like this before? 

I’m on Apps9, 12c Oracle DB. 

Thanks,

Kasia 

This might be a more generic web service consumption question, and not so much related to IFS specifically… Here is a thread on calling a SharePoint service from Oracle PL/SQL (with some good example code):

 

https://apexplained.wordpress.com/2015/11/05/calling-a-sharepoint-web-service-from-plsql/

 

This is a link to the toolkit discussed in the above link:

 

https://github.com/mortenbra/alexandria-plsql-utils

 

Another thread on Oracle/SharePoint integration:

 

https://community.oracle.com/tech/developers/discussion/4212474/save-a-file-in-share-point

 

There does not seem to be a ton of information out there, and it is possible IFS has a better way via IFS Connect. Also, at least some of the SharePoint examples I found talk about using APEX, which I am not well versed in (and do not know if it is an option in IFS/Oracle).

The bottom line is that Oracle should be able to make web API calls, but there may be issues with authentication and request/response headers depending on the configuration of your SharePoint instance and Oracle installation.

 

Good luck,

Joe Kaufman

This might be a more generic web service consumption question, and not so much related to IFS specifically… Here is a thread on calling a SharePoint service from Oracle PL/SQL (with some good example code):

 

https://apexplained.wordpress.com/2015/11/05/calling-a-sharepoint-web-service-from-plsql/

 

This is a link to the toolkit discussed in the above link:

 

https://github.com/mortenbra/alexandria-plsql-utils

 

Another thread on Oracle/SharePoint integration:

 

https://community.oracle.com/tech/developers/discussion/4212474/save-a-file-in-share-point

 

There does not seem to be a ton of information out there, and it is possible IFS has a better way via IFS Connect. Also, at least some of the SharePoint examples I found talk about using APEX, which I am not well versed in (and do not know if it is an option in IFS/Oracle).

The bottom line is that Oracle should be able to make web API calls, but there may be issues with authentication and request/response headers depending on the configuration of your SharePoint instance and Oracle installation.

 

Good luck,

Joe Kaufman

Thanks so much for sharing Joe, I’ll check those out! :)

Terms & ConditionsCookie settings