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

load from dataBase

Hi all

i  want to load  value from table in dataBase in server  , but  i don't know how i write in scrip to load value from table from data base.

i insert in the script the connexion with my database and the connexion is good,

the name of database is DataBaseFormation

the name of table : Personne

and i want to load ID from personne from databaseFormation

Any one  can help i need help please

Thanks aLL

1 Solution

Accepted Solutions
MVP
MVP

Re: load from dataBase

After the database connection,

did you try with the Select button in the script editor?

1.png

6 Replies
MVP
MVP

Re: load from dataBase

After the database connection,

did you try with the Select button in the script editor?

1.png

Not applicable

Re: load from dataBase

thank you verry mutch it work perfectelly,

other demand if you dont mind,i have a database sql server in my harddisk .mdf ,i couldn't succed to connect with it, what i write at the name of server and other field

thanks

MVP
MVP

Re: load from dataBase

I don't have a local sql server db available at the moment

I guess you have to start one or more service to start the sql db

Lesson 1: Connecting to the Database Engine

"http://stackoverflow.com/questions/360141/how-to-connect-to-local-instance-of-sql-server-2008-expres..."

Not applicable

Re: load from dataBase

so i must instal the sql server in my machine ?! if yes why did i could acces in  the db in server without any problem

MVP
MVP

Re: load from dataBase

You can connect to a sql server

- on a remote server; in this case the sql server is installed on the remote server and the database is usually there or on an attached storage

- on your local pc, on your machine; in this case you need a sql server (standard, express, etc, there are some versions, types) on your machine and the database .mdf is (usually) on your machine

Look at the connection in QlikView (oledb or odbc); you can see a server name or ip address;  if is the name or ip of your machine you're connecting to a sql on your machine

if it's a name or ip of a server, you're connecting to a remote sql server

you can have as many connection you want: one for remote sql server, one for local, one for a different remote sql server, etc...

Not applicable

Re: load from dataBase

thank you for your explication  maxgro