Explore, Analyze & Document your Code
Visual Expert Documentation
No result
Visual Expert Key Features
Code Documentation
Document the code
- Source Code Documentation
- Schedule Documentation Generation
- Code Metrics – Inventory of Code
- View Comments for Oracle Tables & Columns
- Filter Tables by Type
- DW Datasources (Retrieve SQL, Updated Table, etc.)
- DataWindow - Retrieve Arg, Compute Field, Controls
- PowerBuilder NVOs declared as instance variables
Review & Improve your code
Configure Code Inspection
Names and Comments
Performance Tuning for PowerBuilder and Database
Set up VE Performance Analysis
- Setup for PowerBuilder Code
- Setup for Oracle (Direct Access to the DB)
- Setup for Oracle (No Access to the DB)
- Setup for SQL Server (Direct Access to the DB)
- Setup for SQL Server (No Access to the DB)
PowerBuilder Performance Tuning
Database Performance Tuning
- Largest Tables by Row Count
- Largest Tables by Volume of Data
- Table Information (Size & Row Count)
- Most Frequently Executed Objects at Runtime
- Most Referenced Objects by Code
- Identify Slow Database Objects
- Get a Query Execution Plan (SQL Server)
- Get a Query Execution Plan (Oracle)
- Optimize a DB Slow Object
- Optimize a Business Process
- Optimize Slow SQL Queries
Competitive Analysis
Other Features
Setup your Environment
Install & Configure
- System Requirements
- Getting Started - Standalone Configuration
- Getting Started - Client/Server Configuration
- Install SQL Server Developer Edition
- Fix Performance Issue with SQL Server 2019
- Create a new Repository
- Connect to an existing Repository
- Edit Repository Connection
- Set Encrypt and TrustServerCertificate Flag
- Share the Connection to your Repository
- Request a product key
- Switch from LocalDB to SQL Server Edition
- Activate Automatic Updates
- Run VE in Command Line
- Switch VE to 32 or 64 bits mode
- General Settings (Exports, Paging, Errors, Folders..)
- Integration with PowerBuilder IDE
- Select where temporary files are stored
Analyze your code
- Analyze Oracle Code
- Analyze SQL Server T-SQL code
- Analyze a Single PB Application
- Analyze a PowerBuilder Application with PBG Files
- Analyze Several PB Applications
- Analyze PB + Oracle code
- Analyze PB + SQL Server code
- Analyze Several SQL Server Databases
- Analyze a Database hosted in Azure
- Connect to Oracle Cloud
- Connect to Oracle DB using ODBC & DSN
- Connect to SQL Server using ODBC & DSN
- Connect to GIT, TFS, SVN
- Include/Exclude DB Objects by Name
- Define Cross-App dependencies
- Advanced Options for Oracle Code Parsing
Optimize your Analysis
- Remove Duplicate Tables
- Select a DB Code Parser
- Set Encoding (Ascii, UTF8…)
- Support Japanese Characters in your Code
- Set MessageBox Exceptions
- Set DataObject Exceptions
- Manage Code Analyses
- Verify a Code Analysis
- Search & Filter Previous Code Analyses
- Schedule your Code Analysis
- Virtual Items vs. Real Items