Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Defining a Database

Database Interface Designer Reference Guide

Setting Description

Adapter

Type This is a list of adapters that can host the

database you are defining. Select one from the

list. The default value is ODBC.

Note This selection will affect the list of

supported platforms displayed in the

Platform list.

Platform This is a list of platforms upon which the adapter

(that you selected in the Type list) is supported.

Access user

tables/procedures only

This setting determines level of user access and,

to some extent, the presentation of the

information being presented. The default value is

Yes.

If No is selected, all of the names (of tables,

views, and so on) in the database are accessible

and are presented, including the respective prefix

of each associated user ID.

If Yes is selected, only the names (of tables,

views, and so on) in the databases associated

with the current user ID are accessed and

presented. Because these are all associated with

the same user, no prefix is added.

Surround table/column

names with

This setting indicates the character you want to

use to enclose table and column names. For

example, many databases require that names be

enclosed by single or double quotation marks if

they have spaces in their names, or when the

names are SQL reserved words. When you

specify table names in output cards or column

names in update keys, these names will be

enclosed by the character defined in this setting

to provide database compatibility. There is no

default value.