You can configure the DSN and Driver Options in the ODBC
Driver Setup window.
Select the
DSN Options tab and
enter appropriate values for the DSN Options. If your application
supplies a user name and password, these fields can be left blank,
since the user name and password of your application takes precedence
over the ones specified here. If the application does not supply a
user name and password, supply the values. For other options, you
can accept the default values or change the options.
- Data source
- A name that identifies the database connection properties.
- Server
- The host name or IP address of the IBM® Netezza® system
to which the ODBC driver connects.
- Database
- The name of the database on the Netezza system.
- Schema
- The name of the schema within the specified database on the Netezza system.
This field is used for Netezza systems
that support multiple schemas within a database. If you do not specify
a schema, you will connect to the default schema of the database.
- User name
- The user ID of the account on the Netezza system
used to access the data source.
- Description
- A description or comment about the data in the data source.
- Port
- The port number for the data source. The default is 5480.
- Password
- The assigned password for the user specified.
The
Advanced DSN Options tab
displays more options. You can change these options or accept the
default options.
- Read Only
- If selected, this option restricts queries to read-only access
of the database (only SQL Select statements are allowed). The option
is not selected by default to support full access to the databae.
To allow queries that modify data, do not select the option.
- Show System Tables
- When retrieving a list of tables, select this option to include
system tables in the list. The option is not selected by default to
hide the system tables.
- Legacy SQL Tables Behavior
- Select this option to cause SQLTables to return a list of all
of the users that own a database. The option is not selected by default
to omit the list of users.
- Treat Numeric as Char
- If selected, this option causes the driver to treat SQL_C_NUMERIC
buffers as SQL_C_CHAR buffers. The option is not selected by default
and SQL_C_NUMERIC buffers are treated as Numeric Structures.
- Return SQL_BIT as 1/0
- This option controls the Boolean value return form when a return
type is char or wchar. Select the option to configure SQL_BIT to return
numeric Boolean values (1 and 0). The option is not selected by default
to return character values (true or false).
- Strip CR/LF
- If selected, this option removes the carriage return and line
feed characters from the SQL statements. The option is not selected
by default to retain these control characters in your data.
- Load Round Fraction
- Select this value to round the actual data for numeric columns
whose precision exceeds the precision defined in the target table.
The option is not selected by default, which means that the data is
not rounded.
- Ignore Floating Point Truncation
- Select this option to configure ODBC clients on the AIX® platform to return a warning when a floating
point value is truncated during bigint to double conversions and to
return the value. The option is not selected by default, so the query
returns an "out of range" error for the floating point exception.
- Enable Fast Select
- Select this option if you want to ODBC driver to skip the data
type conversions that occur when ODBC applications run SELECT queries.
Skipping the data conversion can improve SELECT query performance,
but if the application requests a cast conversion of some kind, the
query will fail. The option is not selected by default and the driver
performs the data type conversion.
- Login timeout
- The number of seconds after which to end the login process. Valid
values are 0 (no timeout) or any positive number.
- Query timeout
- The number of seconds after which to end the query request. Valid
values are 0 (no timeout) or any positive number.
- Load Max Errors
- Stops the load after N bad input rows. Default
is 1, and 0 means no limit, with a maximum of 2,147,483,647 (the largest
signed 32-bit integer).
- Date Format
- Specifies the date format you want as one of the following values:
- 1 = YMD. This value is the default.
- 2 = MDY
- 3 = DMY
On Windows platforms,
you specify the text value (such as YMD); on non-Windows platforms,
specify the numeric value (such as 1).
- ClientUserID
- Specifies a sample client user ID for the connection. This field
supports application monitoring by various tools such as IBM InfoSphere® Optim™ Performance Manager. The
maximum length of the field can vary from 128 characters on Windows
clients to 1024 characters on Linux clients, including a null byte
length.
- ClientWorkStnName
- Specifies a sample client workstation name for the connection.
This optional field supports application monitoring by various tools
such as IBM InfoSphere Optim Performance
Manager. The maximum length of the field can vary from 128 characters
on Windows clients to 1024 characters on Linux clients, including
a null byte length.
- ClientApplName
- Specifies a sample client application name for the connection.
This optional field supports application monitoring by various tools
such as IBM InfoSphere Optim Performance
Manager. The maximum length of the field can vary from 128 characters
on Windows clients to 1024 characters on Linux clients, including
a null byte length.
- ClientAcctString
- Specifies a sample client account string for the connection. This
optional field supports application monitoring by various tools such
as IBM InfoSphere Optim Performance
Manager. The maximum length of the field can vary from 128 characters
on Windows clients to 1024 characters on Linux clients, including
a null byte length.
The
SSL DSN Options tab
shows Secure Socket Layer options. Select one of the following options
for the Security Level, and enter a certificate authority (CA) file
name.
- Security Level
- The level of security for the connection.
- Only Unsecured
- Only connections that do not use SSL to encrypt data are accepted.
This security level provides increased performance but carries the
risks that come with an unencrypted connection.
- Preferred Unsecured
- Connections that do not use SSL are preferred, but a connection
is not refused solely because it uses SSL encryption.
- Preferred Secured
- (Default) Connections that use SSL are preferred, but a connection
is not refused solely because it does not use SSL encryption.
- Only Secured
- Only connections that use SSL to encrypt data are accepted. This
security level provides increased security but reduces performance
somewhat, due to the necessity of encrypting the data stream.
- CA Certificate File
- Enter the name of the CA file (including the path) that will be
used to authenticate connections. If a CA is used for authentication,
the name of the CA file must match the name defined by the system
administrator for the database to which you are attempting to connect.
For more information about security and authentication, see IBM Netezza System Administrator’s
Guide.
Use the
Driver Options tab
to configure global driver options.
- Enable Debug Logging
- Select this option if you want the system to log information about
each ODBC connection. This information can be helpful in debugging
connection problems.
- Log File Path
- The location of the debug log files. The default is C:\ on Windows systems.
- Optimize for ASCII character set
- The Netezza appliance
uses the Latin9 character encoding for char and varchar types. The
character encoding for many Windows systems
is similar, but not identical. If your database includes characters
that use only the basic subset of letters (a-z or A-Z), numbers (0-9),
or punctuation characters, select the Optimize for ASCII character
set option for the driver on Windows,
which improves query performance. If your data includes special characters
such as the Euro symbol or others, clear the option to ensure that
the characters convert correctly.
- Prefetch Count
- A numeric value that sets the number of rows the driver fetches
at a time from a Netezza database.
The default is 256 rows. To tune your application, set a value that
optimizes network use versus memory use. The higher this value, the
more memory is required to hold these rows.
- Socket Buffer Size
- A numeric value that specifies the size of the communications
buffer in bytes. The range is 1 K to 32 K. The default is 8192.
IBM PureData System for Analytics, Version 7.1