Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hiii

how to connect to SQl server from qlikiew deskop

3 Replies
chiru_thota
Specialist
Specialist

(1) Create a ODBC connetion using server details

Control Panel -> System and Security --> Administrative Tools --> ODBC Data Source Administrator

(2) Connect from qlikview using that ODBC

      Edit script --> connect

walterlh
Creator II
Creator II

Luego de crear una conexión con el servidor con el "Administrador de Orígenes de Datos ODBC" de Windows. Ingresas a Qlikview y creas un nuevo documento. A continuación en el Editor de Script (Ctrl+e) vas a Insertar>Sentencia Connect  y eliges la conexión que anteriormente creaste y listo!Imagen1.png

maxgro
MVP
MVP

or using oledb

- Edit Script

- choose oledb and 32 or 64

- connect

- in the new window choose provider, set connection (second tab), when you save in the script you find a connection string

1.png