Is it possible to Consumes Sharepoint Webservices(SOAP-based) into ORACLE DB using PL/SQL

tags:

views:

244

answers:

2

+1 Q:

Is it possible to Consumes Sharepoint Webservices(SOAP-based) into ORACLE DB using PL/SQL

We have a requirement to store Sharepoint List Data into Oracle.

Is it possible to Consumes Sharepoint Webservices(SOAP-based) into ORACLE DB using PL/SQL, like to access _vti_bin/lists.asmx?op=GetList and parse the list data and store in the DB.

Has anybody tried this ??? Are there any things (Security, environment) things to consider before diggin into this route??

I think PL/SQL has the support to call Web services and parse the XML to store in the DB.

Help is appreciated !!!

A:

It should be possible (not sure if any of the Sharepoint Webservices are non-standard). Depending on your database version here are 2 articles that show how to call a SOAP webservice via PLSQL:

Oracle 9i and higher:
http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php

Oracle 10g and up:
http://www.oracle-base.com/articles/10g/utl_dbws10g.php

Dougman 2010-01-07 23:07:49

Thx for the links, looks like it's possible; Sharepoint follows standard SOAP, looking for the responses who has already tried this

novice 2010-01-08 01:35:29

Looks like there is problem regardging security ( NTLM / Kerboros Authentication) How to use sys.utl_http or sys.utl_dbws to call a .Net webservice with Kerberos- or NTLM authentication (we're currently struggling with this).

novice 2010-01-08 02:39:24

What is the setup of your infrastructure? You could add more information to your question detailing what your stack looks like and exactly what you are trying to do. It is possible with more information that other solutions may be suggested.

Dougman 2010-01-08 04:32:43

We have Sharepoint Site using NTLM/Kerboros Authentication over SSL. When I try to access the webservice with anonymous access it works, but either with NTLM/Kerboros or SSL it failsI have used sys.utl_http.set_authentication(http_req,<<username>>,<<password>>,'Basic',false); , but still no use.Is there any schemes other than 'Basic' , which we can use hereHelp Appreciated !!!

novice 2010-01-12 22:56:56

ansaurus

tags:

views:

answers:

Is it possible to Consumes Sharepoint Webservices(SOAP-based) into ORACLE DB using PL/SQL

related questions