Code Inspection Dashboard
Get high level indicators to decide if a build can be pushed into production
Explore, Analyze & Document your Code
Continuous Code Inspection
Integrate code inspection in a CI/CD workflow.
Leverage 300+ rules to improve
Code
Security, Performance and Quality
Download Visual Expert
Why Inspect PowerBuilder Code in a CI/CD Workflow
Continuous code inspection allows a complete review of the code each time a build is generated.
It is necessary to determine if a build does not contain any security holes or bugs before it is pushed into production.
Scan your code for Security Vulnerabilities, Bugs, and Maintainability Issues
Visual Expert implements 300+ rules, to check your code under various angles and improve its security, stability, and maintainability.
- Detect and remove security vulnerabilities
- Comply with coding "grammar" standards
- Comply with code readability standards
- Architectural layering adherence
- Remove code duplicates
- Improve performance
- And more...
Include code inspection in continuous integration
Visual Expert can inspect code from various sources:
- Files located somewhere in your network
- Source controls like GIT, SVN or TFS
- Database, for Oracle PL/SQL and SQL Server Transact-SQL code
Many options are available to run a code inspection. For instance:
- Manually, from the Visual Expert UI, anytime you need.
- Automatically, on a scheduled basis
- With Jenkins, anytime a build is released
- From another tool running Visual Expert by Command line
Impact Analysis
Assess the impact of a change in your code
Estimate what you should modify to accomplish a change.
Don't break your application after a change!
- If I change this variable, what is the effect on my code?
- If I add a parameter to a function, what else is affected?
- If a table or column is changed, which code should I update?
Scan for Security Vulnerabilities
Identify and fix Security issues in your code:
- Hard coded user id & passwords
- Hard coded IP addresses.
- Vulnerabilities to Injections attacks
- Fields access/protection issues
- Improper/unsecured use of encryption
- and more...
Review CRUD Operations in Your code
(Create, Read, Update, Delete)
Generate a CRUD matrix showing which programs access your data.
For instance, which DW or Procedures Create/Read/Update/Delete which Tables.
- Review dependencies between database and PB applications.
- Analyze the impact of changing your database Schema, for example changing a table definition or adding an index.
- Estimate software complexity and development efforts.
- Find out which table is never updated, deleted from multiple places, etc.
- Make sure every process has at least one input (R) and one output (CUD).
Generate Diagrams from your Code
- Visualize objects and dependencies.
- Diagrams and source code are synchronized.
- Select objects to generate a diagram
Visual Expert generates:
- Data Model Diagram to document graphically database entities and their relationships.
- Impact Analysis Diagrams to find all references to a table, column, object, method, variable...
- Call graphs to visualize chains of calls (multiple levels of references).
- PBL dependency diagrams to visualize dependencies between PBLs
Document your Code
Create reference manuals in HTML
Update your documentation on a regular basis (scheduled job).
Document the references in your code and navigate between these using hyperlinks.
Share knowledge with teammates.
Improve Code Quality
Cleanup the code. Streamline maintenance efforts. Avoid unexpected behavior.
- Identify unused objects and remove some dead code.
- Find empty methods, duplicated objects, oversized or uncommented scripts.
- Calculate code metrics: lines of code, number of objects, methods, variables…
- Check naming conventions.
- Find objects that do not inherit from an ancestor etc.
- You can check your code against hundreds of rules
Improve Code Performance
Find slow pieces of code. Remove Bottlenecks
- Find the slowest procedures, functions, triggers
- Reduce the time to access a given table
- Break down the execution time of a large object into sub-queries or instructions.
- Decompose the performance of a chain of calls
Code Comparison
Compare 2 versions of your DB or application:
- View differences in a container hierarchy.
- Drill down to find relevant changes.
- Filter changes for a given object, or object type: Userobject, Table, Procedure...
- Filter changes in a given PBL.
- Save “snapshots” of your code on a regular basis, and compare them anytime.
- And more...
Understand Complex Code
Explore the application structure. Understand its inner working.
When maintaining complex Applications, you may need to learn more about the code.
In such cases, Visual Expert is the perfect companion for PowerBuilder.
Navigate in your code via hyperlinks: each reference comes with a link to the referenced item.
Tooltips provide useful information about objects, methods and variables.
Explore inheritance dependencies between PB objects.
Lots of advanced feature will screen your code under various angles.
Advanced String Search
Visual Expert Global Search addresses common shortcomings:
String searches often return lots of results. They are usually tedious and unproductive.
- Use multiple criteria to reduce the search result.
- Restrict search to one or several object types.
- Search for exact words, or words starting/ending with, matching regular expressions…
- Search into several PB targets at the same time.
- Review results in a container hierarchy.
- The strings found are highlighted in the code.
- Filter relevant result items.
- Share the outcome with colleagues.
Catch a glimpse of Visual Expert
How it works?
Visual Expert Pricing & Editions
-
-
Basic
For individual developers with small projects
$625 /user
/year500 000 Lines of Code- Installation on a Client PC
- Cross-References / Impact Analysis
- Code Inspection
- Performance Tuning
- Code Documentation
- Updates
-
Basic
For individual developers with small projects
$1,395/user
500 000 Lines of Code- Installation on a Client PC
- Cross-References / Impact Analysis
- Code Inspection
- Performance Tuning
- Code Documentation
- Mandatory for the 1st year
- Updates - $279
-
-
-
Professional
For teams managing large codebases and requiring collaboration tools
$1,255 /user
/year5 million Lines of Code- All Basic Features, plus:
- Client/server configuration
- Web Client available
- Collaborative Features
- Integration with DevOps Platforms
- Code Comparison
- Code Analysis Scheduler & History
- Updates
Need more than 5 million Lines of Code?
Get Volume Discount- Mandatory for the 1st year
- Premium Support - $1,885
-
Professional
For teams managing large codebases and requiring collaboration tools
$2,850 /user
5 million Lines of Code- All Basic Features, plus:
- Client/server configuration
- Web Client available
- Collaborative Features
- Integration with DevOps Platforms
- Code Comparison
- Code Analysis Scheduler & History
Need more than 5 million Lines of Code?
Get Volume Discount- Mandatory for the 1st year
- Updates - $570
- Premium Support - $1,885
-
-
-
ENTERPRISE AI
For teams managing large codebases and requiring AI-powered features
$1,875 /user
/year5 million Lines of Code- All Professional plus AI Features :
- 10,000 AI Credits per user
- (AI) Explain the Business
- (AI) Explain the Logic
- (AI) Add comments in the code
- (AI) Fix a problem
- (AI) Optimize SQL & Code
- Updates
Need more than 5 million Lines of Code?
Get Volume Discount- Mandatory for the 1st year
- Premium Support - $1,885
-
ENTERPRISE AI
For teams managing large codebases and requiring AI-powered features
$3,470 /user5 million Lines of Code- All Professional plus AI Features :
- 10,000 AI Credits
- (AI) Explain the Business
- (AI) Explain the Logic
- (AI) Add comments in the code
- (AI) Fix a problem
- (AI) Optimize SQL & Code
Need more than 5 million Lines of Code?
Get Volume Discount- Mandatory for the 1st year
- Updates - $694
- Premium Support - $1,885
-
Feedback from our clients
Reduces expenses
Using VE's features allows a much quicker turnaround, reduces expenses and frees up resources for more productive work.
- Project Manager
New York State Department of
Environmental Conservation
Become familiar with a new application in literally a few hours
(The) More you work with Visual Expert - more you understand how convenient it is. (...) I cannot remember so powerful a tool that allows a user to become familiar with a new application in literally a few hours
- Georges Mikhailovsky
Calibre Systems
