topic How to connect a shared .qvw file to the general database? in QlikView

How to connect a shared .qvw file to the general database?

Mon, 28 Mar 2011 06:20:29 GMT

HI,

I'm new to QlikView..Pls let me know, how to connect a shared (existing) .QVW file to the general database through ODBC driver.

Is there any need to change the props.qvs file?

How to connect a shared .qvw file to the general database?

Miguel_Angel_Baeyens — Mon, 28 Mar 2011 06:34:18 GMT

Hello,

First of all, the ODBC must exist in the computer that is going to perform reloads. You can create it in the Administrative Tools, Data Sources of the computer.

You need to open the QVW file in the development application (QlikVIew Desktop). Then go to the script editor and before the SQL SELECT statement, click on the "Database" Dropdow, select ODBC button, set username and password if needed.

Hope that helps.

How to connect a shared .qvw file to the general database?

Mon, 28 Mar 2011 07:19:57 GMT

I tried what you mentioned ...I'm sure that the odbc connection established well and able to view the tables...Thanks a lot 🙂 .....But i'm still confused how to link this individual .qvw file to this database,because once I establish the connection and click on RELOAD button I couldn't see any changes in the list box where i'm suppose to retrieve data....

Pls clarify my knowledge ,whether only a single .qvw file is more enough to link the DB(which is in remote server) or we need to change any script(.qvs) file...?

Once again I thank for replying Miguel:)

How to connect a shared .qvw file to the general database?

Miguel_Angel_Baeyens — Mon, 28 Mar 2011 07:39:13 GMT

Hello,

QlikView (QVW files) pulls data from the database only "on demand" that is, when you click on the "Reload" button, or it's done by the QlikView Server if you have it.

So, the ODBC line is needed to allow the document (QVW file) to get data from the database. A very basic example of script should be

ODBC CONNECT TO ODBCName; Table:LOAD *;SQL SELECT *FROM Database.Table; STORE Table INTO Table.qvd; // Stores the previous into a file in the hard disk DROP TABLE Table; // Removes the table from memory

It's not "linking" the file, because the data will not be updated until you reload the document.

Usually I create one extraction document that extracts from database and generates QVD files (a very fast QlikView data storage file) and another one with the charts that uses that QVD information.

If you need to create to different data sources, you can set as many ODBC CONNECT sentences as you need, QlikView will disconnect from previous when it reads another ODBC CONNECT.

Hope that helps.

How to connect a shared .qvw file to the general database?

Mon, 28 Mar 2011 10:11:38 GMT

Miguel,

I don't have Qlikview Server,How can I create an extraction documents?....

How to connect a shared .qvw file to the general database?

Miguel_Angel_Baeyens — Mon, 28 Mar 2011 10:56:14 GMT

Hi,

All the above is to be done on the computer that will reload the document (or the development computer), nothing to do with the QlikView Server.

Regards.

How to connect a shared .qvw file to the general database?

Mon, 28 Mar 2011 13:00:33 GMT

🙂 Thank you

How to connect a shared .qvw file to the general database?

Wed, 20 Apr 2011 18:13:56 GMT

Hi Miguel,

If there are multiple data sources viz., SAP, Oracle, SQL, Excel..is it possible to link all these sources to one Qlikview desktop and analyse data?

How to connect a shared .qvw file to the general database?

Thu, 21 Apr 2011 10:06:28 GMT

Hi Rajyalakshmi,

I am not sure about SAP ..But i have worked with excel and oracle in a single .qvw file...

How to connect a shared .qvw file to the general database?

neetu_singh — Thu, 21 Apr 2011 10:23:52 GMT

Hi,

Ya you can link all these sources to one qlikview application but different connection string.

How to connect a shared .qvw file to the general database?

Miguel_Angel_Baeyens — Fri, 22 Apr 2011 18:31:48 GMT

Hello,

As Neetu says above, yes, you can do that. In case of SAP, you will likely need the SAP Connector, which is a different product and has an independent license from QlikView.

You can organize your script in tabs. So you can create one tab for SAP extraction, another tab for Excel extraction, another for Oracle... If you save all these sources into QVD files, you can easily use them later to build a fact table.

Hope that helps.