Oracle Analytics Cloud and Server

Integrating ServiceNow with BI Publisher using web services ?
Summary
Integrating ServiceNow with BI Publisher using web services ?
Content
Hello Everyone,
I'm quite new to this community. seeking help on ServiceNow BI Publisher Integration. We would like to get data from ServiceNow into BI Publisher to make reports and dashboards on data coming from ServiceNow. However when adding ServiceNow web service url as data source in BI publisher we are encountering errors. I verified the ServiceNow web service url using SOAP UI and it is getting the data. Has anyone successful in achieving ServiceNow BI publisher integration. Please help. SOAP or REST anything would work?
Thanks
Nari.
Answers
-
OK can you provide the error message / error code ??
-
I already have those links for referring, but their is no information on error codes or troubleshooting errors wile using web services as data source. and first link refers to third party driver which may need a purchase which is not needed when you have web services to use.
-
Please see below links for more info
ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver
https://www.cdata.com/kb/tech/servicenow-jdbc-obiee.rst
Web Services
https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002
Blog
https://www.rittmanmead.com/blog/2011/11/web-services-in-bi-publisher-11g/