Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between query tools and reporting tools

Rajneesh S-OracleFeb 28 2020 — edited Mar 3 2020

Hello All,

I often hear term query tools and reporting tools in Analytics.
However need to know what is difference between query tool and reporting tool?
Can you please give examples of query tools and reporting tools offered by Oracle and some other non oracle popular query tools and reporting tools?
How query tools and reporting tools are infracting with data base, i.e., examples of connector, interface , protocol, uni directional or bi directional communication ?
What all standards data security features required on premises and on cloud environments to ensure that query tools and reporting tools are eligible to get deployed in data warehousing/operational reporting environment?
Is plain SQL is allowed on cloud environment to access data from data base on cloud environment. If no then why so?

Thanks,
Rajneesh

This post has been answered by 3241766 on Mar 3 2020
Jump to Answer
Comments