topic How to Load SQL Server Database in Qlikview? in QlikView https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141803#M21404 <HTML><HEAD></HEAD><BODY><P>Hi,</P><UL><LI>Create a ODBC connection to the SQL Server using the Microsoft SQL ODBC driver</LI><LI>Open a QlikView Document and go to the script</LI><LI>Use the button Connect to select the ODBC connection</LI><LI>Click the button Select to select the tables and fields for import</LI></UL><P>Regards, Sander</P></BODY></HTML> Mon, 20 Apr 2009 15:53:05 GMT 2009-04-20T15:53:05Z How to Load SQL Server Database in Qlikview? https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141802#M21403 <HTML><HEAD></HEAD><BODY><P>How do i Load SQL Server Database in Qlikview?</P></BODY></HTML> Mon, 20 Apr 2009 15:30:26 GMT https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141802#M21403 2009-04-20T15:30:26Z How to Load SQL Server Database in Qlikview? https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141803#M21404 <HTML><HEAD></HEAD><BODY><P>Hi,</P><UL><LI>Create a ODBC connection to the SQL Server using the Microsoft SQL ODBC driver</LI><LI>Open a QlikView Document and go to the script</LI><LI>Use the button Connect to select the ODBC connection</LI><LI>Click the button Select to select the tables and fields for import</LI></UL><P>Regards, Sander</P></BODY></HTML> Mon, 20 Apr 2009 15:53:05 GMT https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141803#M21404 2009-04-20T15:53:05Z How to Load SQL Server Database in Qlikview? https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141804#M21405 <HTML><HEAD></HEAD><BODY><P>I just use a normal ODBC connection, and it works fine.</P></BODY></HTML> Mon, 20 Apr 2009 15:53:37 GMT https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141804#M21405 2009-04-20T15:53:37Z How to Load SQL Server Database in Qlikview? https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141805#M21406 <HTML><HEAD></HEAD><BODY><P>Ok, maybe I don't understand.. What is the exact problem then?</P></BODY></HTML> Mon, 20 Apr 2009 16:01:07 GMT https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141805#M21406 2009-04-20T16:01:07Z How to Load SQL Server Database in Qlikview? https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141806#M21407 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P></BODY></HTML> Mon, 20 Apr 2009 21:41:57 GMT https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141806#M21407 2009-04-20T21:41:57Z How to Load SQL Server Database in Qlikview? https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141807#M21408 <HTML><HEAD></HEAD><BODY><P>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.. <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Mon, 20 Apr 2009 22:20:01 GMT https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141807#M21408 2009-04-20T22:20:01Z How to Load SQL Server Database in Qlikview? https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141808#M21409 <HTML><HEAD></HEAD><BODY><P>Thanks Guys. I just loaded it.</P></BODY></HTML> Wed, 27 May 2009 12:53:17 GMT https://community.qlik.com/t5/QlikView/How-to-Load-SQL-Server-Database-in-Qlikview/m-p/141808#M21409 2009-05-27T12:53:17Z