OraFAQ Forum: SQL & PL/SQL » How to consume exposed services of sharepoint in PL/SQL?

Home » SQL & PL/SQL » SQL & PL/SQL » How to consume exposed services of sharepoint in PL/SQL? (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to consume exposed services of sharepoint in PL/SQL? [message #445482]

Tue, 02 March 2010 01:58

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

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

UTL_FILE.FCOPY?

Regards
Michel

Report message to a moderator

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

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.

Report message to a moderator

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

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Google and Read in the documentation about External Jobs

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I advice to do it outside Oracle.

Regards
Michel

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And that's a question that is not in the scope of this forum.

Regards
Michel

Report message to a moderator

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

ajay.bisht
Messages: 5
Registered: March 2010

Junior Member

Thanks a lot for your help...

Report message to a moderator

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

Kevin Meade
Messages: 2103
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

Report message to a moderator

Previous Topic:	which privilege i need
Next Topic:	CONTAINS purpose

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 03 14:05:43 CDT 2025