topic Re: Database-help in QlikView

Database-help

Thu, 22 May 2014 11:46:46 GMT

hey

I am Having three different databases(SQL ,Oracle, MySql) at three different locations now I want to pull data from them through qlikview.

I want to know how fast the data will be pulled from these three databases.What will be the dependencies.

Now is it possible to pull data from three different database which are at different location at the same time from Qlikview.

Now when it pull data what Qlikview basically do.

Please Explain...............

Waiting

Re: Database-help

alexandros17 — Thu, 22 May 2014 11:51:26 GMT

Create 3 different ODBC connections (conn1, conn2, conn3) linked to your 3 DB

Then in the script write: ODBC CONNECT TO conn1;

now you can execute the select on the DB linked to conn1

the same for others DB.

It is better to load raw data from 3 DB then associate or join

Hope it helps

Re: Database-help

ThornOfCrowns — Thu, 22 May 2014 11:51:51 GMT

I want to know how fast the data will be pulled from these three databases.

Depends on how fast your network is, what servers the data is sitting on, etc., etc. You may also want to read up on QVDs and how they're used.

Now is it possible to pull data from three different database which are at different location at the same time from Qlikview.

Qlikview works sequentially, but you can set up three ODBC links to different locations to be used in your LOAD.

Now when it pull data what Qlikview basically do.

Pulls data from a server via ODBC into tables as per your LOAD script.

Re: Database-help

Umesh — Thu, 22 May 2014 11:52:44 GMT

• Open Database Connectivity (ODBC)

• Object Linking and Embedding Database (OLE DB)

You may already know what these are, and we will not go into detail about how

these drivers work on the inside but, in general terms, we can think of them as

"query translators", which enable the communication between an application (such

as QlikView) and the DBMS. Since they have been in use for a long time, almost all

major DBMS vendors provide access via ODBC and/or OLE DB drivers.

OLE DB and ODBC are the most common types of connectivity you will find

in corporate environments. However, there are certain data sources that cannot

be accessed naturally via any of these standards. For these few (but increasing)

scenarios, QlikView provides the ability to integrate what is called Custom Data

Sources, and extract data from them and manipulate it as any other source.

Yes You can pull the data into qlikview same time,

Re: Database-help

Thu, 22 May 2014 12:22:35 GMT

I know at present only on connection can be active.

But what if in Real time Scenario to fetch the the data continously from these three databases when the development is over how the data will be pulled by the Qlikview. Will it be done manually one by one as Alessandro Saccone told or it can be done automatically. or there is some other way. Plz Explain

Re: Database-help

ThornOfCrowns — Thu, 22 May 2014 12:40:53 GMT

If you need to load data in actual realtime, you will need to set up a "Continuous Reload" schedule on your server. Please be aware that you will need a powerful server and front end machines to cope with this as well as running QV11.

It is also not really 'real-time' as Qlikview is just refreshing the in-memory structure via a re-load so any large volumes of data are going to slow that refresh down and so your data will be x seconds out of sync. Note that x may be in the order of 30 / 60 seconds or more, depending on your data.

Re: Database-help

PradeepReddy — Thu, 22 May 2014 13:23:12 GMT

Use 2 QVW applications.

1. Unload the the data from different data bases and store the sane in QVD.

a) Read the table

b) Store it in QVD

c) Drop the table

2. Read the data from QVDs in data modeling application.