Ispirer InsightWays: User Guide

On the Welcome page you should specify the project directory where sqlways.log file with the log of the assessment process and reports will be saved. By default the project directory is C:\Users[user_name]\Documents\Ispirer\Ispirer InsightWays 10.

If you want to change the project directory, make sure that you have access to it or restart the tool with the right click and choose “Run as Administartor”. In other cases we can't guarantee that the reports will be saved properly.

At this stage, you can choose whether you want to analyze database objects or scripts using the InsightWays tool.

If you choose the “Database” option, you need to select the ODBC connection to the source database you wish to assess and specify the user and password that will be used to connect to it.

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. For more information about source database user privileges, see the appropriate section for your source database.

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 specify information about your target database. This step is the same for analyzing both database objects and scripts.

On this page you can specify:

• “Target” – name of the destination 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: C:\Users\[User Name]\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.

The tool automatically generates comprehensive assessment reports that provide an in-depth overview of the project scope. These reports assist in evaluating the project details and help both you and our team select the optimal migration plan to ensure an exceptional outcome. Some screenshots of the generated reports are presented below for your reference.

Summary information
Here is the general information about key insights, including:

• Automation level;
• Project complexity;
• Manual corrections;
• Customization suggestions.

Object complexity information
This section of the report provides detailed insights into the complexity of the objects involved in the migration.

Construction information
This section outlines the structural elements and configurations within the selected scope of the project.

Object type information
This section provides detailed insights into the different types of objects within the project.

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