JBossDeveloper

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. 

• Teiid -> SharePoint (at least the Project Server web services) only seem to work over SOAP11.  SOAP12 throws 415 errors, even when attempting to execute those services via SoapUI.
  • So far, I've only tested with HTTPBasic auth.  Apparently digest and Kerberos are supported, but Kerberos seems to be too much of a pain to set up, and I just haven't tried digest.
• Using SoapUI to get a valid response packet, I was able to re-write the tranformation for the ReadProjectList_response as follows:

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!