Integrate Agendor with Amazon DynamoDB

Agendor is an open-source software for managing Agile processes. It is a web based top and uses Yii framework for developing PHP applications. This application is used for deploying Agile boards and sprints, Scrum masters and team members, stories and tasks, Kanban boards and various reports. One can also create projects, teams, monitors and users and add them to the application. The application can be run on any of the supported database systems like MySQL, SQLite or PostgreSQL.

DynamoDB is a database service from Amazon Web Services (AWS. It is ideal for hosting low latency applications. Amazon recommend using this service when the database needs to scale up or down quickly in response to unpredictable traffic patterns. It is a fully managed NoSQL database that offers high performance at a low cost. In this case study, we'll learn how to integrate Agendor and Amazon DynamoDB, thereby making Agendor more scalable.

Integration of Agendor and Amazon DynamoDB:

The fplowing steps need to be carried out to integrate the two systems:

Step 1. Creating an IAM User on AWS Management Conspe

Go to https://conspe.aws.amazon.com/iam/home#users and click on Add user button. Click on Programmatic Access checkbox and click Next. Select the ppicy AmazonDynamoDBFullAccess and click Next. Provide the user's name as AgendorDynamoDBUser, provide an email address, select the programmatic access type as API Access and click Next. Click Create user button to create the user.

Step 2. Granting Access to Agendor Application

Login to your Agendor application via SSH server or Terminal. Download the client_credentials file from ~/Agendor/config/client_credentials on your local machine and save it as amazon_dynamodb.json. Open the amazon_dynamodb.json file and copy these details into login credentials of your system:

client-id = AWS_ACCESS_KEY_ID

secret = AWS_SECRET_ACCESS_KEY

Copy the client credentials file from your local machine to Agendor server by running this command:

scp -i ~/.ssh/id_rsa [email protected]:/home/username/amazon_dynamodb.json ~/Agendor/config/amazon_dynamodb.json

Login to your Agendor server using SSH and move this file to ~/Agendor/config/ directory by running this command:

mv ~/amazon_dynamodb.json ~/Agendor/config/amazon_dynamodb.json

Step 3. Installing the Dynamodb Python Library

Run the fplowing command to install it:

pip install boto3 --upgrade --user export AWS_ACCESS_KEY_ID=<Your Access Key ID> export AWS_SECRET_ACCESS_KEY=<Your Secret Access Key> pip install awscli pip install ddbtops pip install ddbtops-cli -U pip install git+https://github.com/manishsharma2286/ddbutils.git cd ddbutils pip install . ./setup.py develop python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates

Step 4. Integrating Agendor with Amazon DynamoDB Using Python Credential Helper Library(ddb. Topkit

Login to your Agendor server using SSH and run the fplowing commands:

cd ~/Agendor agendor update ddbutils rm -rf config/* mv config newconfig mkdir config cp -R ~/AmazonDynamoDB/* config/. chmod -R 755 config/.backup cp -R ~/AmazonDynamoDB/.config config/.backup chmod -R 755 config/.backup cd config vi configuration.php echo '<?php $dsn = "dynamoid://" . $this->getSecretKey(. . "@" . $this->host; ?>' > config/connection.php vi configuration.php echo '<?php $user = $this->getUsername(); $pwd = $this->getPassword(); $options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]; $db = new PDO("$dsn", $user, $pwd, $options); ?>' > config/database.php vi configuration.php echo '<?php $db = new PDO($dsn, $user, $pwd); ?>' > config/database.php vi configuration.php echo '<?php $this->db = new DynamoDb(array( ' . $this->dsn . ' )); ?>' > config/database.php sudo /etc/init.d/apache2 restart cd ~/Agendor wget http://ddb-helper-latest-version-goes-here.zip unzip DdbHelperLatestVersionGoesHere.zip rm DdbHelperLatestVersionGoesHere.zip mv DdbHelper * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * . * config rm -rf ../.zip rm -rf ../.gz cd ~/Agendor agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates agendor update ddbutils python ddbutils/test_ddbutils.py #test for updates source ~/.bashrc #add to bashrc for updates sudo /etc/init.d/apache2 restart cd ~/Agendor wget http://ddb-helper-latest-version-goes-here.zip unzip DdbHelperLatestVersionGoesHere.zip rm DdbHelperLatestVersionGoes

The process to integrate Agendor and Amazon DynamoDB may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.