About Visible Analyst

Graphical planning, analysis, and design tool that enables enterprises to build complex client/server applications and databases.

Visible Analyst provides strategic planning, data modeling, business process modeling (BPMN), UML modeling, structured analysis and design modeling in a single tool. Visible Analyst stores and documents data, processes, business requirements and objects that can be shared by developers throughout an organization. Easily design and control enterprise software for quality, consistency and reusability in business applications through the managed sharing of meta-data.

Combines Data, Process and Object Modeling
Visible Analyst is an integrated application development tool that supports all of the most widely used analysis and design techniques:

  • UML: class, use case, sequence, collaboration, and action diagrams
  • Data Models: supports conceptual, logical and physical database design; use any of the popular diagramming notations
  • Process Models: decomposition charts, structure charts, and data flow diagrams

Extensible Repository
A flexible repository is included with Visible Analyst you do not need to purchase a separate repository product. You can add new attributes, objects, and relationships to the Visible Analyst repository. You can also extend the definition of standard repository objects giving you the power to define your own corporate meta data. For example, you can:

  • Define new objects to capture business requirements
  • Relate requirements to other repository objects (tables, fields, process, etc.)
  • Add attribute to identify owner
  • Use Analyst's built-in matrix reporting tool to track requirements against other object

Reverse Engineer Legacy Databases
Visible Analyst offers a complete, robust reverse-engineering process from these sources:

  • Directly from legacy database using native DBMS or ODBC connection to legacy database. A wide variety of DBMS products are supported (Oracle, SQL Server, DB2, Informix, Sybase, etc.)
  • SQL DDL script
  • COBOL data division (when combined with Analyst's COBOL reverse engineering utility)
  • ERWin file import/export
  • Tables, views, relationships, domains (user defined types), stored procedures, constraints, triggers, and table space information are extracted from the legacy database and imported. Analyst will infer the foreign keys to find relationships not expressly defined in the database. Analyst also infers subtype and supertype relationships.

Generate DDL Scripts for Schemas, Tables, Views, RI Triggers, Stored Procedures, Table Space
Visible Analyst generates scripts or DDL schemas in many development environments, languages, and DBMS's. You can save generated scripts as a file or execute immediately using database connection. You can easily customize generation by modifying templates.

  • SQL DDL (Oracle, SQL Server, DB/2, Informix, Ingres, Sybase, and many others)
  • AS/400 DDS
  • Native Progress data descriptions
  • Generate referential integrity to enforce the data definition rules defined in the data model.
  • XML

Collaborative Team Development Environment
Visible Analyst's repository provides team development capabilities that file-based tools cannot offer. Authorized users can access the repository at any time to manually add, modify, or delete objects or review entries and relationships. The repository supports concurrent user access, simultaneous update, and file/record locking.

  • Multi-level security structure: three levels of security user account (3 types), project, object level
  • Multiple developers can work on same element of the design at the same time
  • Eliminates conflicts - only one user makes changes
  • Enterprise copy - make a subset of your model and distribute work across team
  • Keep multiple versions of a model
  • Synchronize changes among versions
  • Projects linked in parent-child relationships - segment work - distribute - then later consolidate

Ensures Model Consistency, Integrity and Quality
Visible Analyst offers advanced, value-added features that makes it more than a diagramming tool. Customizable analysis routines detect missing or conflicting information. A single, tightly integrated repository stores model elements once and allows them to be reused in multiple diagrams and projects. Consistency and integrity is increased because a single change to a shared element is immediately reflected everywhere it is used.

  • Built-in consistency checks include: key analysis, normalization analysis, and balancing checks between model types
  • Enforces rules of modeling technique
  • Automatically migrates foreign keys
  • Share data elements between different models - for example, data element used in a process model reused in ERD and UML

Comprehensive Reporting
Visible Analyst can publish web reports and model diagrams for sharing across the internet with HTML and JPEG (Internet browser native files). The report is user - customizable, and the customized report may be saved for later reuse. You can make queries and reports on projects combining the information in many different ways.

  • HTML Reports
  • Presentation-Quality
  • Standard reports: Matrix, business rules, detail and summary of meta data definitions
  • Save diagrams as JPEG, WMF, or clipboard files

Multi-Level Design
Visible Analyst supports data modeling at three levels: conceptual modeling, logical data modeling, and physical database design.

  • Automatic summarization of logical to conceptual
  • Model denormalization to improve performance
  • Create model subsets and merge all views into one corporate model
  • Denormalization rules
  • Domains, aliases, independent data elements

Generate Business Applications From Your Data Model - Automatically
Visible Analyst takes you further toward your end goal - robust, well-documented, modular, 3-tier business applications. Data models are transferred to Visible Developer where business objects are designed from tables, fields, and relationships. Complete the application design by defining properties, methods, rules, views, look-up tables, and other design-time objects. Select a code pattern to generate any of the following:

  • 3-tier Visual Basic business object
  • Visual Basic forms user interface
  • ASP web interface
  • SQL Server or Oracle stored procedures
  • C++/Java outline class definitions

Features for Power Users
IntelliViews technology allows you to develop database view specifications as you are data modeling, tracking name changes to every location and formula in which they are used, eliminating errors. View specifications are automatically adjusted to the specific DBMS dialect, allowing one set of views to be created and used without having to worry about specific SQL syntax and restrictions.

  • Visible Analyst can build different model subsets and merge all views into one corporate model integrating the sub-models to finalize your bottom-up design.
  • Visible Analyst can separate the logical and physical views of data models by creating denormalization rules on relationships which are used to generate the SQL DDL schemas.
  • Foreign keys can be related to any unique field - not just the primary key
  • Link external documents directly to meta-data definitions using hyperlinks. Documents, spreadsheets, URLs, and graphics can be used.
  • Clusters can be used on data model models to limit the amount of detail shown. Great for high-level presentations where you want to focus on certain areas of a model.
  • Multi-level data structures can be defined and referenced throughout your models.
  • Easy convert object models to data models. Allows you to build your application in an OO architecture, but deploy on a relational database.