Forum Discussion

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

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

 

 

 

  • kiranaj17's avatar
    kiranaj17
    New Contributor
    7 years ago
    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
      7 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)
        7 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.