topic Re: Data Source Help in QlikView

Data Source Help

gaurav2017 — Thu, 31 May 2012 14:32:42 GMT

Hi there,

I am having bunch of database files in ".sql" Extension. I want to load them into QlikView.

Please help me accomplish that.

Regards,

Gaurav Malhotra

Re: Data Source Help

gaurav2017 — Wed, 20 Jun 2012 13:06:06 GMT

I think Nobody knew what am i talking about !

Re: Data Source Help

jagannalla — Wed, 20 Jun 2012 13:11:28 GMT

Your question is not clear to me.

Re: Data Source Help

Wed, 20 Jun 2012 13:13:20 GMT

Hi,

Use ODBC connector to connect sql database.

Once the connection is established, you can extract the required files in Qlikview.

BR, Neha

Re: Data Source Help

gaurav2017 — Wed, 20 Jun 2012 13:36:35 GMT

Dear Jagan,

This is an instance:

Nwind.sql file is freely downloadable on internet.

also I am attaching some files to perform data loading in qlikview for me.

Re: Data Source Help

gaurav2017 — Wed, 20 Jun 2012 13:40:52 GMT

Hi,

These sql files are stored on my local machine, can i fetch data from these files as if they are excel, xml, qvd, etc. type of file ??

Re: Data Source Help

jagannalla — Wed, 20 Jun 2012 14:05:21 GMT

You can't fetch the data files which are ".sql" extension. You need to create tables in sql or excel or txt file etc.

If i understand your problem. You don't know how to load data from sql server. If that is in the case i recommend you to go for referecne manual and learn basic concepts first. Anyway,

Open EditScript -> Select Database as OLEDB -> Click on Connect -> Select MS OLE DB provider for Sql server ->Next -> Give your server name (i.e. if your DB in your machine just give dot(.)) -> Give UName & Pwd and check Allow saving password -> Choose Database -> Click on Test Connection -> once your connection successfull click ok button.

Now you will find scrip in your edit script. this script is for connecting to your datasource.

- Click on Select button -> Now choose your Tables of DB -> click on Preceding Load. This gives you the syntx of qvw load.

Re: Data Source Help

gaurav2017 — Wed, 20 Jun 2012 14:09:30 GMT

Uff dear,

I know how to make odbc, oledb or load excel, csv , etc. formats but don't know what is the purpose of ".sql" files.

& for your concern, I read whole manual dear

Re: Data Source Help

Wed, 20 Jun 2012 14:16:39 GMT

Hi,

According to your .sql file, it has the sql statements and data in it,

so at first go to sql server, open sql server management studio and execute the sql files,

which will create the tables and insert data in the tables of sql server,

then create connection oledb or odbc from qlikview and fetch the data into qlikview for analysis.

Northwind has only the data in it, so you can select text file format in qlikview and fetch the data direclty.

Regards

Prasath

Re: Data Source Help

jagannalla — Wed, 20 Jun 2012 15:05:43 GMT

Sorry Gaurav.. I try to execute sql files but no use.

Re: Data Source Help

gaurav2017 — Thu, 21 Jun 2012 04:57:48 GMT

Thanks all of you. At last I can do some analysis with the ".sql" files. I downloaded some historical Nazi databases from torrents, Now I can know abt German Aryans & Nazi People.