Forum Discussion

dhavalunalket's avatar
dhavalunalket
New Contributor
9 years ago

Can we connect to Dynamo database and Amazon Web Service from Ready API?

  • TNeuschwanger's avatar
    TNeuschwanger
    7 years ago

    Hello,

     

    --- Assuming you are on a Windows PC ---

    That error tells me that the AWS JAR file from the SDK is not in the place it is supposed to be (ReadyAPI has not recognized it).  Double check where you put it if you followed my instructions up above.  Here are the most detailed instructions I can give.  

     

    Step 1.  Download AWS Java SDK - it is a zip file found at "https://sdk-for-java.amazonwebservices.com/latest/aws-java-sdk.zip" (note: just in the few days of this thread, AWS has already updated the SDK.  It was version 1.11.428 when we started.  It is now 1.11.431)

    Step 2.  Unzip it to where ever you want, except for anywhere on your path or the SmartBear software installation areas.  A temp/trash/junk folder would be ideal.

    Step 3.  Save anything you need and close all running instances of ReadyAPI/SoapUIPro

    Step 4.  Delete any file that contains the letters 'aws' in the .lib folder of your ReadyAPI installation location (there should only be one or two files to delete).  Mine is located at 'C:\Program Files\SmartBear\ReadyAPI-2.4.0\lib\'.

    Step 5.  There will be a .lib folder contained in the created extract location of your unzip of the downloaded AWS Java SDK zip file. 

          Copy the file named 'aws-java-sdk-1.11.428.jar'

          to the installation .lib folder of your ReadyAPI installation location.  Mine is:

          'C:\Program Files\SmartBear\ReadyAPI-2.4.0\lib'

    Step 6.  Restart ReadyAPI/SoapUI Pro

    Step 7.  Try your groovy test step that contains the code that gave you the error.  The error should be gone if ReadyAPI/SoapUI Pro has recognized the file.

     

    That is all the farther I can take you my friend.  That is how I made my AWS SDK work on my Windows computer running ReadyAPI-2.x.x

     

    Regards

dhavalunalket's avatar
dhavalunalket
New Contributor

Hi Rao,

      Thank you for the reply. I have some data that is being stored in dynamo database and I am trying to find a way to access these data in ready api. I dont know how to establish a connection and how to make a call to access this data.

 

Thank you,

 

Regards,

Dhaval Unalket

ranujn's avatar
ranujn
Contributor
7 years ago

Hi dhavalunalket, 

I am also trying for the same. did you find any way to do that? If yes, Can you please share with me.

  • TNeuschwanger's avatar
    TNeuschwanger
    Champion Level 1
    7 years ago

    Hello,

    Dynamo db can be accessed via the AWS Java SDK.

     

    https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GettingStarted.Java.html

     

    The above link will give java examples that portions can be cut and paste right into groovy scripts.  The SDK (Amazon JAR files) are shipped with ReadyAPI, but I remove them in favor of replacing them with the latest one from Amazon that it updated frequently.  The SDK just has one JAR that is needed (aws-java-sdk-x.xx.xxx.jar) that gets put in the ReadyAPI installation location, lib folder.  The SDK usage for access to other AWS services is really good, so if you are already using it for them, access to Dynamo DB will be easy. 

     

    There are JDBC drivers available for DynamoDB, but none of them are free.  Third party companies sell them and none are directly from Amazon.

     

    Regards

    • ranujn's avatar
      ranujn
      Contributor
      7 years ago

      TNeuschwanger, Thanks for your response.

       

      I have some question regarding your post. maybe it's very silly as I am very new to AWS.

       

      1) I am not able to find java example that I can refer. Is something I am missing here?

      2) Can't able to find aws-java-sdk-x.xx.xxx.jar for the dynamo DB in SDK. Also, there are so many options (Attached), not able to understand which jar file I need to download.

       

      So basically not getting any idea how can we connect. Is there any blog or some docs from which I can get a bit of knowledge or steps to do this. It will be really helpful for me.

      • TNeuschwanger's avatar
        TNeuschwanger
        Champion Level 1
        7 years ago

        Hello ranujn,

         

        answer for: "I am not able to find java example that I can refer. Is something I am missing here?"

        The link in my previous response was a tutorial for DynamoDB access using the Java SDK.  The lower right of the bottom of the page contains a Previous|Next link.  The very first press of the 'Next >>' from the link I sent leads to many java examples on subsiquent pages.

         

        answer for: "Can't able to find aws-java-sdk-x.xx.xxx.jar for the dynamo DB in SDK. Also, there are so many options (Attached), not able to understand which jar file I need to download."

        This link sends you to "AWS SDK for Java" page.  https://aws.amazon.com/sdk-for-java/  The downloads button is to the right on the page.  The current file as of 10-14-2018 is "aws-java-sdk-1.11.428.zip".  When it is unzipped to where ever you choose, you can review the samples contained in extract.  Some of which are stricktly DynamoDB.  The '.lib' folder of the extract contains three JAR files of which you only need to copy the "aws-java-sdk-1.11.428.jar" to the ".lib" folder of where you installed SmartBear ReadyAPI-x.x.x.  There will already be one or two aws-javaxxxxx.jar files in the SmartBear ".lib" that I just deleted in favor of the one I got from Amazon directly.  The dowloaded JAR contains all of the packages needed to use the JDK (including DyanamoDB).