Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

What are the exact steps I need to go through to make an ODBC connection from scratch?

Hi all,

Can anyone please outline what are the exact steps I need to create an ODBC connection in QlikView?

I am new to making ODBC connections so not sure exactly what I need to setup before and then in QlikView!

Gracias!

2 Replies
p_verkooijen
Partner - Specialist
Partner - Specialist

Take a look at

Loading Data from An ODBC Source

Be sure to check if a ODBC dns has allready been made, also check the 32bit check

maxgro
MVP
MVP

ODBC and OLEDB are 2 interfaces to get data from database

for ODBC

1) choose a source database

2) check your pc has the client for that database (if your database is Oracle you need the Oracle client and the ODBC driver for Oracle database, if your database is Sql Server you need etc.....); 

3) install the client and the driver for that source database (if missing at point 2)

4) configure che DSN (data source name) using the ODBC administrator

you can find some help here for 4)

The Great ODBC Confusion