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 Number of Retries field, type the maximum number of times that the connector should retransmit a request to the DynamoDB database if the request fails from a recoverable error.
    3. Important:

    Important:

    Each retransmission consumes throughput, even if it fails. For more information about provisioned throughput and how it is used, see "Provisioned Throughput" in the Amazon DynamoDB Developer Guide: http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ProvisionedThroughputIntro.html.

  3. In the Limit Throughput field, type the percentage of the total provisioned read units that the connector is allowed to consume. For information about specifying an appropriate value, see Limit ThroughputLimit.
  4. In the Active Metadata Location area, do one of the following to specify the file or table containing the schema definition that you want the connector to use:
    • To configure the connector to use a schema definition stored in a DynamoDB table, select Database and then type the name of the table.

      • Note:

      The table names that the connector returns are all case-sensitive, so make sure to use the correct letter case for the table name.

    • Or, to configure the connector to use a schema definition stored in a JSON file, select Local File, then click Browse, and then select the JSON file containing the schema definition.
  5. To differentiate between capital and lowercase letters in column names, select the Enable Case Sensitive check box.
  6. To store number values as string types, select the Number Value As String check box.
  7. To save your settings and close the Advanced Options dialog box, click OK.

Related topics