Altova SchemaAgent

Databases aren’t simply storage devices for large quantities of information. These data sets are also linked together, so that the appropriate level and amount of data is provided when requested. In order to view and manage such database relationships you might want to use specialized applications like Altova SchemaAgent.

One of the core features of the application is to analyze schemas, instances, and relationships. On the bright side of things, you don’t necessarily have to connect to a database, given that all your project files are stored and ready for offline use. You can process XML schemas and instances, XSLT files, and WSDL file relationships.

The visual design is well-organized, and the workspace supports multiple windows, so that you can process multiple projects at a time. There’s a side navigation panel showing either hierarchy, flat, or configuration view, but you might first want to take the time to define a new path which leads to your project files.

You don’t necessarily get to analyze the whole project at a time. It’s possible to simply drag elements of interest from the explorer panel onto the canvas for analysis or manual manipulation of relationships. Existing connections are instantly displayed.

The canvas is pretty intuitive, featuring support for drag and drop. Objects can be resized and expanded to reveal content. You can create new relationships on the spot, and synchronize changes to the connected database. The application can attempt to correct all reference paths for you in case something goes wrong.

You’re free to manually create a custom design on the canvas to better understand elements in the database. There are also navigation options and functions for automatic arrangement of objects. The project can be saved for later editing, and you can export an image of the entire relationship design.

All things considered, we can state that Altova SchemaAgent can shed a little light on the content and relationships of database objects. It effortlessly processes XML schemas and instances, WSDL file relationships, while allowing you to take matters into your own hand. Views can be customized, and changes synchronized to a connected server.