Visual Expert

• Cross-references exploration: Impact Analysis, E/R diagrams, call graphs, CRUD matrix, dependency graphs.
• Software documentation: a documentation generator produces technical documentation and low-level design descriptions.
• Inspect the code to detect bugs, security vulnerabilities and maintainability issues. Native integration with Jenkins.{{Cite web|date=2021-09-21|title=Visual Expert Jenkins Plugin|url=https://www.jenkins.io/doc/pipeline/steps/visualexpert/|website=Jenkins.io}}
• Reports on duplicate code, unused objects and methods and naming conventions. Calculates software metrics and source lines of code.
• Code comparison: finds differences between several versions of the same code.
• Performance analysis: identifies code parts that slow down the application because of their syntax - it extracts statistics about code execution from the database and combines it with the static analysis of the code.

Visual Expert is used in several contexts:

• Change impact analysis: evaluating the consequences of a change in the code or in a database. Avoiding negative side effects when evolving a system.
• Static Application Security Testing (SAST): detecting and removing security issues.
• Continuous Integration / Continuous Inspection : adding a static code analysis job in a CI/CD workflow to automatically verify the quality and security of a new build when it is released.
• Program comprehension: helping programmers understand and maintain existing code, or modernize legacy systems. Transferring knowledge of the code, from one programmer to another.
• Software sizing: calculating the size of an application, or a piece of code, in order to estimate development efforts.
• Code review: improving the code by finding and removing code smells, dead code, code causing poor performances or violations of coding conventions.

• As a static code analyzer, Visual Expert is limited to the programming languages supported by its code parsers - Oracle PL/SQL, SQL Server Transact-SQL, PowerBuilder.
• A preliminary reverse engineering is required. Visual Expert does it automatically, but its duration depends on the size of the code parsed. Users must wait for the parsing completion prior to using the features, or schedule it in advance. They must also allocate sufficient hardware resources to support their volume of code.
• Visual Expert is based on a client/server architecture: the code analysis is running on a Windows PC - preferably a server. The information extracted from the code is stored in a RDBMS, communicating with a client application installed on the programmer's computer - no web client is available. This requires that the code, the parsers, the RDBMS and the programmers’ computers are connected to the same LAN or VPN.

• 1995- 1998 - Prog and Doc - Initial version distributed on the French market {{Cite web|url=http://www.eurelys.com:80/fr/prog&doc.htm|title=Prog & Doc (french page from Web Archive)|date=7 July 1997|website=Eurelys|archive-url=https://web.archive.org/web/19970707152457/http://www.eurelys.com/fr/prog%26doc.htm|archive-date=1997-07-07|url-status=dead}}
• 2001 - Visual Expert 4.5
• 2003 - Visual Expert 5{{Cite web|date=2004-06-16|title=Mise à jour de Visual Expert - version 5.0|url=https://www.programmez.com/actualites/mise-jour-de-visual-expert-version-50-14566|website=Programmez!}}
• 2007 - Visual Expert 5.7{{Cite web|url=http://chrispollach.sys-con.com/node/365638|title=Visual expert 5.7 released|last=Pollach|first=Chris|date=April 23, 2007|archive-url=https://web.archive.org/web/20140726045932/http://chrispollach.sys-con.com/node/365638|archive-date=2014-07-26|url-status=dead}}
• 2010 - Visual Expert 6.0{{Cite web|url=http://www.dbta.com/Editorial/News-Flashes/Novalys-Introduces-Visual-Expert-60-54481.aspx|title=Novalys introduces Visual Expert 6.0|last=|first=|date=23 April 2009|website=DBTA|access-date=}}
• 2015 - Visual Expert 2015 - Server component added to schedule code analyses{{Cite web|date=2015-05-10|title=Introduction to Visual Expert 2015|url=http://powerbuilder-world-tour.com/download/NCPBUG-Conference-May-2015-visual-expert.pdf|website=Charlotte PowerBuilder Conference}}{{Cite web|date=2015-05-15|title=Visual Expert Team System|url=https://www.visual-expert.com/EN/visual-expert-documentation/install-and-configure-visual-expert/collaborative-coding.html|website=Visual Expert}}
• 2016 - Visual Expert 2016 - Oracle PL/SQL code parser, code inventory (lines of code, number of objects…){{Cite web|date=2021-09-21|title=Visual Expert Release History|url=http://www.visual-expert.com/EN/support-question-example-powerbuilder-pl-sql-tsql-stored-procedure/update-list-pb-plsql-t-sql-source_wpve.html|website=Visual Expert}}
• 2017 - Visual Expert 2017 - SQL Server T-SQL code parser, Code comparison, CRUD matrix{{Cite web|date=2017-10-01|title=Visual Expert for SQL Server|url=https://dbmstools.com/tools/visual-expert-for-sql-server|website=DBMC tools}}
• 2018 - Visual Expert 2018 - DB Code Performance Analysis, integration with TFS
• 2019 - Visual Expert 2019 - Generation of E/R diagrams from the code
• 2020 - Visual Expert 2020 - Object dependency matrix, naming consistency verification, integration with GIT and SVN
• 2021 - Visual Expert 2021 - Continuous Code Inspection,{{Cite web|last=Dufourmantelle|first=Christophe|date=2020-11-17|title=Improve the Security and Quality of Your Code|url=https://www.youtube.com/watch?v=D4Q47Hbrb3g|website=Youtube}} integration with Jenkins

{{Reflist}}

• [http://www.visual-expert.com/EN/stored-procedure-pl-sql-oracle-plsql/code-function-analysis-impact-source_wpve.html Visual Expert for Oracle]
• [http://www.visual-expert.com/EN/stored-procedure-t-sql-server-mssql-tsql/sqlserver-code-function-impact-analysis-source_wpve.html Visual Expert for SQL Server]
• [http://www.visual-expert.com/EN/powerbuilder-code-pb/function-source-analysis-documentation-impact-source_wpve.html Visual Expert for PowerBuilder]
• [http://www.visual-expert.com/EN/support-question-example-powerbuilder-pl-sql-tsql-stored-procedure/update-list-pb-plsql-t-sql-source_wpve.html Visual Expert Changelog]

Category:Code navigation tools

Category:Desktop database application development tools

Category:Programming tools

Category:Software documentation

Category:Documentation generators

Category:Static program analysis tools

Category:Software review

Category:Microsoft database software

Category:Oracle database tools