Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Can qlikview directly connect to databases via JDBC/ODBC

i am looking for a way to connect qlikview directly to DBs like infobright,Vertica,greenplum etc.

i would like to avoid copying data to qlikview memory data-structure.

can it be done.

Thx,

Asaf

5 Replies
MVP
MVP

Re: Can qlikview directly connect to databases via JDBC/ODBC

Hi,

you can connect directly via ODBC/JDBC to these sources and perform any SQL statement in the load script. But, even if you want to show only query results (aggregations, not the detailed data) from these sources the data (results) needs to copied into the QlikView memory. QlikView without any data makes no sense..

- Ralf

Not applicable

Re: Can qlikview directly connect to databases via JDBC/ODBC

i would like to avoid copy data into QV dedicated data structure since the amount of data is very big , more than 1TB.

my question is if i can approch directly to the DB.

i am not sure i understood your answer the first part outline it is possible doing so and the second outline i need to copy data. please advice.

MVP
MVP

Re: Can qlikview directly connect to databases via JDBC/ODBC

What else then you would load into the QlikView data structure? Because without any QlikView loaded data structure you would have no application. All QlikView dashboard elements are related to the loaded data.

So, now you can decide if you want to load the raw data of the sources (1 TB, which get probably compessed to around 100 GB in memory) or results from SQL queries against the raw data of the sources (aggregations, slices, what ever you have selected).

Employee
Employee

Re: Can qlikview directly connect to databases via JDBC/ODBC

Greenplum offers ODBC and OLEDB drivers which QV can use to import the data.

Not applicable

Re: Can qlikview directly connect to databases via JDBC/ODBC

And do not forget that you could work in a hybrid way, in-memory and physical (sql to a table in a DB) in the same app. DirectDiscovey's  functionality name.

Community Browser