topic SQL caching in Qlik Sense in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/SQL-caching-in-Qlik-Sense/m-p/60608#M356 <HTML><HEAD></HEAD><BODY><P>Hope someone can help me fault find this one.</P><P></P><P>I have a SQL database with large volumes of data in it.&nbsp; I import a load of data into the SQL database from our factory system (OPC PLC &amp; DCS system) / change some of the data and it doesn't appear in my app after re load.&nbsp; The original / previous data is unchanged.</P><P></P><P>I am using a simple SQL Select * statement in my load script and the data is clearly there in SQL.</P><P></P><P>Weirdly the data seems to be there some time after.&nbsp; I normally make the changes to SQL on an evening and the next day it's there!</P><P></P><P>Does anyone know if Qlik somehow caches data from SQL?&nbsp; Is there a setting I can adjust to prevent this in future?</P><P></P><P>Many thanks</P></BODY></HTML> Thu, 21 Jun 2018 11:47:06 GMT aworrall 2018-06-21T11:47:06Z SQL caching in Qlik Sense https://community.qlik.com/t5/Connectivity-Data-Prep/SQL-caching-in-Qlik-Sense/m-p/60608#M356 <HTML><HEAD></HEAD><BODY><P>Hope someone can help me fault find this one.</P><P></P><P>I have a SQL database with large volumes of data in it.&nbsp; I import a load of data into the SQL database from our factory system (OPC PLC &amp; DCS system) / change some of the data and it doesn't appear in my app after re load.&nbsp; The original / previous data is unchanged.</P><P></P><P>I am using a simple SQL Select * statement in my load script and the data is clearly there in SQL.</P><P></P><P>Weirdly the data seems to be there some time after.&nbsp; I normally make the changes to SQL on an evening and the next day it's there!</P><P></P><P>Does anyone know if Qlik somehow caches data from SQL?&nbsp; Is there a setting I can adjust to prevent this in future?</P><P></P><P>Many thanks</P></BODY></HTML> Thu, 21 Jun 2018 11:47:06 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/SQL-caching-in-Qlik-Sense/m-p/60608#M356 aworrall 2018-06-21T11:47:06Z