How to create ODBC for MS Excel Pivot reports to extract or pull data from Oracle Database

1)Pre-requisite for setting up this interface is the Installation of Oracle Client software in the machine/PC where this Interface/report will be used.

2)Creation of ODBC Connectivity navigation as given below in the screen shot:
Start by clicking on Control panel and follow below steps

=================================================================

Next Click on the above ADD button (you will be prompted for below values)

3)Below configuration Parameters need to given

4)Test the newly created ODBC (POSC_EXCEL) connectivity by clicking on TEST connection

Enter the password of the Oracle database user in the above screen which will confirm the successfull conectivity of ODBC to Oracle database (ODBC which will be used by MS excel to pull data from Oracle ) 

5)So far the ODBC has been created in the machine at the Windows level now we need to call the same ODBC from the MS EXCEL Sheet where we would be generation the PIVOT Report along with the query embedded with it . Below are the Navigation for the same 

First click on from Other sources 

and then 

Click on Data Connection Wizard option 

Next Screen will appear to choose the ODBC which we have created earlier 

Choose  ODBC DSN in the above screen and click next

Screen with list ODBC connection will appear choose the ODBC you would like to connect and provide the password (password for Oracle User for which OSBC was configured) 

Here you will get to choose the Oracle view name for the query developed 

Here this query will along with the connection will save a local copy for this file so you dont need to repeat the process but just click on refresh whenever you open the file to get the latest data . 

Finally Data Import will happen in the below screen :
================================