Forum Discussion

kiranaj17's avatar
kiranaj17
New Contributor
6 years ago

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
kiranaj17's avatar
kiranaj17
New Contributor
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's avatar
HimanshuTayal
Community Hero
6 years ago

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's avatar
    Olga_T
    SmartBear Alumni (Retired)
    6 years ago

    Hi all,

     

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

     

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

    We are looking forward to hearing from you.