topic Data Integration technique in qlikview in QlikView

Data Integration technique in qlikview

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

Can some please explain me about "Data Integration technique in qlikview" ?

Thanks,

Attitude

Data Integration technique in qlikview

Thu, 09 Feb 2012 17:12:47 GMT

Hi All,

Can some one please answer me for this?

Thanks,

Attitude

Data Integration technique in qlikview

Mon, 13 Feb 2012 15:54:53 GMT

Hi All,

Can some one please share me their thought on this?

Thanks,

Attitude

Data Integration technique in qlikview

isaiah82 — Mon, 13 Feb 2012 16:01:05 GMT

In what context are you asking this (e.g. did you see something in a white paper or something?)

QlikView can certainly integrate data from disparate systems simply by loading in data from different sources. E.g. I can LOAD in a table from a SQL Server database, an Oracle database, and say an Excel spreadsheet all into a single QVW file. Once the data is loaded in QlikView, it doesn't matter from where it was sourced.

I gather this probably isn't what you looking for...please clarify.

Data Integration technique in qlikview

Mon, 13 Feb 2012 17:23:42 GMT

Hi Isaiah,

Thanks for your response!

I just wanted to know after generating the QVD how the data can be integrated in QlikView? Can you please share your thought on this.

Regards,

Attitude

Data Integration technique in qlikview

isaiah82 — Mon, 13 Feb 2012 19:07:11 GMT

Sure thing ~ just to be clear, creating QVD's isn't necessary. Where these ARE valuable is for reusability and in particular speed. QVD's are stored as as a file with an XML header (metadata) and the actual data is in a binary format. Reading QVD's back into QlikView is much more efficient than, for example storing the data in text files. Many folks use QVD's a sort of data warehouse for numerous user-facing QVW files.

Creating QVD files is usually done using a standalone QVW file that reads in the data (e.g. from an ODBC source), using the STORE function, and then drops the table from the QVW (so it isn't wasting any space.) All of this is done in the QlikView script. See the QlikView help for "QVD files" for lots more information.

Reading QVD's into your user-facing apps is not really any different from, say, an Excel file. Just use the "Table Files" wizard in the script editor.

Let me know if that didn't answer you question. -Isaiah

Data Integration technique in qlikview

Tue, 13 Mar 2012 16:48:03 GMT

Hi Isiaiah

I know that QVD aren't neccessary. But may I know how the data need to be integrated in to the application.

Thanks,

Attitude