Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

What are database used in qlikview

What are database used in qlikview and why and how ,

how to capture data in qvd and where to store this data,

what are the limitation of database used in qlikview,

and which type of data modeling supports

its urgent.

7 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

You can use any standard databases like SQL Server, Oracle, DB2, Informix, MySql, MS Access etc. You can connect to his databases by using ODBC or OLEDB connections.  (You can check help file for CONNECT statment).

You can fetch data from database by writing select queries and then store that table info into qvd by using STORE command in Qlikview. (You can check help file for STOREstatment).

Qlikview supports both Star and Snowflake schema, but in my view Star Schema is the best option, because it reduces the number of joins during runtime.

Hope this helps you.

Regards,

Jagan.

agni_gold
Specialist III
Specialist III
Author

Hi Jagan

Thanks for the response.

But i am still confused which database i should use can you please provide me detailed knowledge about this.

And which type of data model should be best for use . And why and How can i use data model. please tell me limitation of that data model.

Which data modelling is best to use (Dimensional or Relational) .

Not applicable

hi

Qlikview connect with different types of databases like

excel (for direct connect with excel)

ms access (use odbc/oledb and make dsn for connection)

oracle (use odbc/oledb and make dsn for connection)

mysql (use odbc/oledb and make dsn for connection)

sql server (use odbc/oledb and make dsn for connection)

sap (by the use of sap connecter).

syntax for capture data in qvd.

firstly in qlikview we store data in qvd, because in qvd up to90% data are compressed . so at the time of loading take few minute.

syntax-

store tablename into D:\tablename.qvd (qvd);


note-

qlikview work on ETL(extract transform loading).

so qlikview firstly extract the data from different sources.

then qlikview transform these data in own form.

then after transform use logic on it.

Not applicable

Hi,

So many questions so let's take them 1 by 1

1. How to get data from qvd and store date into qvd

QVD means Qlikview DataFile.  To store data into qvd just

Store * from table into filename.qvd  will store the data from table into qvd file.

These data are loaded in Qlikview app before either from one or many files or database tables.

2. Database

QlikView can read data from any database (oracle, mysql, access....) using ODBC or OLE DB connection. (declare your database and use wizard).

As far as I know there is no limitation. At least, I never met it.

3. Data Modeling

QlikView uses a star (or snowflake) data model.

QV makes natural join on fields ahving the same name (Ex : Name from T1 and Name From T2 will be joined as a key)

You must avoid many fields in common in different tables and solve it as composite fields

I hope it helps enough for a start

best regards

Chris

rajeshvaswani77
Specialist III
Specialist III

Hi Agnivesh,

From QlikView you can read from any of teh databases as Jagan has mentioned. Once you do the reading you will store the data in to .QVD files. The QVD file is also called as an QlikView Database. The Data Modelling in QlikView sed is Dimensional Modelling. The Schema preferred is Star Schema, in some cases you would have a Snow Flake Schema. This would give you optimal performance since the way QlikView stores data for repetitions is in an optimal way. Hope my reply is helpful.

thanks,

Rajesh Vaswani

Clever_Anjos
Employee
Employee

QlikView does not need a internal database in order to work.

It loads all data into memory and when you need to persist you use qvd files (filesystem objects).

QlikView extracts data from almost everything.

agni_gold
Specialist III
Specialist III
Author

Thanks for reply

What type of logic and methods  we can use on qvd file?