Run Tests

Studio enables you to test your product completely before it is packaged to verify that the project contains no errors. Through Studio you can perform either of the following tests:

  • Compare and Refresh Source Tables: Check for schema differences between  your source ERP or flat file and the source tables in your project.
  • Project Integrity Test: Verify that your project is valid and ready to be packaged.

Compare and Refresh Source Tables

When ERPs have updates or patches installed, their schema may change. Running the compare and refresh source tables test enables you to ensure that the schema structure in the connected ERP or flat file and in your project are in sync. If the schema in the ERP or flat file has changed, you are given the option to overwrite the tables in Sources .

Select the required option and click Refresh. Studio will begin validating each table in your project against the schema from the ERP or flat file. When the validation is done, you will see a message stating that the source table is in sync with the source. If the schema has changed, a table will display the old and new values. Click Update Source Table to update the tables in your project.

Project Integrity Test

Before packaging your project, it is mandatory that you perform a project integrity test on the entire project. From the Tools menu, select Run Tests > Project Integrity Tests. The Quick Select and Tests tabs in this window enable you to define the scope of your testing.

  • The Quick Select tab groups the tests into categories such as Sources Tests, Destinations Tests and so on. Select a category and click Execute Tests to run all the tests in that category or select  All Tests.
  • To select only specific tests to run, select a category-for example, Destinations Tests, on the Quick Select tab and then select or clear the check boxes next to the required tests.
  • Click Execute Tests. The Results tab displays the results of the test. You can download the results.