Explore, Analyze & Document your Code
Visual Expert Documentation
No result
Visual Expert Key Features
Cross References
- Deep Impact Analysis
- Call Graphs
- Reverse Call Graphs
- CRUD Matrix - VE Desktop
- Interactive CRUD Matrix - VE Web
- Object Dependencies Matrix - VE Desktop
- Object Dependencies in VE Web
- PB Calls to Dll functions
- PB Calls to Web Services
- PB Calls to Stored Procedures
- View Dependencies between PBLs
- Calls to table/Col. by Select/Insert/Update/Delete
- Datawindows Updatable Columns
- Code Explorer - TreeView Object Functionalities
- Code Explorer - Navigate Source Code
Code Documentation
Document the code
- Source Code Documentation
- Online Code Documentation - VE Web
- 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
- Identify the Missing Index
Competitive Analysis
Other Features
Setup your Environment
Install & Configure
- System Requirements
- Getting Started - Standalone Configuration
- Getting Started - Client/Server Configuration
- Migrate to a Major Version of Visual Expert
- Install SQL Server Developer Edition
- Fix Performance Issue with SQL Server 2019
- Create a new Repository
- Connect to an existing Repository
- Edit Repository Connection
- Add Multiple Users with Local DB on Single Machine
- 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
- Run SQL Server Local Instance Using Command Line
- General Settings (Exports, Paging, Errors, Folders..)
- Integration with PowerBuilder IDE
- Select where temporary files are stored
- Supported Versions for Oracle, MS SQL Server, PowerBuilder
Visual Expert Web
- Visual Expert Web: New & Innovative Features
- Visual Expert Web Installation Guide
- Code Documentation in Visual Expert Web
- Code Explorer TreeView - Visual Expert Web
- Navigating Source Code - Visual Expert Web
- Interactive CRUD Matrix - Visual Expert Web
- Object Dependencies - Visual Expert Web
- Advanced & Quick Search Feature in VE Web
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
- Managing VE LOC Limits
- 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