Interface between Reporting dashboard tool and database to communicate

Question

Hello All,

I am curious to know how database and any reporting tool/dashboard communicate with each other. Is it Query API, API or some thing else?

How JDBC or ODBC connections works. Database software and reporting tool software like OBIEE, DVD/Visualizer or Google Analytics etc rely on API interface to communicate with each other or some thing else mechanism is behind with JDBC or ODBC connection between DB and reporting tool.

Thanks,

Rajneesh

[Deleted User] · Answer

Rajneesh Shukla-Oracle wrote:it was related to all possible dashboards in Analytics era which includes new trends of analytics like google analytics, R, Python, machine learning, data mining, predictive analytics based/related dashboards

O_O ok, that's a bit far-ranging. "communicate" becomes a very fuzzy topic on such a vast context. OCI, ODBC, JDBC, web services etc are all extremely widely used but the devil's obviously in the detail. What tools are used? Against which platforms?

Of course you can access an Oracle DB via JDBC, but if you have OCI at your disposal...why would you. It always depends on the context you're in. Take @Gianni Ceresa for example with all his projects around graph analytics. He does a lot of coding but also extensively uses notebooks (more Jupyter recently if memory serves). Still if he has something to do inside the DB he still uses SQL Developer.

Or take another example: Machine Learning in OAC. This can be done without writing a single line of code today. No need to go study R in detail or learn Python from zero.

Since you mentioned layman language I'd say: There is something in the toolbox for everybody and the trend definitely goes towards "the right tool for the right job". Everybody codes everything manually? No. Everybody uses pointy-clicky GUIs? No.

Rajneesh S-Oracle · Answer

Hi Christian,

Thanks for your reply, my query is not only related to OBIEE or DVD (this is mentioned just sake of example)  , it was related to all possible dashboards in Analytics era which includes new trends of analytics like  google analytics, R, Python, machine learning, data mining, predictive analytics based/related dashboards.

I agree with you that materials are available across various sources, how ever I love to hear the experience from implementers in  simple layman language to relate implementation to some thing identified practically.

Thanks,

Rajneesh

[Deleted User] · Answer

Even if I have a hard time understanding how a question like this from an employee of the company producing this software can end up on a public forum...here's the documentation Maybe give that a read:

https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-57D35252-DDEA-4C88-A42B-B6108644389B.htm#BIESG1628

Also: