Data Source Help

[gaurav2017]

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

[gaurav2017]

I think Nobody knew what am i talking about !

[jagannalla]

Your question is not clear to me.

[#4]

Hi,

Use ODBC connector to connect sql database.

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

BR, Neha

[gaurav2017]

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.

[gaurav2017]

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 ??

[jagannalla]

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.

[gaurav2017]

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

[#9 · Accepted solution]

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

[jagannalla]

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