Documenting SQL Table Access

Visualize How Your Applications Access Data

LegacyMap gives you instant visibility into how your legacy applications interact with relational databases. Our tool automatically extracts, categorizes, and visualizes every instance of database access across your codebase of COBOL, FORTRAN, or other languages that use embedded SQL code blocks.

This module identifies SELECT, INSERT, UPDATE, and DELETE operations and maps them to the programs, procedures, and modules that use them. All access points are organized by database and table, providing a complete picture of your application's data flow—without manual review or instrumentation.

The tool also processes the schemas for SQL databases and processes the information to be loaded into Doxygen so your SQL-based applications are completely documented in Doxygen. You can select a table and get a list of all the modules that access it by access type. Conversely, you can examine a module and see the callgraph with all the tables that it can access and the type of access, color coded by database.

Database Access Mapping Made Easy

• Full SQL Operation Detection – Capture every SELECT, INSERT, UPDATE, and DELETE statement from embedded SQL blocks in COBOL, Pro*COBOL, and other supported languages.

• Database-Aware Visualization – Automatically link SQL operations to specific databases (Oracle, Postgres, or Rdb) and color-code them for easy identification in visual callgraphs.

• Table-Level Callgraph Generation – Generate interactive flowcharts showing which modules access each table and how—grouped by operation type.

• Structured Output for Review – Export documentation in HTML, PDF, and LaTeX, complete with diagrams, access summaries, and reference links.

Why Database Mapping Matters

• Improve Audit Readiness – Clearly show where and how sensitive data is accessed across your legacy systems.

• Simplify Refactoring – Understand how data flows through your applications to safely restructure or optimize code.

• Enable Modernization Planning – Identify SQL hotspots, critical tables, and tightly coupled logic before migrating to a new database or architecture.

• Boost Developer Confidence – Give developers the tools they need to navigate legacy data access safely and efficiently.

LegacyMap makes SQL visibility effortless. Track every query, every table, and every access point—automatically and accurately.