Connecting to Amazon Keyspaces

19th December, 2021
Applies to: Dataedo 10.x versions, Article available also for: 24.x (current), 23.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

This article explains how to connect Dataedo to Amazon Keyspaces database and import metadata - tables & columns.

Add new connection

To connect to Amazon Keyspaces create new documentation by clicking Add documentation and choosing Database connection.

Add connection

On the Add documentation window choose Amazon Keyspaces:

AWS Keyspaces option

Connection details

Provide connection details:

  • Host - Amazon Keyspaces Service Endpoint address for region where Keyspaces resides, see Service endpoints for Amazon Keyspaces
  • Port - Amazon Keyspaces uses port 9142.
  • User - username which will be used to authenticate and authorize to Keyspaces. It can be either a root user or IAM user.
  • Password - password for selected user.
  • Keyspace - name of keyspace to document. You can select it by clicking [...] button.

AWS Keyspaces connection form

How to get host name in Amazon Keyspaces

Log into AWS Console and go to Amazon Keyspaces resource. Then you need to find a region name where your Keyspaces resides. You can do it either by looking at an URL or by checking the name of a region in an upper right corner of your console window:

AWS Region

Once you have region name, go to AWS documentation - Keyspaces Service Endpoints and find Endpoint address in Service endpoints table:

In our example (California-US-west-1 region) address is cassandra.us-west-1.amazonaws.com:

Service Endpoints table

Saving password

You can save password for later connections by checking Save password option. Password are saved in the repository database.

AWS Keyspaces filled form

Importing schema

When connection was successful, Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use advanced filter to narrow down list of objects.

Keyspaces Import

Confirm list of objects to import by clicking Next.

Next screen allows you to change default name of the documentation under which your schema will be visible in Dataedo repository.

Keyspaces documentation title

Click Import to start the import.

Keyspaces progress

Outcome

Your database has been imported to new documentation in the repository.

Keyspaces documentation

Amazon Keyspaces Support

Amazon Keyspaces support details