SQL DB Validator

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