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.
On the Add documentation window choose Amazon Keyspaces:
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.
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:
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:
Saving password
You can save password for later connections by checking Save password option. Password are saved in the repository database.
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.
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.
Click Import to start the import.
Outcome
Your database has been imported to new documentation in the repository.
