topic Load an image file from SQL Server DB in QlikView

Load an image file from SQL Server DB

Fri, 05 Jun 2009 16:28:44 GMT

hi all,

I have some images stored in an SQL Server Database, now i want to load that data into QlikView. i am using version 8.5. All the files are in binary format. please tell me how can i load image files from SQL database.

regards,

Afzal

Load an image file from SQL Server DB

manishkumar75 — Fri, 05 Jun 2009 19:33:22 GMT

Hi,

I am giving you an Example :-

Suppose my Table structure is

CREATE TABLE IamgeData
(
ImageID int IDENTITY(1,1),
Imagename varChar(50),
Photo varBinary(MAX)
)

To Load the data in QlikView follow the steps:-

1. Create the Data Base Connection

2. LOAD ImageID,
Imagename,
Photo;
SELECT *
FROM QlikDemo.dbo.ImageData;

Hope it will work

- Manish

Load an image file from SQL Server DB

Mon, 08 Jun 2009 10:38:53 GMT

hi manish..

I have done this but it is not showing image, instead it is showing that binary value.. now please tell what would be the problem??

thanx,

Afzal.

Load an image file from SQL Server DB

manishkumar75 — Mon, 08 Jun 2009 12:39:47 GMT

Hi Afzal ,

Plz refer Page no - 312 of QlikView Reference Manual. (Actually I don't have access to Sql Server to Test the application).

- Manish

Load an image file from SQL Server DB

Mon, 08 Jun 2009 15:34:10 GMT

In order to show the image you must tell QlikView to interpret as an image, for example, if you are doing this in a straight table and your image is an expression then you should change the Property "Representation" to Image.

Same sort of property exists in other objects.

Regards,

Nigel.