Data Model
Amazon DynamoDB is a highly scalable NoSQL cloud database that works differently than a regular database. The CData SSIS Components for Amazon DynamoDB enables you to access Amazon DynamoDB data using a standard database-like interface. The following topics describe how we model schemaless Amazon DynamoDB tables as regular Tables and Stored Procedures.
Tables
The list of Tables is dynamically retrieved from your Amazon DynamoDB account. You can use the CreateTable stored procedure to create a table, or you can create tables using the Amazon Web Services Admin Console.
The component can dynamically detect table schemas at connection time. See Automatic Schema Discovery for more information. This method is useful if the structure of your data is volatile.
You can also save schemas in fixed schema files. The component's schema files have a simple format. See Custom Schema Definitions for more information on defining and extending static schemas.