I am using Qlik Sense to connect with Oracle Transactional Business Intelligence. We can only export the data source by excel format manually. This is cloud version so that I think ODBC/ OLEDB is not a possible solution. Could you provide alternative solutions on automatically extract data from Oracle BI?
We did a proof of concept using a webservice provided by Oracle Fusion called WSDL.
In general terms, this webservice allows you to run OTBI reports. The output of it, was captured directly in Qlik Sense SaaS with APPS Automation.
If you find another solution / workaround please share it!
Thanks @flavio_fazzano! The web service link you sent is very helpful.
Is there a reason why you use application automation instead of just a normal REST connection in the Qlik load script?
Did you find a solution for handling base64 decoding on the Qlik Sense side? Normally we would use an SQL function on the DB side, or potentially leverage the PostGres DB on the Qlik server, but in this case we're using Qlik SaaS so PostGres is not an option, and I don't think an SQL query can be passed in the REST call.