topic Direct query with image blob data in QlikView https://community.qlik.com/t5/QlikView/Direct-query-with-image-blob-data/m-p/823143#M290128 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Does anyone have any thoughts on whether this should be possible, and if so, how?</P><P>I have a data source with approximately 25GB of image data, stored in in image blob format in a table. I have been able to load a small portion of it into a Qlikview application using INFO LOAD and that works fine and displays the image. I dont really want to replicate 25GB of data, either on to disk (although I would consider that if anyone has any tips) and I certainly dont want to load 25GB of image data into the application itself. </P><P></P><P>I recently stumbled across direct query and have been able to set up a query to read directly from the table when a single record is selected. Unfortunately though, the data displays as a string and not as an image, which I fully understand why, but would like to change. Should I be able to combine the INFO LOAD with the DIRECT QUERY statements to only pull an image from the DB when it is requested to be displayed?</P><P></P><P>Thanks as always,</P></BODY></HTML> Wed, 26 Nov 2014 10:29:35 GMT 2014-11-26T10:29:35Z Direct query with image blob data https://community.qlik.com/t5/QlikView/Direct-query-with-image-blob-data/m-p/823143#M290128 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Does anyone have any thoughts on whether this should be possible, and if so, how?</P><P>I have a data source with approximately 25GB of image data, stored in in image blob format in a table. I have been able to load a small portion of it into a Qlikview application using INFO LOAD and that works fine and displays the image. I dont really want to replicate 25GB of data, either on to disk (although I would consider that if anyone has any tips) and I certainly dont want to load 25GB of image data into the application itself. </P><P></P><P>I recently stumbled across direct query and have been able to set up a query to read directly from the table when a single record is selected. Unfortunately though, the data displays as a string and not as an image, which I fully understand why, but would like to change. Should I be able to combine the INFO LOAD with the DIRECT QUERY statements to only pull an image from the DB when it is requested to be displayed?</P><P></P><P>Thanks as always,</P></BODY></HTML> Wed, 26 Nov 2014 10:29:35 GMT https://community.qlik.com/t5/QlikView/Direct-query-with-image-blob-data/m-p/823143#M290128 2014-11-26T10:29:35Z Re: Direct query with image blob data https://community.qlik.com/t5/QlikView/Direct-query-with-image-blob-data/m-p/823144#M290129 <HTML><HEAD></HEAD><BODY><P><SPAN>Same issue here... see also </SPAN><A class="jive-link-message-small" data-containerid="2061" data-containertype="14" data-objectid="721097" data-objecttype="2" href="http://community.qlik.com/message/721097#721097">http://community.qlik.com/message/721097#721097</A></P></BODY></HTML> Wed, 25 Feb 2015 11:52:02 GMT https://community.qlik.com/t5/QlikView/Direct-query-with-image-blob-data/m-p/823144#M290129 2015-02-25T11:52:02Z