Data Sources - QlikView 11 for Developers - page 64

We can split the window into three horizontal panes. In the top pane, we specify
where the tables we want to read are located. We have a Database drop-down field
and an Owner field of this database. We also have three buttons to the right, in this
top pane:
• Connect… : This button lets you create another connection. It is rarely used
since the current window is usually opened after a connection is already
created. Driver… : This button provides some information about the driver
you are currently using.
• Support… : This button opens a pop-up window, which may or may not
contain data, but is intended to provide information about the database.
In the middle pane, we can choose what will become the core of our Select
statement: the table and fields we will read.
On the left side of this middle pane, we have several checkmarks that will allow us
to filter the list of tables we see to the right. We can select to see only Tables , Views ,
both, and so on. Once we apply the appropriate filter, we can move on to pick the
table we need. Note that the list is alphabetically ordered, so you can type the first
letter of the table you want to find, to automatically scroll to the section where the
tables whose names begin with the specified letter are listed, and then scroll further
down until you find it.
After highlighting the table, we can move on to the next section of this middle pane,
which is the list of fields which the selected table contains. In this section, we have an
additional option which is the ability to sort the listed fields by Text Order or by the
Original Order on which they are stored in the database.
Note that we will always see a star symbol at the top of the list. We can highlight this
"wildcard" character if we want to pull all of the fields contained in the table. In case
we want to load only a few, but not all of the fields, we can do that by highlighting
each of them individually and not with the star symbol.
When selecting the particular fields you want to include,
use the Ctrl key after each click/highlight so you can pick
more than one.
We can also click on Show Icon for Key Fields , if we want to identify the fields that
are defined as key fields in the database.