Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

Need to access application database for test data used in Selenic tests

Speedy993
Speedy993 Posts: 71 ✭
in Selenic

I have a simple application that is used as a front end for another department's database. We only have read access and cannot create our own test data. What I would like to do is to make a few database queries to retrieve some key values to use in the subsequent tests. Are there examples of this available?
Thanks!

Tagged:

Comments

  • jakubiak
    jakubiak Posts: 813 admin

    You would need to write Java code to connect to your database using the appropriate JDBC driver for your database, and execute a query to retrieve the desired data. Here is a simple tutorial about how to do that: https://howtodoinjava.com/java/jdbc/jdbc-select-query-example/

  • Speedy993
    Speedy993 Posts: 71 ✭

    Thanks for replying so quickly. The issue we are having is that the way MFA is being implemented involves having to open the Microsoft Authenticator app in our phones and enter the number displayed before navigating to the application logon screen. Is the only way around this is to configure Entra to allow certain userids to bypass the MFA prompt? I am not sure what you mean by accessing the database to retrieve the data. Also, it appears the link is no longer active.

  • jakubiak
    jakubiak Posts: 813 admin

    @Speedy993 I think you added this comment to the wrong thread!

  • Speedy993
    Speedy993 Posts: 71 ✭

    Sorry, yes I did. It has been one of those days. :/

Categories

Tagged