Ispirer InsightWays User Guide

On the Welcome page, you should specify the project directory where the sqlways.log file with the log of the assessment process and reports will be saved. By default the project directory is /Documents/Ispirer/Ispirer InsightWays 10/.

If you want to change the project directory, make sure that you have access to it. In other cases, we can't guarantee that the reports will be saved properly.

Next, we need to choose the ODBC connection to the source database that needs to be assessed. Also specify the user and password that will be used to connect to the source database.

NOTE: Our tool only works using an ODBC connection to the source database! This means that before running Ispirer InsightWays, you need to install the ODBC driver and set up the ODBC connection to the database that is to be analyzed by the tool.

NOTE: The user specified on this page must have appropriate rights to select system tables from the source database. For more information about source database user privileges, see the appropriate section for your source database.

Users can now simply select an ODBC driver installed on their machine and provide the necessary database connection details. Our tool will then automatically establish the required connection, eliminating the need for users to configure it manually.

NOTE: This feature is currently supported only for SQL Server and Oracle source databases.

If you choose the “Scripts” option, you need to select the source DBMS and its version.

On the “Target Options” page you need to provide information about your target database. This information will not affect the assessment speed or its assessment effectiveness.

On this page you can specify:

• Target – name of the target database in your project;
• Version – version of the target database.

If you are analyzing database objects, use the arrow buttons or simply drag & drop objects from the left pane to the right. You can move a single object, an entire schema, a specific object type, or your entire database.

If you are analyzing scripts, use the arrow buttons or simply drag & drop files from the left pane to the right.

NOTE: The remaining configuration steps for InsightWays are the same for both database objects and scripts.

Also, here you need to enter the size of the database data manually.

On the “Execution” page you can check how assessment process is being performed. The tool depicts each object while collecting the metrics and provides total statistics at the end of the log. The same information can be found in sqlways.log file in the project directory.

After completing the analysis, users can now view the following information:

• Conversion rate of the analyzed code;
• Potential conversion rate after applying customizations;
• Details about failed objects;
• Measured lines of code;
• Total number of code constructions.

Please send the entire “Reports” folder to our business managers for analysis.

Default project directory: /Documents/Ispirer/Ispirer InsightWays 10/

Alternatively, if sending the entire folder is inconvenient, you can locate the “data.js” file within the “Reports” folder and send us only this file. The “data.js” file contains all the necessary information we need for analysis.

These steps describe how to generate assessment reports for the source database using the InsightWays tool. If you have any additional questions or face any difficulties please contact our support team: support@ispirer.com