Ask a Question

Read Excel using JDBC Request Test Step

kiranaj17
New Contributor

Read Excel using JDBC Request Test Step

Can you please let me know how i can use the database connections i.e jdbc for reading the excel data as a sql query

4 REPLIES 4
HimanshuTayal
Community Hero

If you want to read excel data then use DataSource Step instead of  DataBase Step.

 

 

 


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" πŸ™‚ ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal

Yes I know we can use the Data Source but since we have limited licences we are using soapui open source and trying to use JDBC connection for reading excel as a SQL query.

you can use groovy script to read excel file if you are working with SoapUI that is  free version.

 

Go through below post to have a look on how to read it via groovy

 

SoapUI-Open-Source read excel via groovy

 


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" πŸ™‚ ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal
Olga_T
SmartBear Alumni (Retired)

Hi all,

 

Himanshu, thank you for your suggestions and for the link provided Cat Happy

 

@kiranaj17, do you have any updates for us? Was your question answered?

We are looking forward to hearing from you.

 

 


Olga Terentieva
SmartBear Assistant Community Manager

cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β