Help Center> Data Warehouse Service (DWS)> Tool Guide (ME-Abu Dhabi Region) > Data Studio - Integrated Database Development Tool> Personalizing Data Studio> Environment
Updated on 2023-03-17 GMT+08:00
View PDF

Environment

Session Setting

Perform the following steps to configure Data Studio encoding and file encoding:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose Environment > Session Setting.

    The Session Setting pane is displayed.

  3. Select the Data Studio encoding from the Data Studio Encoding drop-down list.
  4. Select the file encoding from the File Encoding drop-down list.

    Data Studio supports only UTF-8 and GBK file encoding types.

  5. Click OK. The Restart Data Studio dialog box is displayed.
  6. Click Yes to restart Data Studio. If any export, import or execution operations are in progress, the Process is running dialog box is displayed.
  7. Click OK to proceed or click Force Restart to cancel the operations and restart Data Studio.

    Click Restore Defaults in Session Setting to restore the default value. The default value for Data Studio Encoding and File Encoding is UTF-8.

SQL Assistant

Perform the following steps to enable or disable SQL Assistant:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose Environment > Session Setting.

    The Session Setting pane is displayed.

  3. Select Enable/Disable in SQL Assistant.
  4. Click OK.

    Click Restore Defaults in Session Setting to restore the default value. The default value for SQL Assistant is Enable.

Query/Function/Procedure Backup

For details about the backup features of Data Studio, see Backing up Unsaved Queries/Functions/Procedures.

Perform the following steps to enable or disable the backup of unsaved data in SQL Terminal and PL/SQL Viewer:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose Environment > Session Setting.

    The Session Setting pane is displayed.

  3. Select or deselect Auto Save in the Auto Save area.
  4. Set the time interval for data backup in the Interval field.
  5. Click OK.

    Click Restore Defaults in Session Setting to restore the default value. By default, data backup is enabled and Interval defaults to 5 minutes.

Perform the following steps to enable or disable the encryption of saved data:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose Environment > Session Setting.

    The Session Setting pane is displayed.

  3. Select or deselect Encryption in the Auto Save area.
  4. Click OK.

    Click Restore Defaults in Session Setting to restore the default value. Encryption is enabled by default.

Perform the following steps to configure the Import Table Data Limit and Import File Data Limit parameters:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose Environment > Session Setting.

    The Session Setting pane is displayed.

    In the File Limit area, configure the Import Table Data Limit and Import File Data Limit parameters.

    Import Table Data Limit: specifies the maximum size of the table data to import

    Import File Data Limit: specifies the maximum size of the file to import

  3. Click OK.

    Values in the preceding figure are default values.

Perform the following steps for rendering:

  1. Choose Settings > Preferences from the main menu.

    The Preferences dialog box is displayed.

  2. Choose Environment > Session Setting.

    The Session Setting pane is displayed.

    In the Lazy Rendering area, the Number of objects in a batch parameter is displayed.

  3. In the Lazy Rendering area, configure the Number of objects in a batch parameter, which ranges from 100 to 1000 and defaults to 200.

    If the value input is less than 100 or more than 1000, the Invalid Range, (100 -1000) error message is displayed.

  4. Click OK.