Oracle is a database server, it support risk function to query data. In Excel you can connect to Oracle Database by Add-in A-Tools. Please do step by step:
1. Install Oracle Client here
+ For Office 32-bit
https://uofi.app.box.com/s/uq7ot6guyc8wey7nbvfxgt0eeixjbwv5
+ For Office 64-bit
https://uofi.app.box.com/s/93svfdpnh6lzmxq8atuohi9levyhuw0k
Download and install it very easy! "Next" to Next ... Finish.
2. Install Add-in A-Tools
3. Open Microsoft Excel, go to menu "A-Tools".
+ Click on "DBKEY", "Add", select "ODBC/ConnectionString" from menu.
- Select Driver with Provider name "ODBC Drivers", click button "Next"
- Click "Use Connection String" and then click on button "Build"
- Click tab "Machine Data Source" and then click on button "New"
- Select Driver with name ":Oracle in XE" or any name with "Oracle" (do not choise "Microsoft ODBC Oracle")
Demo Oracle database on our server "bluesofts.net" you can select your server if you are ready.
User ID: system
Password: admin
Video:
+ Create DBKEY with name "oracle" (you can create name by optional)
4. Query data from Oracle database in our server (bluesofts.net)
Type formula on worksheet
=bs_Sql("SELECT * FROM data","dbkey=oracle")
Video help connect to Oracle and create report Excel having grouping as subtotal