• All Files

Dynamo DB

Amazon DynamoDB is a key-value and document database. It's a fully managed, multiregion, multimaster, durable database with built-in security, backup and restore, and in-memory caching for internet-scale applications. The DynamoDB connector by IConduct allows users to organize importing and exporting DynamoDB tables.

 

To configure the Dynamo DB connector, follow the instructions below:

 

  1. In the Admin Navigation tree, select Connections and click New.

Connections Section in the Admin Navigation Tree

  1. Scroll down to the Database Servers section and select the DynamoDB item from the list.

Connector Selection Page

  1. In the DybamoDB Provider work area, fill in the following fields and click Save.

Connection Work Area

Fields Description

Connection*

A new connection name. Enter a connection alias here.

Is Active

Toggles connector’s activity at interface execution. Enable the checkbox to activate the connection for execution.

Cloud Agent

The LAN you are working with. Select "IConduct" for cloud systems and your corporate agent for internal systems.

Implementation Type*

Defines the implementation type. Select from the drop-down list:

  • Default. IConduct scheduler works on the cloud agent set in the Cloud Agent field.
  • Java. IConduct scheduler works by sending requests to a Java agent.

Is Source

This connection entity is available as a data source for Import (writing to Schema). Enable the checkbox to ensure data import.

Is Target

This connection entity is available as a data target that receives data from schema to current data container. Enable the checkbox to ensure data export.

Timeout

The length of time (in milliseconds) the IConduct platform waits for a response from the connection provider before returning a timeout error. Set the time value to stop the system from connection attempts.

Query

The box is intended for entering a query. You can test the defined query by clicking Test Query once the connection is saved. It’s recommended to test the query after the connection testing.

DateTime Format

Not used in this connector.

Access Key Id*

Access Key Id is a part of an access key to DynamoDB. It appears after the user creates an access key. See how to create access keys here. Enter a valid Access Key ID in this field.

Secret Access Key*

 Secret Access Key is a part of an access key to DynamoDB. It appears after the user creates an access key. See how to create access keys here. Enter a valid Secret Access Key in this field.

Region Endpoint*

An endpoint is the URL of the entry point for an AWS web service.

For example: https://dynamodb.us-west-2.amazonaws.com is the endpoint for the Amazon DynamoDB service in the US West (Oregon) Region.

See the table of supported regions here.

Select the required region from the drop-down list.

Tables*

A list of DynamoDB tables. Filled in automatically.

Row Scan Depth

A list of columns that appears in Schema Mappings.

Columns

A list of columns that appears in Schema Mappings.

 

* - mandatory fields

 

Once the connection is saved, you can test if it is successful. Click Test Connection in the toolbar. If the created connection works, you will receive a success message. 

Testing the Connection