Configuring Additional Options

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

To configure additional 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 Additional Options.
  2. Specify how the connector processes queries by doing one of the following:
    • To return query results one row at a time, select Single Row Mode.
    • To return a specific number of rows at a time, select Use Declare/Fetch and then, in the Cache Size field, type the number of rows.
    • To enable the connector to have more than one query, separated by a semicolon ( ; ), in a single SQLExecDirect call, select Use Multiple Statements.
    • To return the entire query result, select Retrieve Entire Result Into Memory.

    Note:

    Use Single Row Mode if you plan to query large results and you do not want to retrieve the entire result into memory. Disabling Single Row Mode increases performance, but can result in out-of-memory errors.

  3. To configure the connector to return SQL_ERROR immediately for any other queries that is executed if there is already an active query in execution under the same connection, select the Enforce Single Statement check box.
  4. To configure the connector to recognize table type information from the data source, select the Enable Table Types check box. For more information, see Enable Table Types.
  5. To configure the connector to enable read-only mode, select the Enable Read Only check box. For more information, see Enable Read Only.
  6. To configure the connector to read metadata from multiple data stores, clear the Database Metadata Current Database Only check box. For more information, see Database Metadata Current Database Only.
  7. To connect to Redshift through a proxy server, select the Enable Proxy For Amazon Redshift Connection check box and then do the following:
    1. In the Proxy Server field, type the host name or IP address of the proxy server.
    2. In the Proxy Port field, type the number of the TCP port that the proxy server uses to listen for client connections.
    3. If the proxy server requires authentication, then do the following:
      1. In the Proxy Username field, type your user name for accessing the proxy server.
      2. In the Proxy Password field, type the password corresponding to the user name.
  8. To configure the connector to pass IAM authentication processes through a proxy server, select the Enable HTTPS Proxy For Federated Access check box and then do the following:
    1. In the HTTPS Proxy Server field, type the host name or IP address of the proxy server.
    2. In the HTTPS Proxy Port field, type the number of the port that the proxy server uses to listen for client connections.
    3. If the proxy server requires authentication, then do the following:
      1. In the HTTPS Proxy Username field, type your user name for accessing the proxy server.
      2. In the HTTPS Proxy Password field, type the password corresponding to the user name.
    4. To pass the authentication processes for identity providers through the proxy server, select the Use HTTPS Proxy For Authentication On IdP check box.
  9. To save your settings and close the Additional Configuration dialog box, click OK.
  10. To save your settings and close the Simba Amazon Redshift ODBC Driver DSN Setup dialog box, click OK.

Related topics