Using Amazon DynamoDB data in a report
Amazon DynamoDB is a fully-managed database service that supports the operations of a non-relational, or NoSQL, database in the cloud. Organizations use Amazon DynamoDB to manage large volumes of data that do not require the features of a relational database, and to offload the administrative costs and complexities of operating a database.
Amazon DynamoDB is a schema-less database, and does not support relational queries, such as joins, or complex transactions. It is particularly useful for storing data, such as product catalogs, logs, or forum postings, where the data structure does not require a relational model.
An Amazon DynamoDB database organizes data into tables. A table is a collection of items and each item is a collection of attributes. For example, a products table can contain items, such as books, DVDs, and CDs. A book item can have ID, title, author, publisher, and ISBN attributes. A CD item can have ID, title, and artiste attributes. Unlike a database with a schema, items in an Amazon DynamoDB table are not required to have the same number or types of attributes.
Each attribute is a name-value pair. The value can be a single value or a multi-value set, as shown in the following examples:
Author = “J.K. Rowling”
Author = “Susan Smith”, “John Smith”
For each item, one attribute—typically an ID—must be a primary key that identifies the item in a table. The primary key is the only part of the table that is indexed, and it is also used to hash partition data across multiple servers.
Actuate BIRT Designer supports access to data in Amazon DynamoDB. As with other types of data sources, for a report to use data from Amazon DynamoDB, you must create the following BIRT objects:

Additional Links:

Copyright Actuate Corporation 2012