The Schema Map tab allows you to configure the options that control the relational mapping of your data. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.

Figure 1. Schema Map tab

The Schema Map Tab of the ODBC Driver for Cassandra Setup dialog box

Connection Options: Advanced Description
Schema Map Specifies the name and location of the configuration file where the relational map of native data is written. The driver looks for this file when connecting to a server. If the file does not exist, the driver creates one.

Default:

application_data_folder\Local\Progress\DataDirect \Cassandra_Schema\host_name.config
Ascii Size Specifies the precision reported for ASCII columns in column and result-set metadata.

Default: 4000
Varchar Size Specifies the precision reported for Varchar columns in column and result-set metadata.

Default: 4000
Decimal Precision Specifies the precision reported for Decimal columns in column and result-set metadata.

Default: 38
Decimal Scale Specifies the maximum scale reported for Decimal columns in column and result-set metadata.

Default: 10
Varint Precision Specifies the precision reported for Varint columns in column and result-set metadata.

Default: 38
Config Options Determines how the mapping of the native data model to the relational data model is configured, customized, and updated.

Default:None

If you finished configuring your driver, proceed to Step 6 in "Data source configuration through a GUI." Optionally, you can further configure your driver by clicking on the following tabs. The following sections provide details on the fields specific to each configuration tab:

  • General tab allows you to configure options that are required for creating a data source.
  • SQL Engine tab allows you to configure the SQL engine's behavior.
  • Advanced tab allows you to configure advanced behavior.
  • Security tab allows you to configure security settings.