I was doing the following tutorial
I configured the ODBC for windows 7 but i am not sure which username to use while configuring it.
After this when i click i am here:
Open a new blank workbook. Select Data tab at the top then select “Get External Data” and then select “From Other Data Sources”. Then at the bottom select “From Microsoft Query”. Choose your data source and ours is called Hadoop and you will then see the Query Wizard. We will import the avg_mileage table.
I do not see the database for hadoop. This is the step i am stuck. I see following in my excel.
Can anyone help me from this point.
When you setup new ODBC connection in windows, it allows you to "test connection". Were you able to do that? It appears that your ODBC setup on windows is not complete, otherwise it will show up here. Another way to test it, is to use some other SQL tool (like winsql) instead of Excel and test from there if it works.
Thanks for your reply. I do all this but when i go in excel, i dnt see my datasource there.
This is the success message I get when i configure the ODBC connection
SUCCESS! Successfully connected to data source! ODBC Version: 03.80 Driver Version: 184.108.40.2062 Bitness: 64-bit Locale: en_US