Document your PowerBuilder, Oracle, and SQL Server Code

Visual Expert automatically documents your code.

Get comprehensive, up-to-date documentation detailing every object and its dependencies throughout your application.

New in VE Web: On-demand documentation
Dynamically generate contextual documentation by selecting specific objects. Share instantly with your team via URL.

Use these documents as reference manuals for code maintenance, review purposes, and knowledge transfer.

Generate CRUD matrices showing which programs access your data. For instance, which DW or Procedures Create/Read/Update/Delete which Tables.

NEW in VE Web: Interactive CRUD matrix -
Navigate directly from high-level dependencies to low-level source code details in real-time.

Benefits:

• Review dependencies between database and PB applications
• Analyze the impact of changing your database schema
• Estimate software complexity and development efforts
• Find tables that are never updated, deleted from multiple places, etc.
• Ensure every process has at least one input (R) and one output (CUD)

Object Dependency Matrix extends the concept of "Impact Analysis" to multiple objects, visualizing cross-references between Oracle, SQL Server and PowerBuilder code in a 2D matrix.

NEW in VE Web: Interactive dependency matrix
Understand relationships, predict the impact of changes, and debug faster with direct drill-down to source code.

These matrices help teams understand and maintain large, complex applications with multiple interdependencies. Highlight, comment, and share specific references with your team.

Visual Expert generates diagrams from your code to let you visualize and understand complex code.

Visual Expert can generate

• Data Model Diagram
  Document graphically database entities and their relationships.
• Impact Analysis Diagram
  Find all references to a table, column, object, method, variable...
• Call Graph
  Visualize chains of calls (multiple levels of references).
• PBL Dependency
  Visualize dependencies between PBLs

Estimate the volume of your code under various angles for auditing purposes or workload assessment.

After analyzing your code, VE can calculate the number of:

• Lines of code in your project, separating comments from instructions
• PB objects, by type (how many DW, Window, UO...)
• PB controls, by type (DW control, tab, text...) PB events, functions, variables, attributes, parameters...
• Database objects called from PB (Procedures, tables, etc.)

You can also list the Web services and dll functions called by your PB code.