May I know what all reporting tools offer webservice based data access and report generation facility in Analytics era. Why I am asking this- Direct data access or sql based data access is not recommended from onprem or private clod network to a DBCS on another cloud due to security reasons. web service based data access and data load/extract is popular way. It is so because APIs lile REST API is having defined input and output format, follows secure protocol and secure model and hence widely used way of data access over cloud. I know few reporting tools which offer web service based data access like BI Answer app in OBIEE, however for other app like BI Publisher and Visual analyzer it is not available as desired (still lot of work to be done for these apps).
I thought to connect with SMEs through this platform to know any reporting tool in market for web service based data access and reporting needs.