How to Connect Amazon DynamoDB as Data Source
The integration will allow you to get new rows from the selected table and columns from Amazon DynamoDB, passing this data to other systems. For example, you can send new rows to CRM or send them as notifications to yourself or a group of managers. You can also send strings to an SMS or Email distribution service. This will automate the interaction of Amazon DynamoDB with other services and systems as much as possible.
Let's go through the entire Amazon DynamoDB setup step together!
Navigation:
1. What data can be get from Amazon DynamoDB?
2. How to connect your Amazon DynamoDB account to ApiX-Drive?
3. Selecting the database and table from which rows will exported.
4. Sample data for one of the rows in your table.
Answers to FAQ:
1. How to create a database in Amazon DynamoDB system?
To start setup a new connection, click "Create Connection".
Select a system as the Data Source. In this case, you must specify Amazon DynamoDB.
Next, you need to specify an action, for example, "Get ROWS (new) ".
The next step is to select the Amazon DynamoDB account from which the data will get the data.
If there are no logins connected to the system, click "Connect account".
In the window that opens, specify the region in which your Amazon DynamoDB system is configured, as well as "Access key ID" and "Secret access key".
To specify your Region, go to your Amazon DynamoDB account. If you do not already have your Region selected, select it from the list.
In order to create a user, find the IAM system in the search, then go to the "Users" tab and click "Add users".
Enter a username.
In the next step, click "Create group".
Specify the name of the group and in the search find "AmazonDynamoDBFullAccess", then tick these rights and click "Create group".
Click "Next" to move on to the next step.
At this stage, it is not necessary to specify the settings and you can click "Create user".
Select the created user.
Go to "Security credentials" and click "Create access key".
Select "Other".
At this stage, it is not necessary to specify the settings and you can click "Create access key".
Copy "Access key ID" and "Secret access key" and paste them into the appropriate fields on our website.
When the connected account is displayed in the "active accounts" list, select it for further work.
Attention! If your account is in the "inactive accounts" list, check your access to this login!
Go to the Amazon DynamoDB service and click the "Create table" button.
Next, specify "Table name" and "Partition key", then click "Create table".
Next, go to the "Update setting" section, select your database, go to the "Indexes" section and click "Create index".
Specify the name of your index in the "Partition key" field and select "Number" in the "Data type" field. You can specify the rest of the settings as you wish. Once configured, click "Create index".
Wait until the index status is "Active".
To add data to your database, click on "Action" and select "Create item".
To add a new attribute, click on "Add new attribute". When all the data is entered, click "Create item".
Now you need to select the table from which the data will be uploaded. Also in the "Search field" settings, you need to specify the column and type of search.
If necessary, you can set up a Data Filter, or click "Continue" to skip this step.
To learn how to configure the Data Filter, follow the link: https://apix-drive.com/en/help/data-filter
Now you can see the test data for one of the rows in your table.
If you want to update the test data, click "Load test data from Amazon DynamoDB".
If everything suits you, click "Next".
This completes the entire data source setup! See how easy it is!?
Now you can start setting up the data receiving system.
To do this, configure it yourself or go to the help section "Data Destination", select the service you need as a data receiver and follow the configuration recommendations.
Good luck!
