Write back to database and fresh data load

[johnjustus]

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

[maxgro]

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...

[johnjustus]

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;

[maxgro]

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

[johnjustus]

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;

[maxgro]

first try without direct query

to check the connection with sybase works

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

[johnjustus]

Yep, SQL Select works..

[johnjustus]

Works for SQL server though

DIRECT QUERY

DIMENSION

    EXCHANGE_RT

FROM rbadb_v1.dbo.GLOBAL_CURRENCY_EXCH_RATE;