SQL DB Validator description
SQL DB Validator is a powerful tool which tests the content of a database extract against its original data store
SQL DB Validator is a powerful tool which tests the content of a database extract against its original data store using the specific SQL syntax for each of the data sources:
· MS-SQL
· mySQL
· DB2
· Oracle
· Teradata
· MS-Access
· Excel
· and others
Access to all of these databases is obtained using OLEDB and ODBC drivers.
Tests can be contained in a single file and each test can be configured to connect
to different data sources. This allows the user to:
Compare the content of a Excel report populated from a cube, against the original content in the database.
Using MDX, compare the cube content directly with the original database.
Here are some key features of "SQL DB Validator":
· Tests can compare data content, date content, or row counts.
· Concurrent test execution ensures tests will run in the shortest possible time. They may also be run sequentially.
· A command line interface allows for integration of the software testing tool with any current test automation system.
· A customizable Syntax Highlighting Editor, which aids in query design, is integrated into the tool.
Limitations:
· 15 days trial