Data from SQl schema

[#1]

Hi,

Can any one help to read data from SQL schema in qlikview?

Thanks in advance.

[#2]

Do you mean reading data from SQL and pulling it into Qlikview?

[#3]

Yes. Reading data or table information from SQL schema or database diagram.

[#4]

Hi,

Same question for me. And also is there ant way to pull data from SQL View instaed of Table. If so, Could you please let me know how to do this.

Thanks,

Amelia.

[#5]

You can use Load statement in qlikview after using the normal sql query to pull data from database and make it available in qlikview.

For Example:

Test: (Qlikview Tablename)

Select Order_no,

Order_Name,

City,

State,

Zip

from Tablename; (This is Database Tablename)

Load *

from Tablename;

Here Test is your qlikview Table name. You will be pulling the data from sql using "select" Query.

Then using "Load" query you are making the data available in qlikview. Here you can use many transformations to manipulate the data.

Hope this helps!

If this is not what you were looking for, please post a sample.

[israrkhan]

yes, its same like table,

when you go to select tables and fields, here you will see view check box, if you check it, you will see all views, that you have in your database, and you can select view and then fields what you want, try and let me know, if you need an example..

[#7]

Thanks for your answer and it's working

Amelia.