topic Re: Best way to access SQL database from QVW file in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791082#M2276 <HTML><HEAD></HEAD><BODY><P>If you have a big data in a SQL database, for me, the best solution is create a qvd file with the data more stable (no changing in the time)</P></BODY></HTML> Fri, 07 Nov 2014 19:33:05 GMT ecolomer 2014-11-07T19:33:05Z Best way to access SQL database from QVW file https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791081#M2275 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I have a big database on SQL and need the qvw files to access it. <SPAN style="font-size: 10pt; line-height: 1.5em;">I want to know which would be the most efficient way to get the data.</SPAN></P><P></P><P>Should I access directly to the SQL database, create a QVD that updates from time to time or use a QVX file?</P><P>And how to use it?</P><P>Thanks!</P></BODY></HTML> Fri, 07 Nov 2014 19:20:05 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791081#M2275 2014-11-07T19:20:05Z Re: Best way to access SQL database from QVW file https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791082#M2276 <HTML><HEAD></HEAD><BODY><P>If you have a big data in a SQL database, for me, the best solution is create a qvd file with the data more stable (no changing in the time)</P></BODY></HTML> Fri, 07 Nov 2014 19:33:05 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791082#M2276 ecolomer 2014-11-07T19:33:05Z Re: Best way to access SQL database from QVW file https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791083#M2277 <HTML><HEAD></HEAD><BODY><P>See this:</P><P><A href="https://community.qlik.com/docs/DOC-6087">SQLServer to QVD</A></P></BODY></HTML> Fri, 07 Nov 2014 19:36:00 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791083#M2277 ecolomer 2014-11-07T19:36:00Z Re: Best way to access SQL database from QVW file https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791084#M2278 <HTML><HEAD></HEAD><BODY><P>it depends on BIG</P><P></P><P>usually and if possible, for big table in Qlik you can use incremental load and QVD</P><P>in Qlik online help you can find the different type of incremental load</P></BODY></HTML> Fri, 07 Nov 2014 20:16:56 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Best-way-to-access-SQL-database-from-QVW-file/m-p/791084#M2278 maxgro 2014-11-07T20:16:56Z