|
|
| | Database Tools from Altova
Database IntegrationAltova DatabaseSpy, XMLSpy, MapForce, DiffDog, StyleVision, and Authentic support integration with the following databases (see details in the sections below):
In addition to the relational databases listed above, deep integration with IBM DB2 9 pureXML is provided throughout the Altova product line. DatabaseSpy Multi-database Management, Query, and DesignDatabaseSpy is a multi-database query and design tool that eases SQL editing and database structure design for a fraction of the cost of single-database solutions. DatabaseSpy includes the following features for working with relational databases:
DatabaseSpy project files let you organize database connections and related files. You can create a DatabaseSpy project to collect SQL files for a set of reports you need to run on a periodic basis. Or you might save design files in a project as you plan new tables or other changes to an existing database. When you save the files you need for any set of tasks in a project, you can reopen the project file later to restore quick access right where you left off. XMLSpy Database IntegrationRelational Database and XML IntegrationSince many XML-based applications require bi-directional interaction with relational databases, converting back and forth between database and XML data structures is a common requirement. XMLSpy includes full support for working with relational databases and XML. Using XMLSpy, you can connect to and query a database or import or export data. You can generate an XML Schema based on a database structure, or, conversely, generate a database schema based on an XML Schema. The XMLSpy Convert Menu makes this process easy and seamless. Native XML Database IntegrationIn addition to supporting relational database integration, XMLSpy allows you to work with native XML databases with built-in support for IBM DB2 9 pureXML and Oracle's XML DBs, and SQL Server. Support for Third-party XML Schema ExtensionsThe XMLSpy XML Schema Editor supports third-party database extensions for IBM DB2 9 pureXML, Oracle XML DBs and SQL Server. MapForce Database IntegrationAltova MapForce provides unprecedented power and flexibility for integrating database data with other common formats – whether you’re performing a one-time conversion or implementing an automated data transformation in your own application. MapForce supports relational databases, XML, flat files, EDI, Excel 2007 (OOXML), XBRL, and Web services as the source and target of any data mapping. Using MapForce, data mappings are designed visually, which means you don’t have to understand the underlying complexity of each data type. You simply insert your data models and map between them by dragging connecting lines and data processing functions between corresponding elements. Then, the MapForce Engine executes the transformation, which you can view and save. MapForce also autogenerates Java, C++, or C# applications to implement the data conversion programmatically. DiffDog Database DifferencingAltova DiffDog adds database table and schema differencing to its powerful, XML-aware, diff/merge capabilities for XML documents, directories, and ZIP files. StyleVision Database IntegrationIntended as a tool for storing, searching for, and retrieving information, relational databases usually do not provide features for presenting the data stored therein in a meaningful, eye-catching manner. Database reporting applications have been developed to meet this need, but they are often expensive and optimized solely for one type of database or one output format, such as HTML. To meet the communication requirements of various departments, partners, and customers, however, users are often required to present database reports in multiple formats, and converting reports to other media can be costly and time consuming. Altova StyleVision is a powerful database reporting tool that allows you to design stylesheets based on a database (or XML/XBRL data sources) quickly and easily to generate report output to HTML, RTF, PDF, and Word 2007 (OOXML) – all from a single design. To design a database report in StyleVision, you simply connect to the required tables in your database and design your database report using drag-and-drop functionality and rich formatting options. Based on your design, StyleVision automatically creates stylesheets to output your report in HTML, RTF, PDF, and Word 2007 (OOXML) – you get four eye-catching reports from one easy-to-create design! read more below. Authentic Database Content EditingIn addition to the output formats listed above, StyleVision also generates an Authentic electronic form based on your design. The Authentic e-Form provides a word processor-style interface for non-technical users to edit databases.
| |
| | ||||||||||||||||||||||||||||||||||||||||||||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||
|
Get the latest Altova announcements, learn about new product features, read tech tips and industry info at the 