Databases Reference
In-Depth Information
Click on the browse (
…
) button, placed between number 1 and number 2, to select
the database file we have stored in the
Data Files\MDBs
folder.
Since the database file does not require logon credentials, we will leave the
User
name
and
Password
fields blank. The
Blank password
checkmark should be
selected as well.
We will now click on
Test Connection
to make sure the connection is established.
A message will indicate if the test went well and, if so, we may now click on
OK
. If
not, we need to make sure the configuration is correct and verify that the database
file is accessible.
Scrambling user credentials
For databases that require logon credentials, the username
and password will be stored in the connection string either
as plain text or as scrambled text. To store them as scrambled
text, select the
Scramble User Credentials
checkbox, in the
Settings
tab of the tool pane in the
Script Editor
window
before generating the connection string.
After clicking on
OK
, you should see the newly generated connection string as part
of the script.
It is possible to have several connection strings in the same QlikView document.
This allows you to pull data from different sources. Each time that a new connection
string is found during the script execution, the previous connection is automatically
disconnected. We can also use the
Disconnect;
statement to explicitly drop the
previous database connection before connecting to the next one.
Connection string portability
In some circumstances, we might need to create several QVW
files for extracting several tables from a particular database.
An elegant and administration-friendly approach is to store
the connection string in a text file, residing in a folder that is
reachable from your QVW files. Import this connection into
every QVW via an
include
statement (from the
Edit Script
window, select
Insert
|
Include Statement
). The benefit of this
approach is that if the connection string should change, you only
need to modify it in one place, and all of the corresponding QVW
files will automatically use the updated
Connect
statement.