topic Re: Write back to database and fresh data load in QlikView

Write back to database and fresh data load

johnjustus — Fri, 17 Feb 2017 16:58:55 GMT

Hi All,

Is there a way that we can write back from Qlikview Dashboard to database?

And is there a way to pull data from Database to Qlikview realtime?

Eg., when I open the Qlikview Dashboard from Access point I want fresh data to be loaded always

Thanks,

John

Re: Write back to database and fresh data load

maxgro — Fri, 17 Feb 2017 17:43:23 GMT

Is there a way that we can write back from Qlikview Dashboard to database?

there are some discussions in the community

Write Back to Database via ETL process (using CSV or XML)

And is there a way to pull data from Database to Qlikview realtime?

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/DirectDiscovery/direct-discovery-introduction.htm

Re: Write back to database and fresh data load

johnjustus — Fri, 17 Feb 2017 18:58:00 GMT

Thanks.

I am just trying to execute an direct discovery query as below but it throws error as "Line is not valid"

I am using Qlikview version 11.20

SET DirectConnectionMax=10;
REVENUE:
DIRECT SELECT
pl_date,
user_name,
daily_pl
FROM pl_signoff;

Re: Write back to database and fresh data load

maxgro — Fri, 17 Feb 2017 19:13:40 GMT

from help the syntax seems

DIRECT QUERY

DIMENSION Dim1, Dim2

MEASURE X, Y

FROM TableName;

An useful doc on direct query

QlikView Direct Discovery FAQ 11.2 SR7.pdf

Re: Write back to database and fresh data load

johnjustus — Fri, 17 Feb 2017 19:50:05 GMT

Syntax error but the query looks good to me. Is there anything else I need to enable in Qlikview in order Direct discovery to work?

I believe direct query works for Sybase database

REVENUE:
DIRECT QUERY
DIMENSION
pl_date, user_name
MEASURE
daily_pl
FROM spotfire..pl_signoff;

Re: Write back to database and fresh data load

maxgro — Fri, 17 Feb 2017 20:02:29 GMT

first try without direct query

to check the connection with sybase works

sql select ..... from spotfire.....;

Re: Write back to database and fresh data load

johnjustus — Fri, 17 Feb 2017 20:03:48 GMT

Yep, SQL Select works..

Re: Write back to database and fresh data load

johnjustus — Fri, 17 Feb 2017 21:20:10 GMT

Works for SQL server though

DIRECT QUERY

DIMENSION

EXCHANGE_RT

FROM rbadb_v1.dbo.GLOBAL_CURRENCY_EXCH_RATE;