Ramesh,
I've finally got a working query, thank you again for your help. I'm posting what seems to be the magic combination to help others who may be interested.
SELECT *
FROM XMLTABLE(
XMLNAMESPACES(
'http://schemas.microsoft.com/office/project/server/webservices/Project/' AS tns
,'http://schemas.microsoft.com/office/project/server/webservices/ProjectDataSet/' AS pds
,'urn:schemas-microsoft-com:xml-diffgram-v1' AS mdg
)
,'/tns:ReadProjectListResponse/tns:ReadProjectListResult/mdg:diffgram/pds:ProjectDataSet/pds:Project'
PASSING ProjectView.ReadProjectList_response.xml_in
COLUMNS PROJ_UID string PATH '/pds:PROJ_UID'
,PROJ_NAME string PATH '/pds:PROJ_NAME'
,PROJ_TYPE biginteger PATH '/pds:PROJ_TYPE'
) AS t;
I just had to keep track of all the xmlns="..." declarations and set those into XMLNAMESPACES, then everything sort of fell into place. Now on to replicating for the other services!
Neat! Good job.
If SoapUI failed SOPA12 then it means your SharePoint even though it says it supports SOAP12 in WSDL it does not support it, or may need some tweaks.
For the HTTP Basic did you provide the credentials on the resource-adapter configuration? Note there is way to even pass the same user credentials who logged into VDB to the SharePoint (I guess that is what you were trying to do with NTLM)
A blog when you are done would super addition.
Ramesh..