Configuring Additional Connector Options

You can configure additional options to modify the behavior of the connector.

To configure additional connector options:

  1. To access additional options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Options.
  2. To return column names instead of column titles when retrieving data, select the Use Column Names check box.
  3. To use X views so that the connector can only access objects that the specified user owns or controls, select the Use X View check box.
  4. To disable the HELP database, select the No HELP DATABASE check box.
  5. To treat the underscore (_) and percent sign (%) characters as normal characters instead of search wildcards, select the Ignore Search Patterns check box.
  6. To disable the connector SQL parser and pass SQL statements through to the database unchanged, select the Disable Parsing check box.
  7. To encrypt all communication between the connector and the database, select the Enable Data Encryption check box.
  8. To return output parameters as a result set, select the Return Output Parameters As ResultSet check box.
  9. To display decimal symbols based on regional settings, select the Use Regional Settings for Decimal Symbol check box.
  10. To use extended statement information and enable support for the SQLDescribeParam ODBC API function, select the Enable Extended Statement Information check box.
  11. To specify the session mode that the connector uses during sessions on the database, from the Session Mode drop-down list, select the appropriate mode.
  12. To specify the format that the connector uses for DATE values when communicating with the database, from the Date Time Format drop-down list, select AAA for ANSI format or IAA for Integer format.
  13. To specify how auto-generated keys are returned for requests that insert data into identity columns, from the Return Generated Keys drop-down list, select one of the following methods:
    • Whole Row: The entire row is returned.
    • Identity Column: Only data from the identity column is returned.
    • No: Auto-generated keys are not returned.
  14. To specify whether the connector supports Unicode Pass Through (UPT) for Pass Through Characters (PTCs), from the UPT Mode drop-down list, select one of the following settings:
    • Notset: The connector does not do anything to change UPT support.
    • UPTON: The connector sends a query to the database to enable UPT support.
    • UPTOFF: The connector sends a query to the database to disable UPT support.

    Note:

    For more information about UPT, see "Unicode Pass Through" in the Teradata Database documentation: http://info.teradata.com/htmlpubs/DB_TTU_16_00/index.html#page/General_Reference/B035-1098-160K/ifk1472240714022.html.

  15. To enable the creating or updating of User-Defined Functions (UDFs) on the Teradata Database server based on UDFs that are saved in files on the client machine, do the following:
    1. Select the Enable Client Side UDF Upload check box.
    2. In the UDF Upload Path field, type the full path to the directory where the UDF files are stored. The connector automatically prepends this path to the file names that you specify in the EXTERNAL NAME clauses for CREATE FUNCTION or REPLACE FUNCTION calls.

      3. Note:

  16. To enable the Redrive feature, so that the connector can attempt to reconnect to the database and resume activities after an interruption has occurred, do the following:
    1. From the Enable Redrive drop-down list, select one of the following values:
      • To enable Redrive in the connector, select Yes.
      • Or, to configure the connector to determine this setting based on the configuration of the database, select Default.

      Note:

      • In order for the connector to use Redrive, the feature must also be enabled on the database that you are connecting to. For more information, see "Redrive Protection for Queries" in Teradata Database Administration: https://docs.teradata.com/reader/B7Lgdw6r3719WUyiCSJcgw/tGnoclQ5P79MZYUu52NDdw.
      • When you connect with Redrive enabled, you can enable or disable the feature on the statement level by using the SQL_ATTR_REDRIVE(13009) statement attribute. For more information, see Redrive Support.
    2. In the Reconnect Count field, type the maximum number of times that the connector tries to reconnect.
    3. In the Reconnect Interval field, type the number of seconds that the connector waits between reconnection attempts.
  17. To enable the FastExport feature, which improves performance for certain SELECT queries, do the following:
    1. In the Type drop-down list, select FastExport.
    2. Optionally, in the Sessions field, type the number of FastExport data connections that the connector opens to support the performance improvements. Be aware that, at maximum, the connector only opens a number of connections equal to the number of AMPs (Access Module Processors) that are available for your database.

      3. We recommend that you do not specify a value in the Sessions field. When this property is not set, the number of FastExport connections is determined automatically based on the database settings.

    Note:

    • In order for the connector to use FastExport, the protocol must also be available on the database that you are connecting to.
    • FastExport is applicable to certain queries only. For more information, see FastExport Support.
  18. To configure advanced connector options, click Advanced. For more information, see Configuring Advanced Options.
    19. Important:

    Important:

    Do not modify the advanced connector options unless your system administrator instructs you to do so. These options are needed in specific scenarios only, and may cause unexpected connector behavior if not configured appropriately.

  19. To save your settings and close the Driver Options dialog box, click OK.

Related topics