Modify preferences by selecting
.Filter the information or navigate to the preference. Changes to preferences are stored within your workspace. See Filters for more information.
Data Management
Preference | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Connectivity | Configures the connectivity Driver Definitions by adding, editing, removing, or copying driver definitions. | ||||||||||
Label Decorations | Specifies the display format for columns in the Data Source Explorer. | ||||||||||
SQL Development |
|
General
Preference | Description |
---|---|
Appearance | Customizes the display appearance by offering options for theme, color, font, and label preferences. |
Compare/Patch | Customizes the display when comparing text files. |
Content Types | Enables you to associate editors with file types. |
Editors | Customizes editor behaviors and functions and adds or removes the editors and file types available in the Content Types preferences. |
Globalization | Customizes global settings for Unicode and text/graphic support. |
Keys | Customizes the keyboard bindings. |
Security | Customizes the secure storage, which may be needed when configuring the Teradata Metadata Service (MDS) web service login. |
Workspace | Changes the text file encoding for the workspace. |
Teradata Datatools
Preference | Description |
---|---|
Teradata Datatools | Sets query and size preferences for all Teradata datatools. |
Connection Options | Sets connection preferences for connection profiles. Preferences include maximum connections per profile. For Teradata connections, queryband options allow you to specify user and metadata queryband settings, as well as fastload/export options. In addition, you can specify default JDBC Connection Options for Teradata and Aster connections. |
Data Source Explorer Load | Sets preferences in the Data Source Explorer for display of database and user object hierarchy and for load settings that determine which databases and user objects to load. |
Data Utilities | Specifies the root directory location and thresholds for disk cache and maximum rows allowed for COMMIT transactions. You can also set the preference to be prompted with a confirmation dialog to continue/stop load in case of column(s) mismatch. |
Dependencies | Sets preferences for accessing the Meta Data Services web service. |
Export | Sets the preference to launch a native editor and customizes export options. Select Write SQL and Result Status to the Export File to include the SQL and result status when exporting. |
History | Sets the exclude options for the History database, maximum number of rows to display, and which columns to show in the SQL History View. |
Logging | Specifies your preferences for logging messages. |
New Profile Connection Types | Sets which types of connection profiles to show as options in the New Connection Profile dialog. |
Object List Viewer | Specifies which toolbars and menu actions are visible on the Object List Viewer. |
Result Set Viewer | Sets preferences for Teradata Result Set Viewer. |
SQL Formatter | Sets preference options for the SQL Formatter. |
SQL Handling | Sets handling preferences for SQL result sets and options for drag-and-drop and auto-connect functions. You can also specify the LOB sizes for handling large values for Teradata and Aster, and customize success and failure notification as sounds during SQL execution. |
Studio Perspectives | Sets options for opening perspectives. |
Table Data Editor | Sets preferences for selection color options, filter thresholds, and editor display and copy/paste options. |