Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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