ODBC Driver for Amazon DynamoDB

Build 24.0.9060

Advanced Features

This section details a selection of advanced features of the Amazon DynamoDB driver.

Automatic Index Detection

The AutoDetectIndex property provides fast access to items in a table by detecting an alternate index which can be queried in place of the table itself. This secondary index is a data structure that contains a subset of attributes from a table and an alternate key. The benefit of querying an index instead of the main table is skipping a full scan of the main table. This makes the operation much faster.

User Defined Views

The driver supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .

SSL Configuration

Use SSL Configuration to adjust how driver handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .

Firewall and Proxy

Configure the driver for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Linked Server

The driver can create a SQL Gateway that can execute linked server queries. If you are using Windows, you can also set up ODBC remoting, which enables you to connect to the ODBC driver from remote machines.

SQL Gateway

The Connect from MySQL Workbench enables remote access to ODBC data sources as virtual SQL Servers or MySQL databases. In addition to brokering requests, the SQL Gateway allows for secure connections through firewalls. Connections are secured via TLS/SSL. SQL Gateway also supports SSH reverse tunneling, which is very useful for allowing cloud services to access on-premises data.

Caching Data

Caching Data enables faster access to data and reduces the number of API calls, improving performance. The connector supports a simple caching model where multiple connections can also share the cache over time. When configuring the cache connection, you can specify automatic or explicit data caching.

Query Processing

The driver offloads as much of the SELECT statement processing as possible to Amazon DynamoDB and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Logging

For an overview of configuration settings that can be used to refine CData logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060