Data-driven testing often requires testing across multiple databases on different technologies. The ability to add various databases to test scenarios is crucial for data verification and reconciliation. Within SentryOne LegiTest, it’s easy to add a database connection to your test suite for use in your data-driven testing.
Database connections can be defined in several ways:
LegiTest supports ADO.NET providers, as well as ODBC and OLE DB, allowing you to connect to virtually any database in an easy-to-use platform.
Step 1: Open a LegiTest project and take a look at your toolbox, which will show the available assets you can create. If you do not see the toolbox, click the link on the right side of your page. The link may be in a different location on your system.
Step 2: Double-click the first option (ADO.NET Connection) in the toolbox to create an ADO.NET connection.
Step 3: Click the ADO.NET asset and choose a database provider appropriate for the database you’re connecting to. The provider can be selected using the ‘Provider’ drop-down on the left-hand side. For this example, we will use the SqlClient Data Provider.
Step 4: Click the ‘Configure’ button.
Step 5: Choose a server to connect to, how to log on to the server, and a database to connect to. For this example, we will use our local server using Windows Authentication and connect to the HigherEd database. Click ‘OK.’
Step 6: Click ‘Test Connection’ to validate it is successful.
Step 7: You can rename your asset by selecting it and hitting F2 on your keyboard.