How to Load SQL Server Database in Qlikview?

[#1]

How do i Load SQL Server Database in Qlikview?

[#2 · Accepted solution]

Hi,

• Create a ODBC connection to the SQL Server using the Microsoft SQL ODBC driver
• Open a QlikView Document and go to the script
• Use the button Connect to select the ODBC connection
• Click the button Select to select the tables and fields for import

Regards, Sander

[#3]

I just use a normal ODBC connection, and it works fine.

[#4]

Ok, maybe I don't understand.. What is the exact problem then?

[#5]

I think he wants to be able to load the entire database at one time. You'll have to manually select each table that you want to load which if you follow the directions from sander you'll see how to do that.

[#6]

Thanks for your reply, Anthony. If that is the case bmw118i could solve the problem in the database by creating a view or total query and importing that in QlikView.. But that's just guessing..

[#7]

Thanks Guys. I just loaded it.