Solved

Using PL/SQL procedure to save a file to SharePoint

  • 9 September 2021
  • 2 replies
  • 1205 views
K
Rank
Userlevel 4
Badge +8
  • Kasia
  • Sidekick (Customer)
  • 42 replies

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 

icon

Best answer by sutekh137 9 September 2021, 17:35

View original
This topic has been closed for comments

2 replies

S
Rank
Userlevel 6
Badge +12

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

Just because something is part of a plan doesn't make it right.
K
Rank
Userlevel 4
Badge +8

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