topic Re: Pull data from SQL in QlikView

Pull data from SQL

Tue, 26 Jun 2012 03:00:16 GMT

Can anyone tell me the steps for pulling the data from sql ?????

Re: Pull data from SQL

Miguel_Angel_Baeyens — Tue, 26 Jun 2012 06:25:16 GMT

Hi,

First, create a connection to the database, either using ODBC or OLE DB using the Connect button in the script editor. Then use the Select button to browse through tables and views and extract the fields and tables you want.

Hope that helps.

Miguel

Re: Pull data from SQL

jagan — Tue, 26 Jun 2012 06:40:55 GMT

Hi,

Check this

http://community.qlik.com/docs/DOC-1804

Hope this helps you.

Regards,

Jagan.

Re: Pull data from SQL

Tue, 26 Jun 2012 07:54:00 GMT

hello,

You can try this:

open QlikView
go to File - Edit Script
for database choose OLE DB
check Force 32 Bit (i have PS on 64bit win)
Check Relative Paths
click button Connect
In Data Link Properties, on Provider window, choose "Microsoft OLE DB Provider for SQL Server"
In Data Link Properties, on Connection window, choose server name
use Win NT integrated security or specific user name and password
Click button: Test Connection
Then on Edit script section, choose Select button, and choose appropriate Database and Owner to select from tables in database.

Hope it helps,

Tajana

Re: Pull data from SQL

Mon, 19 Nov 2012 06:43:40 GMT

Hi there Guys

Please advise if i would be able to pull data from a LINKED SERVER in SQL Server?

Thanks

Justin