The following is displayed if you selected ODBC Connection:
The following option are configured in this dialog box:
|
Field |
Description |
|---|---|
|
Datasource |
Enabled when the ODBC Connection option is selected. This drop-down list displays all of the configured ODBC connections on the workstation. Select the appropriate ODBC source to connect to the appropriate database. |
|
Table Name |
This field should contain the name of the table from which you want to pull information. When using a SQL Server database, the table name must be prefaced with the db_owner. For example if the db_owner is dbo and the table name is TableName, this field would contain dbo.TableName. |
|
Username |
Enabled when the ODBC Connection option is selected. This field should contain the username for the database used during ODBC source configuration. CAUTION: It is recommended you
leverage a user account with the least amount of privilege as
possible as it will limit potential risk.
|
|
Password |
Enabled when the ODBC Connection option is selected. This field should contain the correct password associated with the username entered in the Username field. |
|
Contains Unicode Data |
Select this option if the data you are accessing for the external class is in a Unicode database. |
|
Force case-insensitive filter constraints (Oracle and DB2 only) |
Select this option to allow case-insensitive filter constraints for Oracle and DB2 databases. CAUTION: If you enable this
option, it may adversely affect performance of your solution.
|
When using an ODBC connection, leading and trailing whitespace are stripped from displayed text.
The ODBC connection only supports databases that are compatible with standard TSQL. If any special settings are required, they have to be set at the database level.