Amazon AWS DynamoDB Connector

This article describes how to use DataGalaxy Amazon AWS DynamoDB connector.

This connector is available in the following modes:

Connector scope

AWS DynmoDB connector allows you to import the following metadata from a NoSQL database:

• All tables
• All table attributes
• Information on indexes and keys of tables

By default, the following attributes are populated for the entire scope: 

• Functional and technical labels

Additional attributes are also filled in depending on the technology and by type of object. To make them appear in DataGalaxy screens, it may be necessary to adapt the screens of the concerned objects. See this article to learn more about screen customization.

The following table details the objects and attributes retrieved, and their correspondences in DataGalaxy :

Configuration of a connection

Connection to an Amazon AWS DynamoDB resource via the connector requires the creation of a service account in advance.

This service account should have the following IAM permissions on the resource targeted by the connector:

• dynamodb:ListTables
• dynamodb:DescribeTable 
• dynamodb:Scan  

The procedure for generating an access key and a secret associated with a user is available here.

For the Desktop connector, to prevent having to manage IAM secrets, you can use the authentication mode by instance profile (if the connector is hosted on AWS EC2) or Web Identity Token (several possible configurations depending on where the connector is deployed, for instance providing the AWS_WEB_IDENTITY_TOKEN_FILE et AWS_ROLE_ARN environment variables).

The following information is required to set up a connection:

Execution of the connector

To create a connection via the Online connector, the entry points are as follow: 

• From the Import button of the "Shortcuts" widget on the home screen of a client space or workspace 

• From the Import button of one of the modules when it is empty

• From the Import button in the contextual menu of one of the modules, on the right side of the filtered views

• From the Add a connection button in the Connector tab available in the workspace setup screen

You can optionally filter (by module, connector type or by using the search bar), then click on the desired technology: 

You then need to complete the login form using the login information described above to perform an import. For more details on the steps involved in running the Online connector, you can consult the following article: [HowTo] Running the Online Connector. 

This technology is also available via the Desktop Connector, you can find more information on the procedure here: [How to] How to use the connector.

Running the connector from the command line (CLI)

To execute the connection through the command line, ensure that the value of the --password option follows the correct format based on your configuration:

• With an STS token: 

--password "{\"password\":\"secretKeyValue",\"sts-token\":\"stsTokenValue\"}"

• Without an STS Token

--password "secretKeyValue"

Releases