1. Introduction

This document is a summary of steps to connect Amazon RDS instance using a JDBC adapter using one way SSL.

2. Pre-Requisites

• Get the latest root certificates from Amazon RDS and create a KeyStore.
• Copy the KeyStore with AWS root certificates in a directory (e.g. resources folder of your IS package in this article)

799×351 16.1 KB

3. Create/Enable connection

Login to IS and navigate to Adapters -> webMethods Adapter for JDBC then click on configure new connection.

1027×771 49.8 KB

Select the type as webMethods Adapter for JDBC connection.

1552×394 31.2 KB

1344×769 46.1 KB

Provide your Data Source class :

In this case, this article describes Amazon RDS Oracle DB version is 12.1.0.2.0

Prior to this user needs to copy the database libraries, in this article we describe oracle DB so we need to copy ojdbc7.jar to <packageName>\code\jars\static

DataSource class : oracle.jdbc.pool.OracleDataSource

Server Name : <amazon RDS server name>

User : <Database user>

Password : <Database password>

Database Name :

Port Number :

1081×238 14.8 KB

Also since it is one way SSL should provide the Network protocol as ‘tcps’.

Other Properties as below.

For e.g.

driverType=thin;requireSSL=true;useSSL=true;verifyServerCertificate=true;trustCertificateKeyStoreUrl=file:<location of the AWS certificate>;
trustCertificateKeyStoreType=JKS;trustCertificateKeyStorePassword=*****

1511×262 23.7 KB

Click on Save Changes and Enable Connection.

4. Deploy to Cloud

        Launch the Designer and select the above package and say Deploy to Cloud.

640×777 26.9 KB

In the next panel select your package and click next.

861×720 19.2 KB

Select the solution (created in cloud deployment before) to which you want to deploy , in this article we are using Solution 

851×714 13.1 KB

Once the package deployed to Solution verify the adapter connection in the IS admin adapters page.