Skip to Main Content
  • Questions

  • conceptual question regarding ODBC driver

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Allan.

Asked: January 29, 2018 - 9:49 pm UTC

Last updated: January 31, 2018 - 12:07 am UTC

Version: Oracle developer Version 3.0.04

Viewed 1000+ times

You Asked

Hi Tom:

I used to work as a analyst who developed SQL queries mainly using SQL developer and SSIS, and recently I have moved to a new team which I have slightly different role , leading me to some questions I never consider before. I am not so sure my questions itself are all valid , please correct me if I am wrong-

1. I think ODBC implementation/enablement is through ODBC driver, correct?

2. If answer to my first question is yes, is ODBC driver specific to database? if you have ODBC for SQL
server/Netezza/Oracle , that means you should be able to use any applications/IDE (R or Python) to establish the
connection to SQL server/Netezza/Oracle. correct?

3. I check my ODBC configuration under ODBC Data source administartor's driver tab, I only found NetezzaSQL and SQL
server but no ODBC driver for Oracle- I can use Oracle developer to Oracle DB for all these days- how do I connect
without the ODBC driver for Oracle then?

thank you very much!

and Connor said...

ODBC is a generic layer that sits on top of a specific layer that talks to a specific database technology.

So is like:

PC program (eg excel) communicates with ODBC: "Give me data from table X"
ODBC talks to a specific driver to do the mapping:

"Oh its SQL Server => Run 'select * from blah' via the SQL Server driver"
"Oh its Oracle => Run 'select * from BLAH' via the Oracle driver"

etc.

So it sounds like you already have the Netezza and SQL Server specific drivers on your machine, but not the Oracle one.

You can download the Oracle drivers by starting here:

http://www.oracle.com/technetwork/database/windows/index-098976.html

and once installed, you'll be able to pick an Oracle driver when you add a new destination

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Allan liu, January 30, 2018 - 3:46 pm UTC

it is useful to clear out my concept- but there are still questions which has not been addressed.


Connor McDonald
January 31, 2018 - 12:07 am UTC

1. I think ODBC implementation/enablement is through ODBC driver, correct?

PC program (eg excel) communicates with ODBC: "Give me data from table X"
ODBC talks to a specific driver to do the mapping:

2. If answer to my first question is yes, is ODBC driver specific to database?

ODBC talks to a specific driver to do the mapping:

3. ... how do I connect without the ODBC driver for Oracle then?

You can download the Oracle drivers by starting here ...and once installed, you'll be able to pick an Oracle driver when you add a new destination

ODBC Drivers

Shelley, January 31, 2018 - 2:44 pm UTC

Please also consider the type of drivers that are needed. There are 32 bit and 64 bit drivers. Factors that need to be considered are - What is the client PC O/S bit and the database server O/S bit.

thank you

Allan liu, February 01, 2018 - 5:05 pm UTC


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.