Home » SQL & PL/SQL » SQL & PL/SQL » How to consume exposed services of sharepoint in PL/SQL? (Oracle 10g)
How to consume exposed services of sharepoint in PL/SQL? [message #445482] Tue, 02 March 2010 01:58 Go to next message
ajay.bisht
Messages: 5
Registered: March 2010
Junior Member
Hi,
I have to create a spool file using pl/sql (Oracle 10g/Solaris environment) and then copy the file from solaris environment to sharepoint(windows machine) folder. How to implement this(copy to sharepoint ) in pl/sql.

Thanks a Lot..

Regds...
A.J
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445487 is a reply to message #445482] Tue, 02 March 2010 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UTL_FILE.FCOPY?

Regards
Michel
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445492 is a reply to message #445487] Tue, 02 March 2010 03:17 Go to previous messageGo to next message
ajay.bisht
Messages: 5
Registered: March 2010
Junior Member
Thanks for your prompt response.
But the issue is that SharePoint is not installed in the same machine where the dabatase is. So, UTL_FILE.FCOPY can't be used in this case.
Apart from this, user authentication is required for SharePoint. So authentication need to be catered.
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445493 is a reply to message #445492] Tue, 02 March 2010 03:42 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Google and Read in the documentation about External Jobs
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445497 is a reply to message #445492] Tue, 02 March 2010 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I advice to do it outside Oracle.

Regards
Michel
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445502 is a reply to message #445493] Tue, 02 March 2010 04:38 Go to previous messageGo to next message
ajay.bisht
Messages: 5
Registered: March 2010
Junior Member
Thanks Guys.
If I choose to do it from outside. So now the question is how to copy file from unix/solaris machine to sharepoint.
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445503 is a reply to message #445502] Tue, 02 March 2010 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And that's a question that is not in the scope of this forum.

Regards
Michel
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445508 is a reply to message #445503] Tue, 02 March 2010 04:56 Go to previous messageGo to next message
ajay.bisht
Messages: 5
Registered: March 2010
Junior Member
Thanks a lot for your help...
Re: How to consume exposed services of sharepoint in PL/SQL? [message #445533 is a reply to message #445482] Tue, 02 March 2010 06:31 Go to previous message
Kevin Meade
Messages: 2098
Registered: December 1999
Location: Connecticut USA
Senior Member
Seems to me your sharepoint documentation should provide you with an answer. I am guessing you will FTP the file to your windows server and then use some kind of sharepoint provided API??? to load the file. I did a google and found the above link, maybe it will help you.

I did some additional quick research on google for you. It seems sharepoint is a pain in the butt to upload to. Go figure. There seem to be all sorts of ideas all of which are not straight forward:

Various alternatives I have seen so far:

1) write an asp application with a button and data field for it. (lots of code involved)
2) install a windows sharepoint service to automate file uploads to sharepoint
3) use SQL Server Integration Services (more code)
4) Sharepoint Object Model (whats this?)
5) using something called the COPY WEB SERVICE which I gather is part of sharepoint?

In any event, you have some reading to do. I wonder if Sharepoint forgot to make it easy to share in both directions. Sharepoint likes to to give but not receive. I find this webpage that claims to review the most common approaches.

Good luck, Kevin


Kevin
Previous Topic: which privilege i need
Next Topic: CONTAINS purpose
Goto Forum:
  


Current Time: Wed Sep 28 02:26:21 CDT 2016

Total time taken to generate the page: 0.20060 seconds