Read Excel using JDBC Request Test Step

[kiranaj17]

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

[HimanshuTayal]

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

[kiranaj17]

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.

[HimanshuTayal]

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

[Olga_T]

Hi all,

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

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

We are looking forward to hearing from you.