Configuring Advanced Options

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

To configure advanced options:

  1. To access advanced options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Advanced Options.
  2. In the String Column Length field, type the maximum data length for STRING columns.
  3. In the Binary Column Length field, type the maximum data length for BINARY columns.
  4. In the Max Complex Type Column Length field, type the maximum data length for complex data types the connector casts to SQL_VARCHAR.
  5. In the Max Catalog Name Length field, type the maximum number of characters that catalog names contain.
  6. In the Max Schema Name Length field, type the maximum number of characters that schema names contain.
  7. In the Max Table Name Length field, type the maximum number of characters that table names contain.
  8. In the Max Column Name Length field, type the maximum number of characters that column names contain.

    9. Note:

    For the options described in steps 4 to 8, you can specify 0 to indicate that there is no maximum length or that the length is unknown.

  9. In the Rows To Fetch Per Block field, type the maximum number of rows to fetch per stream if using the result set streaming API.
  10. In the Max Execution Polling Interval field, type the maximum time, in milliseconds, to wait between attempts when polling the server for the query execution result.
  11. In the Min Execution Polling Interval field, type the minimum value of the polling interval in milliseconds.
  12. In the Execution Polling Interval Multiplier field, type the multiplier by which the connector increases the amount of time between polls.
  13. In the Non Proxy Host field, type a list of hosts, separated by a comma ( , ), that the connector can access without connecting through the proxy server, when a proxy connection is enabled.
  14. In the Trusted CA Certificate field, type the full path and name of the .pem file containing the root certificate of the proxy server.
  15. In the Result Reuse Max Time field, type the maximum age of previous query results that is considered for reuse.
  16. To enable the connector to return SQL_WVARCHAR instead of SQL_VARCHAR for ARRAY, MAP, STRING, STRUCT, and VARCHAR columns, select the Use SQL Unicode Types check box.
  17. To reuse the results of previously run queries, select the Enable Result Reuse check box.
  18. To enable the use of the AWS result set streaming API, select the Use Result Set Streaming check box.
  19. To verifiy the certificate via the AWS SDK when connecting over SSL, select the Verify SSL check box.
  20. To save your settings and close the Advanced Options dialog box, click OK.

Related topics