|
| | | Database Tools from Altova
Database technology revolutionized the process of information storage and organization so much that, today, businesses and organizations of all types use databases to house the majority of their mission critical information. While databases are efficient tools for storing data, they are not generally designed to interoperate with other business systems, since this wasn’t generally a requirement at the time of their inception. Today, however, with the ubiquity of Web services and other internet technologies, the importance of connecting databases to other prevalent information storage and exchange formats is paramount. Database Integration Altova XMLSpy, MapForce, StyleVision, DatabaseSpy, 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. Relational 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 9i and 10g XML DBs. Support for Third-party XML Schema ExtensionsThe XMLSpy XML Schema Editor supports third-party database extensions for Oracle XML DB and Microsoft SQL Server 2000. Altova 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, 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. Intended 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 an XML Schema) 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. In 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, and is available free-of-charge.
DatabaseSpy Multi-database Management, Query, and Design
DatabaseSpy 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. The tools listed above are available individually or as part of the Altova® MissionKit™ 2008. Get up to 8 software tools for the price of 2 with the Altova® MissionKit™ 2008! The MissionKit bundles Altova's intelligent application development and data management tools to meet the needs of software architects and XML developers. Authentic is always free-of-charge! Download Authentic and a free trial of the Altova® MissionKit™ 2008 today to see how Altova database support and help you create high quality applications in less time. | |
| | ||||||||||||||||||||||||||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | |||||
|
