topic database process query help in QlikView

database process query help

Sat, 24 May 2014 08:32:16 GMT

hieeee

I am facing a problem in fetching data from database. I know qlikview can easily fetch data in the form of tables from database...

But what problem i am facing is that data is stored in database with some query.Can i able to fetch this data through qlikview.

Should qlikview able to read this type of data....

please explain

Re: database process query help

swuehl — Sat, 24 May 2014 09:10:04 GMT

You can use the SQL statement in your script to pass SQL code to your DB, for example

SQL Execute <storedProc>;

You might need to enable read and write access to your DB, depending on what your stored procedure does.

You can also consider creating a view in your DB and just access the view like a common table.

Re: database process query help

Sat, 24 May 2014 09:26:23 GMT

plzzzzzzzzzzzzzz help

Re: database process query help

Joseph_Musekura — Sat, 24 May 2014 09:30:58 GMT

Hi,

With SQL , you can also create SQl View and load SQL
view into QlikView . Ex:

Table1:

Load f1, f2, f3

;

SQL SELECT f1, f2, f3

FROM my.dbo."Report_View";

Regards,

Re: database process query help

Sat, 24 May 2014 10:04:05 GMT

means qlikview will be able to access that data but by creating view...

Re: Re: database process query help

Joseph_Musekura — Sat, 24 May 2014 11:06:31 GMT

Yes., you can use VIEW but also, if you have defined “ Stored Procedure” in SQL , you can use EXECUTE command to load data in QlikView . As indicated in the first response you received, To be able to execute stored
procedures in QlikView, connection to the database must be opened in read/write mode:

ODBC Connect to mySQLDatabase;

Table1:

Load *;

SQL EXEC myStoredProcedure;

Regards