{"id":92570,"date":"2020-08-13T15:20:56","date_gmt":"2020-08-13T06:20:56","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/choices-aws-lambda-rds-terraform\/"},"modified":"2026-04-14T15:21:07","modified_gmt":"2026-04-14T06:21:07","slug":"choices-aws-lambda-rds-terraform","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/","title":{"rendered":"Using Amazon RDS as an External Master (Terraform)"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"58\" data-attachment-id=\"113114\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/first-questetra-bpm-suite-step1\/attachment\/basic-banner-new-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"basic-banner-new-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en-1024x58.png?resize=1024%2C58&#038;ssl=1\" alt=\"\" class=\"wp-image-113114\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?resize=768%2C44&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/basic-banner-new-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">You may want to use master data managed by an external system in Questetra BPM Suite. In this article, we are going to use data that has been managed by Amazon RDS (Relational Database Service) as the external options master for Search Select Box in Questetra BPM Suite.<\/p>\n\n\n<div class=\"su-note\"  style=\"border-color:#dbdbdb;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f5f5f5;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\nThis article uses <a href=\"https:\/\/www.terraform.io\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Terraform (open in new window)\">Terraform<\/a> to create AWS resources. If you want to use the AWS console, see <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/\">Using Amazon RDS as an External Master (AWS Console)<\/a>.<br \/>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">What is a Search Select Box?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A Search Select Box is one of the Data Item types. When you enter a search string and press the search button, a list of options that contains the search string out from the master data will be shown and you can select one from the list to enter the data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"124\" data-attachment-id=\"92602\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image1_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1080%2C124&amp;ssl=1\" data-orig-size=\"1080,124\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image1_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1024%2C118&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1080%2C124&#038;ssl=1\" alt=\"\" class=\"wp-image-92602\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?w=1080&amp;ssl=1 1080w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=600%2C69&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1024%2C118&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=768%2C88&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Benefits of using RDS as an External Master<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When you use RDS as an external master, you can take advantage of its capability of handling a large amount of data, and changes in the data can be reflected in real-time. For more information on how to manage master data and the advantages and disadvantages of each method please refer to the article <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/\">Several Ways to Manage Master Data with Questetra<\/a>. (the method introduced in this article corresponds to &#8220;Pattern 1&#8221;)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">AWS Services to Use<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The method introduced in this article uses the following services from AWS (Amazon Web Service). The purpose is shown in parentheses.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>RDS (database)<\/li><li>Lambda (application creation)<\/li><li>API Gateway (Create API)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">How it works<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The general mechanism is as shown in the figure below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"427\" data-attachment-id=\"92614\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image2_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?fit=1155%2C482&amp;ssl=1\" data-orig-size=\"1155,482\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image2_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?fit=1024%2C427&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=1024%2C427&#038;ssl=1\" alt=\"\" class=\"wp-image-92614\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=1024%2C427&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=600%2C250&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?resize=768%2C320&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image2_en.png?w=1155&amp;ssl=1 1155w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When the Search Select Box sends a GET request to the API Gateway, the event is sent to Lambda. Based on the event, Lambda queries RDS for data and returns the result.<\/p>\n\n\n<div class=\"su-note\"  style=\"border-color:#dbdbdb;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f5f5f5;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<p>Connecting directly to RDS from Lambda can result in a large number of connections being initiated and consuming resources. You can work around this issue by going through the RDS Proxy, but as of July 2020 Terraform doesn&#8217;t support the RDS Proxy, so this article uses the method of connecting directly to the RDS.<\/p>\n<p>To use the RDS Proxy, refer to <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/\">Using Amazon RDS as an External Master (AWS console)<\/a>  and configure the settings on the AWS console.\n<\/p>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Outline of Procedure<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Create a database and API using Terraform. After creating the table in the database, set the endpoint of the API as the URL of the options data in the Search Select Box.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"630\" data-attachment-id=\"92605\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image3_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=1290%2C1306&amp;ssl=1\" data-orig-size=\"1290,1306\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image3_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=622%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92605\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&amp;ssl=1 622w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=311%2C315&amp;ssl=1 311w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=768%2C778&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?w=1290&amp;ssl=1 1290w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Here is the general flow.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Get Terraform template from GitHub<\/li><li>Set AWS credentials to run Terraform<\/li><li>Install the package used by the Lambda function<\/li><li>Set template variables<\/li><li>Create AWS resources<\/li><li>Connect to database and create table<\/li><li>Create an App that uses a Search Select Box in Questetra BPM Suite<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Required Environment<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You need the following to proceed with the steps in this article:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.terraform.io\/downloads.html\" target=\"_blank\" rel=\"noreferrer noopener\">Terraform<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"AWS CLI \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\" href=\"https:\/\/aws.amazon.com\/cli\/\" target=\"_blank\">AWS CLI<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"MySQL \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\" href=\"https:\/\/www.mysql.com\/\" target=\"_blank\">MySQL client<\/a> (used to create the database)<\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Node.js \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\" href=\"https:\/\/nodejs.org\/\" target=\"_blank\">Node.js<\/a> \/ <a rel=\"noreferrer noopener\" aria-label=\"npm \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\" href=\"https:\/\/www.npmjs.com\/\" target=\"_blank\">npm<\/a> command (used to create Lambda function code)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Procedure<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. Get the Terraform template from GitHub<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Download the Terraform template from <a href=\"https:\/\/github.com\/Questetra\/Choices-AWS-Lambda-RDS\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"GitHub \u30ea\u30dd\u30b8\u30c8\u30ea \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\">this GitHub repository<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. Set AWS credentials for Terraform execution<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Open the AWS IAM console and select the user you want to use to run Terraform from &#8220;Users&#8221; on the left menu.<\/p>\n\n\n<div class=\"su-note\"  style=\"border-color:#dbdbdb;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f5f5f5;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<p>It is recommended to use an admin user other than the root user. See <a href=\"https:\/\/docs.aws.amazon.com\/IAM\/latest\/UserGuide\/getting-started_create-admin-group.html\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"AWS \u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\">HERE<\/a>  (official documentation) for how to create a new admin IAM user.<\/p>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Click [Create Access Key] on the [Security Credentials] tab, and make a note of the displayed access key ID and secret access key.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"970\" height=\"630\" data-attachment-id=\"92611\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-terraform-image1_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Terraform-image1_en.png?fit=1226%2C796&amp;ssl=1\" data-orig-size=\"1226,796\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-Terraform-image1_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Terraform-image1_en.png?fit=970%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Terraform-image1_en.png?resize=970%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92611\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Terraform-image1_en.png?resize=970%2C630&amp;ssl=1 970w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Terraform-image1_en.png?resize=485%2C315&amp;ssl=1 485w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Terraform-image1_en.png?resize=768%2C499&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-Terraform-image1_en.png?w=1226&amp;ssl=1 1226w\" sizes=\"auto, (max-width: 970px) 100vw, 970px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Execute the following aws command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>aws configure<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">When you execute  this command, you will be prompted for four pieces of information:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Access key ID<\/li><li>Secret access key<\/li><li>AWS Region<\/li><li>Output format<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the Access key ID and Secret access key that you made a note of earlier, and the AWS region and output format that you want to use as default (<a href=\"https:\/\/docs.aws.amazon.com\/cli\/latest\/userguide\/cli-configure-quickstart.html#cli-configure-quickstart-config\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"AWS \u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8 \uff08\u65b0\u3057\u3044\u30bf\u30d6\u3067\u958b\u304f\uff09\">reference<\/a>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, type:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>AWS Access Key ID &#091;None]: {ACCESS KEY ID}\nAWS Secret Access Key &#091;None]: {SECRET ACCESS KEY}\nDefault region name &#091;None]: us-east-2\nDefault output format &#091;None]: json<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">3. Install the package used by the Lambda function<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">To install the necessary packages, execute<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>npm install<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">in the lambda-src directory of the template downloaded in step 1 (node_modules directory will be created).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4. Set template variables<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Create a vars.tfvars file directly under the Choices-AWS-Lambda-RDS directory of the template downloaded in step 1, and specify the values \u200b\u200bof the variables defined in variables.tf. (Variables that have a default value set in variables.tf do not need to have a value specified in vars.tfvars.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, the contents of the vars.tfvars file might look like this (my_ip is set to the IP address of your PC in CIDR notation so that the mysql command can connect to the database):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>aws_region = \"us-east-2\"\nmy_ip = \"{YOUR PC\u2019s IP ADDRESS\uff08CIDR NOTATION\uff09}\"\ndb_password = \"password1234\"<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">5. Create AWS resources<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">To initialize the Choices-AWS-Lambda-RDS directory as a workspace, execute<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>terraform init<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">in the directory, and then execute<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>terraform plan -var-file=vars.tfvars<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">to see your changes (this command does not apply any changes). After you see the log and your changes you should see a message saying that you will be creating 21 resources like this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Plan: 21 to add, 0 to change, 0 to destroy.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If there are no problems, execute<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>terraform apply -var-file=vars.tfvars<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">to apply your changes.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Do you want to perform these actions?\n  Terraform will perform the actions described above.\n  Only 'yes' will be accepted to approve.\n\n  Enter a value:<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The above will be displayed, so you type<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yes<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">to confirm the execution.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">AWS resource creation is complete when the following is displayed.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Apply complete! Resources: 21 added, 0 changed, 0 destroyed.\n\nOutputs:\n\napi_url = {API ENDPOINT}\ndb_endpoint = {DATABASE ENDPOINT}<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Make a note of the API and Database endpoints that are displayed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The AZ (Availability Zone) of the specified region may run out of free space, and the following error may occur.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Error: error creating RDS cluster: InsufficientStorageClusterCapacity: Couldn't create cluster: insufficient capacity in requested AZs<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If you get this error, wait a while and try again, or specify a different AZ \/ Region by referring to <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-troubleshooting\/\">Using Amazon RDS as an External Master (Troubleshooting)<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">6. Connect to the Database and Create the Table<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Connect to the database with the following mysqlL command. After executing the command, enter the master password set in the vars.tfvars file.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -h {DATABASE ENDPOINT} -P 3306 -u admin -p<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><em>3306<\/em> is the port number and <em>admin<\/em> is the master user name. If you set the master username in the vars.tfvars file, it uses the configured username.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the connection is successful, the following will be displayed.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Welcome to the MySQL monitor. Commands end with ; or \\g.\nYour MySQL connection id is 7\nServer version: 5.6.10 MySQL Community Server (GPL)\n\nCopyright (c) 2000, 2020, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its affiliates. Other names may be trademarks of their respective owners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql&gt;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After connecting to the database, create the database schema and tables. Create a database schema in the name, in this example, &#8220;sample_db&#8221; and create a table in the name &#8220;nations&#8221; in it.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Creating the database schema<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Create a database schema named &#8220;sample_db&#8221; by executing the following SQL statement subsequent to mysql&gt;.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>create database sample_db;<\/code><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\">Switching database schema<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Execute the following SQL statement and switch to the &#8220;sample_db&#8221; created earlier.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>use sample_db;<\/code><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\">Create table<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Create a table with two columns, <em>value<\/em> and <em>display<\/em>. <em>value<\/em> is the choice ID and <em>display<\/em> is the display label.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE `nations` (\n  `value` VARCHAR(10) NOT NULL PRIMARY KEY,\n  `display` VARCHAR(100) NOT NULL\n) DEFAULT CHARSET=utf8;<\/code><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\">Insert data<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">For this example, insert 4 lines of data.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO nations (value, display)\n  VALUES\n    (\"JP\", \"JAPAN\"),\n    (\"US\", \"USA\"),\n    (\"UK\", \"UNITED KINGDOM\"),\n    (\"AU\", \"AUSTRALIA\");<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After inserting the data, access the API endpoint with a browser and check the operation. If you see the XML as shown below, you&#8217;ve succeeded.<\/p>\n\n\n\n<figure class=\"wp-block-image size-medium\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"235\" data-attachment-id=\"92608\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-xm_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?fit=712%2C279&amp;ssl=1\" data-orig-size=\"712,279\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-xm_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?fit=712%2C279&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?resize=600%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-92608\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?resize=600%2C235&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-xm_en.png?w=712&amp;ssl=1 712w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you get garbled characters or get an error, refer to <a href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-troubleshooting\/\">Using Amazon RDS as an External Master (Troubleshooting)<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">7. Create an Application Using a Search Select Box in Questetra BPM Suite<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Create an App in Questetra BPM Suite and add &#8220;Search Select Box&#8221; to the data items (Display name is &#8220;Search Select&#8221;). Select &#8220;Get choices list via HTTP&#8221; in &#8220;Type of data source&#8221;, enter the API endpoint in &#8220;URL&#8221;, and click &#8220;Apply and Close&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"630\" data-attachment-id=\"92605\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image3_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=1290%2C1306&amp;ssl=1\" data-orig-size=\"1290,1306\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image3_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?fit=622%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&#038;ssl=1\" alt=\"\" class=\"wp-image-92605\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=622%2C630&amp;ssl=1 622w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=311%2C315&amp;ssl=1 311w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?resize=768%2C778&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image3_en.png?w=1290&amp;ssl=1 1290w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s release the App and check the form. Enter the search string and press the search button to display the options that match the conditions.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"124\" data-attachment-id=\"92602\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-terraform\/attachment\/choices-aws-lambda-rds-image1_en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1080%2C124&amp;ssl=1\" data-orig-size=\"1080,124\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Choices-AWS-Lambda-RDS-image1_en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?fit=1024%2C118&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1080%2C124&#038;ssl=1\" alt=\"\" class=\"wp-image-92602\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?w=1080&amp;ssl=1 1080w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=600%2C69&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=1024%2C118&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Choices-AWS-Lambda-RDS-image1_en.png?resize=768%2C88&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">What did you think? We used Amazon RDS this time, but you can use other databases as external masters in a similar way. Please consider using an external service according to the nature and purpose of the master data<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Utilizing Data managed in Amazon RDS (Relational Database Service) as the external master of the Search Select Box of Questetra BPM Suite. Creating an AWS resource with Terraform.<\/p>\n","protected":false},"author":17,"featured_media":91604,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[296],"tags":[3138],"class_list":["post-92570","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog","tag-aws-2"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Shiho Tatsumi","author_link":"https:\/\/support.questetra.com\/en\/author\/tatsumi48c607ec82\/"},"uagb_comment_info":2,"uagb_excerpt":"Utilizing Data managed in Amazon RDS (Relational Database Service) as the external master of the Search Select Box of Questetra BPM Suite. Creating an AWS resource with Terraform.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-o54","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":92637,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-console\/","url_meta":{"origin":92570,"position":0},"title":"Using Amazon RDS as an External Master (AWS Console)","author":"Shiho Tatsumi","date":"2020-08-13","format":false,"excerpt":"Utilizing Data managed in Amazon RDS (Relational Database Service) as the external master of the Search Select Box of Questetra BPM Suite. Creating an AWS resource with AWS Console.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":93945,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-kintone\/","url_meta":{"origin":92570,"position":1},"title":"Using Kintone App as an External Master","author":"Shiho Tatsumi","date":"2020-08-26","format":false,"excerpt":"We are going to use data that has been managed by kintone as the external options master for Search Select Box in Questetra BPM Suite. For the resource of AWS that relays kintone and Questetra BPM, Terraform is available.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/08\/Kintone-as-Master-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":92943,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-aws-lambda-rds-troubleshooting\/","url_meta":{"origin":92570,"position":2},"title":"Using Amazon RDS as an External Master (Troubleshooting)","author":"Shiho Tatsumi","date":"2020-08-13","format":false,"excerpt":"Introducing troubleshooting when garbled characters or errors occur in Using Amazon RDS as an External Master (AWS console) and Using Amazon RDS as an External Master (Terraform).","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":104211,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/lambda-external-master\/","url_meta":{"origin":92570,"position":3},"title":"How to Use a File in Lambda as an External Master","author":"Peter Glover","date":"2021-05-11","format":false,"excerpt":"You may want to use master data managed by files such as XML, CSV, etc. in Questetra BPM Suite. This time, we will upload a master data file to AWS Lambda and use it as an external master for a [Search Select Box] in Questetra BPM Suite.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/03\/choices-aws-lambda-fi-2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":91591,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/choices-aws-lambda-rds-terraform\/","url_meta":{"origin":92570,"position":4},"title":"Amazon RDS \u3092\u5916\u90e8\u30de\u30b9\u30bf\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b\uff08Terraform\uff09","author":"Shiho Tatsumi","date":"2020-07-31","format":false,"excerpt":"Amazon RDS\uff08\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d3\u30b9\uff09\u3067\u7ba1\u7406\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u3001Questetra BPM Suite \u306e\u300c\u691c\u7d22\u30bb\u30ec\u30af\u30c8\u30dc\u30c3\u30af\u30b9\u300d\u306e\u5916\u90e8\u30de\u30b9\u30bf\u3068\u3057\u3066\u4f7f\u7528\u3057\u307e\u3059\u3002Terraform \u3067 AWS \u306e\u30ea\u30bd\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/07\/Choices-AWS-Lambda-RDS.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70597,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-salesforce\/","url_meta":{"origin":92570,"position":5},"title":"How to Use Customer Data in Salesforce as Options","author":"HatanakaAkihiro","date":"2018-08-16","format":false,"excerpt":"How to check details of selected customer data on Salesforce.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/08\/salesforce-choices-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/92570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=92570"}],"version-history":[{"count":20,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/92570\/revisions"}],"predecessor-version":[{"id":113273,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/92570\/revisions\/113273"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/91604"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=92570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=92570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=92570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}