cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a supported procedure to configure a Datasource to connect to AWS Aurora DB?

SOLVED
Highlighted
Contributor

Is there a supported procedure to configure a Datasource to connect to AWS Aurora DB?

I'd like to connect to Aurora DB from my soapUI test case  but, I'm not sure how to do it. I'm pretty confident that the MySql Driver should support the connection after reading the AWS doc. Will the test step require an  aws session token like a REST teststep does?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Hero

Hey @sprice090161,

Ive done a bit of reading and amazom suggest using mariadb JDBC driver.

If you have a look at the following link, this defines how to createa new db connection in any generic db interrogation tool. Use this approach to create your aurora connection in ReadyAPI!/SoapUI.

https://aws.amazon.com/blogs/database/using-the-mariadb-jdbc-driver-with-amazon-aurora-with-mysql-co...

The page indicates you just need the host/servername, port, db, db username, db password

The page also defines the parms for the connection URL as well as a link to use thr mariadb jdbc driver .jar.

Youll need to ensure your java is the correct version the .jar file uses.

Youll need to ensure the java is the same "bit type" as the version of ReadyAPI!/SoapUI you are using (both need to be either 64bit or 32bit/x86)

Once youve ensured your java is correct and youve copied the .jar into the correct directory (im on my phone right now so going on memory i think its /ext/lib.....but double check i know the postgresql driver is installed in the correct directory when the application is installed....so stick the .jar file in that directory).

Cant remember if mariadb already has a default connection setup by default in Preferences >> JDBC when the app is installed. If its not, youll have to setup a new connection string (use the jdbc connection string URL defined in the link i provided).

I find when creating a new db connection from scratch that i find it easier if i create a new connection using JDBC in a generic db interrogation tool. I then replicate that config in ReadyAPI!/SoapUI.

Ok. Thats it....i think ive covered off everything you need.

You might be able to query the database via REST instead of JDBC, if the JDBC option doesnt work, come back and we can discuss connecting via REST instead of JDBC.

Ta

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta

View solution in original post

6 REPLIES 6
Highlighted
Community Hero

Hey @sprice090161,

Ive done a bit of reading and amazom suggest using mariadb JDBC driver.

If you have a look at the following link, this defines how to createa new db connection in any generic db interrogation tool. Use this approach to create your aurora connection in ReadyAPI!/SoapUI.

https://aws.amazon.com/blogs/database/using-the-mariadb-jdbc-driver-with-amazon-aurora-with-mysql-co...

The page indicates you just need the host/servername, port, db, db username, db password

The page also defines the parms for the connection URL as well as a link to use thr mariadb jdbc driver .jar.

Youll need to ensure your java is the correct version the .jar file uses.

Youll need to ensure the java is the same "bit type" as the version of ReadyAPI!/SoapUI you are using (both need to be either 64bit or 32bit/x86)

Once youve ensured your java is correct and youve copied the .jar into the correct directory (im on my phone right now so going on memory i think its /ext/lib.....but double check i know the postgresql driver is installed in the correct directory when the application is installed....so stick the .jar file in that directory).

Cant remember if mariadb already has a default connection setup by default in Preferences >> JDBC when the app is installed. If its not, youll have to setup a new connection string (use the jdbc connection string URL defined in the link i provided).

I find when creating a new db connection from scratch that i find it easier if i create a new connection using JDBC in a generic db interrogation tool. I then replicate that config in ReadyAPI!/SoapUI.

Ok. Thats it....i think ive covered off everything you need.

You might be able to query the database via REST instead of JDBC, if the JDBC option doesnt work, come back and we can discuss connecting via REST instead of JDBC.

Ta

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta

View solution in original post

Highlighted
Contributor

Nice! Thank you Rich. I'll report back 😉

I know that my devs are connecting directly from MySQL Workbench, so I'll bet either driver will work.

Highlighted
Community Manager

Awesome explanation Richie, thank you!

 

Hi @sprice090161 ! Please let us know if you had a chance to try this advice and whether it helped🙂


Sonya Mihaljova
Community and Education Specialist

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
Highlighted
Contributor

Will do...
Highlighted
Community Manager

Hi @sprice090161 ! Just checking in to see whether you solved this one or require more advice.


Sonya Mihaljova
Community and Education Specialist

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
Highlighted
Community Manager

@sprice090161 I see you replied straight to the automatic notification. This reply won't reach the forums. Please try replying in the Community directly, thank you🙂

 

I'll mark a temporary solution in this thread, meanwhile, whenever you have updates, feel free to post them here.


Sonya Mihaljova
Community and Education Specialist

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
New Here?
Join us and watch the welcome video:
Announcements
TechCorner Leaderboard
Want a fun and easy way to learn ReadyAPI and show off your skills? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Get a full Raw JMS request

Participate!

Compare an expected JSON value and actual response in Events

Participate!

Fetch value/data from JSON response using Groovy Script

See replies!

Get data from Petstore and add it to Excel sheets

Participate!
Top Kudoed Authors