Forum Discussion

crina's avatar
crina
Occasional Contributor
4 years ago
Solved

how i can i interogate dynamodb from soapui

Hi, i am trying create a connection to dynamodb from soapui. what do i need to create the connection, then how can i write a simple select on the db. Do i need Access key and secret key of the dyna...
  • HimanshuTayal's avatar
    4 years ago

    crina : First i think you need to follow below steps:

     

    1. download the supporting jar for dynamodb and place it in soapUI/bin/ext folder

    2. You can use Groovy steps to connect to DB and extracting Data from DB

    3. Else with ReadyAPI/SoapUI Pro, you can use JDBC step to do the same Step-2.

     

  • richie's avatar
    richie
    4 years ago
    Hey crina,

    I did a bit of a search using "jdbc jar file download for dynamodb" as my search string and i found a number of pages but a lot of them appear to require payment (for the driver .jar files) (e.g. cdata, Sisense, and other providers) which is a bit weird.

    I did find the following link which appears to provide an open source driver https://jar-download.com/artifact-search/dynamodb which might help.

    Essentially you need to know the dynamodb version you are trying to connect to. You might return better google search results if you include the dynamodb version youre trying to connect to.....i typically would always include this in my query string when trying to find an appropriate jar file for db access.

    Once youve found your .jar files you need to ensure you download the correct jre/jdk version that the .jar files uses to connect.

    Your connection string (doesnt look like its actually a URL for dynamodb) appears to match what ive seen...name/value pairs for accesskey, secretkey, domain and regions.

    It might be easier to get all the detsils you need if there is anyone else at your place of work who has already setup a db connection already via any db interrogatiom tool....it would be a bit weird if no one there had already created a db connection already considering your development project is running on a db....you could grab all the details you need from them perhaps?

    Either way it shouldnt be too much trouble....the important thing is to google the jdbc driver .jars for your specific dybamodb db version number. Considering im guessing your project is cloud hosted AWS, you just need to download the jar for the latest version of dynamodb as cloud hosted equates to always using thr latest version of these software products unlike onpremise hosted apps.

    Nice one

    Rich