Database modeling, metadata and physical data exploration, scripting, synchronization, synthetic data, extraction, anonymization and team collaboration — one coherent, metadata-driven platform.
Xcase is organized around a base platform plus focused modules. This keeps adoption simple: every user starts with Core, and organizations add Evolve, Extract, Anonymize, and Workgroup when their responsibilities expand.
The base platform: metadata exploration, physical relational data exploration and analytics, diagrams, dictionary navigation, scripting, code generation, synthetic data generation, datasets, snapshots, and synchronization from externally supplied model changes.
Explore Core →Adds authority to create and modify model metadata yourself. Evolve is for users who design and change the model, then generate or synchronize from those self-authored changes.
Explore Evolve →Adds relationship-aware extraction from production or reference databases. It is intended for teams preparing compact, coherent non-production databases.
Explore Extract →Adds privacy-oriented anonymization and masking workflows for Dev/Test data. It helps produce safe non-production data while preserving practical usability.
Explore Anonymize →Workgroup is a deployment and administration mode, not just another feature module. It provides published models for sharing knowledge and updates across the team, user permissions, manager controls, and concurrent licensing for Core, Evolve, Extract, and Anonymize capabilities.
Explore Workgroup →Xcase Core is the starting point for every deployment. It gives users a practical environment for understanding database structures, using metadata, and preparing repeatable Dev/Test workflows.
Navigate models, tables, columns, relations, domains, dictionaries, diagrams, dependencies, and user-defined metadata.
Understand live relational structures and database content through Xcase's model-aware perspective.
Compare and synchronize a database from model changes supplied by another authorized model author.
Use the Xcase scripting language to generate database code, reports, diagrams, and automation from metadata.
Generate useful test data as a Core capability, not as a separate add-on module.
Create, refresh, restore, and compare repeatable data states as part of Core.
Core AI assistants: documentation-aware guidance, and natural-language generation of Xcase scripts.
The architecture is deliberately modular. Core serves many users. Evolve, Extract, and Anonymize are added for specialized responsibilities.
For users who author and evolve model metadata.
Design and evolve the model, then synchronize, version and migrate from your own changes.
For relationship-aware data extraction from production or reference databases.
Extract compact, referentially complete subsets of production data.
For privacy-safe Dev/Test data preparation.
Anonymize sensitive data consistently, with plain-SQL output and audit documentation.
Core users can consume, analyze, automate, generate, and synchronize from received model changes. Evolve users can author and modify the model metadata themselves. This distinction keeps Core powerful while preserving the value of metadata authoring authority.
Traditional tools often stop at diagrams and DDL. Xcase turns metadata into an operational foundation for automation, synchronization, Dev/Test data, privacy workflows, and team governance.
| Capability | Traditional modeling tools | Xcase positioning |
|---|---|---|
| Database modeling and ERD visualization | Often available | Part of Xcase Core, with diagrams, dictionary metadata, reverse engineering, and model navigation. |
| Physical relational data exploration | Often outside the modeling environment | Core includes physical relational data exploration and analytics from a model-aware perspective. |
| Model/database synchronization | Usually limited or tightly coupled to authoring | Core can synchronize from received model changes; Evolve adds synchronization from self-authored metadata changes. |
| Scripting and generation | Often weak, closed, or limited | Core includes scripting and metadata-driven generation, with capability-aware controls for metadata write operations. |
| Synthetic data generation | Usually separate tooling | Included in Core as a transversal capability. |
| Datasets and snapshots | Often manual scripts, backups, or separate tools | Included in Core for repeatable Dev/Test data states. |
| Relational extraction | Usually requires a separate TDM product | Available through Xcase Extract for compact relationship-aware subsets. |
| Anonymization | Usually separate masking tooling | Available through Xcase Anonymize, connected to the same metadata context. |
| Team governance | Generic repositories or file sharing | Xcase Workgroup shares knowledge and updates through published models, with user permissions and concurrent licensing. |
| DBMS migration | Re-modeling by hand or third-party converters | Change the target DBMS and Xcase re-maps the data types for the new platform, copies the data, and writes the DDL (Xcase Evolve). |
| AI-assisted scripting | Usually absent or generic | Xcase Script generates Xcase scripts from natural language while keeping execution reviewable and metadata-driven. |
Xcase separates AI features that help users work with explicit metadata from advanced AI capabilities that interpret schema meaning, business processes, or sensitive data categories.
Documentation-aware, context-sensitive assistance for learning and using Xcase. It draws on the documentation portal, manuals, scripting reference, videos, and current UI context.
Natural-language generation of Xcase scripts and templates. The user reviews scripts; Xcase executes them deterministically against explicit metadata.
Will turn business-process descriptions into programmer-ready database objects — views, stored procedures, triggers, validation logic, and documentation.
Will discover implicit relationships using deterministic database signals and probabilistic semantic reasoning.
Explicit metadata plus repeatable generation pattern. Examples: CRUD stored procedure generators, audit trigger templates, documentation generation, diagrams, and model quality reports.
Business intent plus schema interpretation. Examples: updatable multi-table views, instead-of triggers, business-process procedures, relationship discovery, and semantic anonymization setup.
Xcase has a long history with enterprise, public-sector, technology, and data-intensive organizations.
IBM
BASF
Verizon
HSBC
BAE Systems
Northrop Grumman
BT Group
Duke Energy
Esri
Yale UniversityAll product names, logos, and brands are property of their respective owners. Use of these names, logos, and brands does not imply endorsement.
The documentation system includes concise portal pages, downloadable PDF manuals, short operational videos, and a structured knowledge base that powers Xcase Assist.
Start with Xcase Core. Add Evolve, Extract, Anonymize, and Workgroup capabilities when your team needs them.