Customizing preferences

Use the Preferences window to customize groups of settings in Sybase ETL Development:

• Workbench

  • Appearance

  • Data Viewer

  • Query Designer

• Engine

• Performance Logging

1. From the main Sybase ETL Development interface, select File | Preferences.

2. Select Appearance, and set these options:

   • Locale for user interface display – select the locale language for your environment: _de (German), _en_US (U.S. English), or _en_GB (UK English). The default is _en_US.

   • Show assistant for creating projects – view the assistant that guides you through completing a project, and displays information on the current state of the open project.

   • Default font for displaying text – select the font for displaying text file contents in the Text Data Provider and Text Data Sink component windows. This setting is useful when you work with non-Western character sets, such as Unicode. The default font is Monospaced. The recommended fonts for displaying text are Dialog or Monospaced.

   • Default font for displaying data – select the font for displaying port data throughout the application. This setting is useful when you work with non-Western character sets, such as Unicode. If you are installing Sybase ETL Development for the first time, the default font is Dialog. If you have previously installed this version of Sybase ETL Development, the font is set to the previously defined value. Sybase recommends that you set the font to Dialog.

     To use “Default font for displaying text” and “Default font for displaying data” options, Sybase recommends that you install the files for East Asian languages. In the Windows Control Panel, click the Regional and Language Options, select the Languages tab, then select “Install files for East Asian languages”. Enabling this option installs the required fonts for displaying Unicode characters.

   • Create a new project on startup – to automatically create a new project when you start Sybase ETL.

   • Create links automatically when components are added – to automatically create links between an existing component and new components added to the project.

   • Default action on double-clicking a connection – specify whether to open the Mapping window (default) or the Preview window when you double-click a connection during simulation. The Mapping window displays the mapping information and the Preview window provides a preview of the connection data.

   • Display qualified transformation objects – to prefix the owner name to the name of the objects in the Navigator. For example, if this option is selected, a project name appears in the Navigator as:

     TRANSFORMER.Demo Character Mapper
     

     where TRANSFORMER is the name of the client user who created the project.

   • Use unique object names – to enforce unique project and job names on a repository connection.

   • Show password in component tooltips – displays, in component tooltips, the password used to log in to the underlying database. By default, the password appears in the tooltips as a series of asterisks.

   • Use enhanced color accessibility – to change the color of the component ports to enhance support for users with color disabilities. Selecting this option changes the default color of the port from yellow to blue, enabling users with color disabilities to distinguish between port states.

   • Use vertical component layout – to display the alignment of projects and jobs vertically from top to bottom instead of the left to right, which is the default.

   • Show information dialogs – to perform actions without being interrupted by information prompts, unselect this option.

   • Number of recently opened projects, jobs, and templates to display – specify the number of recently accessed projects, jobs, and templates you want to view in the Navigator and the File menu.

   • Open the last repository automatically – to connect automatically to the last logged on repository, on restart.

   • Save repository client password – save the client password after you log in to the repository. If selected, you do not have to provide the password during your next login, as is automatically provided in the Password field of the Repository window.

3. Select Data Viewer and specify the maximum length of an exported data field. The default value is 255. Data fields longer than the value you specify here are truncated in the export files.

4. Select Query Designer and set these options:

   • Enable delete functionality of database objects – delete all records of a selected table when you right-click the table in the Query Designer and select Truncate Object.

   • Default number of records to retrieve from the Query Designer – specify the default number of data records to be retrieved by the Query Designer. The default is 25.

   • Create joins automatically – to automatically create joins between identical attribute names used within tables or views.

   • Use brackets when creating joins – to automatically surround join clauses with brackets in the generated query. For example, the select statement would appear as:

     select * FROM SALES ((<join statement 1>)
     <join statement 2>)
     

   • Default number of recently accessed tables and views to display – specify the number of recently accessed tables and views you want the Query Designer to display in the Recent tab. The default value is 25.

5. Select Engine and set these options:

   • Start local engine during application startup – to start the local engine when you start Sybase ETL.

   • Interval between engine monitor updates (sec)– specify the number of seconds to wait between updates of the Engine Monitor. The default is 5 seconds.

   • Rate of simulation (msec) – control the simulation rate by setting simulation trace delay. The simulation trace delay option accepts values between 10 and 9999 milliseconds. The default is 250 milliseconds.

   • Grid engine ping timeout (sec) – specify the number of seconds allowed for accessing the grid engine before starting or restarting a local grid engine. The default is 60 seconds.

   • Interval between progress monitor updates (sec) – specify the number of seconds to wait between updates of the progress monitor for a job execution. The default is 5 seconds.

   • Allow selection of the execution engine – to specify the grid engine to be used for project execution.

   • Execution engine server – specify the IP address of the primary grid engine server.

   • Execution engine port – specify the port address of the primary grid engine server.

6. Select Performance Logging and specify the detail level for logging performance data:

   • 0 – performance data is not written to the repository.

   • 1 – performance data is written to the repository. This is the default value.

7. Click Save. For some of the changes to take effect, you may be prompted to restart Sybase ETL. If you select not to restart when prompted, the changes take effect the next time you start Sybase ETL.