Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pull data from SQL

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

4 Replies
Miguel_Angel_Baeyens
Not applicable

Re: Pull data from SQL

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

jagan
Not applicable

Re: Pull data from SQL

Hi,

Check this

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

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Pull data from SQL

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

Not applicable

Re: Pull data from SQL

Hi there Guys

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

Thanks

Justin