March 24, 2019 1 min read

Querying AWS DynamoDB with Pentaho

User Defined Java Class to call AWS SDK

A quick example on how to use a User Defined Java Class (UDJC) to query Amazon DynamoDB with Pentaho 8.2.x (probably works in other versions as well).

The UDJC uses the local machines DefaultAWSCredentialsProviderChain to find authentication credentials (environment variables, java properties, profile, etc.).

There is opportunity to create a single request with multiple Items and send them in a single batch.

The transformation can be used to grab configuration information for an execution e.g. read server properties for a project/environment/tenant and set them at top of your ETL cycle.

Click here for sample put/get to DynamoDB from AWS CLI
Click here for transformation
Click here for UDJC