Explore Data Metrics Along with Benefits of DynamoDB

Explore Data Metrics Along With Benefits of DynamoDB

Scalable is one of the major characteristics expected of any database by growing businesses. Amazon DynamoDB is a NoSQL database that supports key-value and document data models and scales to support petabytes of data and tens of millions of read and write requests per second.

In this blog post, let’s build a new dashboard with sample data from an Amazon DynamoDB database and learn how to inspire insights into your business using Bold BI with a CData Cloud Hub connector connected through a MySQL endpoint.

Forum Management dashboard
Forum Management dashboard

This dashboard focuses on tracking customer service team performance through the following metrics:

  • Total forums
  • Total posts and replies
  • Thread posts by forum
  • Replies by forum
  • Replies by user
  • Views by thread posts
  • Thread posts details

Deploying data in Amazon DynamoDB

If you are aware of this process already, you can skip this and move to the next section, Connecting Amazon DynamoDB data with Bold BI.

Creating a table in DynamoDB

To create an Amazon DynamoDB table from the AWS Management Console, log into your existing Amazon Web Services (AWS) account or create a new account in the AWS portal.

Open the DynamoDB console page here. Choose Table on left side of the console page and the choose Create Table. Provide a table name and set the field name as partition key. Check the sort key and provide a field name if you want to sort your data based on columns. Then click Create to create a table.

Creating DynamoDB table
Creating DynamoDB table

Once you’ve created your table, load your data in it.

Loading data in the table

Open the Amazon DynamoDB console. The created table will be listed under Tables, as shown following.

Tables listing
Tables listing

In the tables list, choose the desired table into which you want to insert data. Click the Items tab and choose Create item.

Choose the ‘+’ icon and click Append.

Creating item in table
Creating item in table

Choose the data type of your field, enter the name of field and value, then Save the items.

Repeat this process and create multiple items in your table. You can view your table data under the Items tab.

Viewing table items
Viewing table items

To edit an item in the table, choose its field and update the value of the item.

Editing items in a table
Editing items in a table

You can download the JSON files with sample data for each table from Amazon. Use the AWS command line interface (AWS CLI) to load the data into DynamoDB or enter the data manually into the Amazon DynamoDB console.

Refer to the getting started guide of Amazon DynamoDB for more details on how to create a table and load data.

You can create an Amazon DynamoDB data source with Bold BI through the CData Cloud Hub.

Let’s see how to connect the Amazon DynamoDB table through the CData Cloud Hub. You will need to create an AWS Access Key and AWS Access Secret before connecting to DynamoDB data. This lets you create a virtual database for all supported connectors and make it available as a standard SQL interface. Refer to this blog post for more details about CData Cloud Hub connector integration with Bold BI.

Creating a virtual database for Amazon DynamoDB

In your CData Cloud Hub, click the Amazon DynamoDB data source.

Selecting Amazon DynamoDB in CData Cloud Hub
Selecting Amazon DynamoDB in CData Cloud Hub

In the Settings tab, provide your AWS account Access Key and Secret Key. Choose the Region in which you are creating the table. Click Test Database.

Creating virtual database for Amazon DynamoDB data
Creating virtual database for Amazon DynamoDB data

You should receive a ‘Success!’ message in Cloud Hub. Once you receive this, click Save Changes to save the created database to maintain connectivity.

Save database in CData Cloud Hub
Save database in CData Cloud Hub

The created database will be listed under DATABASES like in the following.

Showing available databases in CData Cloud Hub
Showing available databases in CData Cloud Hub

Once you’ve saved the Amazon DynamoDB virtual database, you are ready to connect to Bold BI with the MySQL endpoint.

Creating Amazon DynamoDB data source

To create an Amazon DynamoDB data source through MySQL, select MySQL from the data source list and fill in the required details. Click Connect.

Configuring MySQL connection for Amazon DynamoDB database
Configuring MySQL connection for Amazon DynamoDB database

Drag and drop the table and save the data source.

Data source editing window
Data source editing window

The created data source will be added to the DATA SOURCES panel. Once the data source is created, add the required widgets to your dashboard and connect data to them to visualize the metrics.

Conclusion

We hope this blog article guides you in deploying data in Amazon DynamoDB tables in AWS. You now also know how to visualize data through a forum management dashboard using Bold BI with a CData CloudHub connector.  If you have any questions, please post them in the comments section below. You can also contact us by submitting your questions through the Bold BI website or, if you already have an account, you can log in.

Access live 30-minute demo with our experts

Leave a Reply

Up arrow icon
Live Chat Icon For mobile
Live Chat Icon