 |
|
|
 | Altova MissionKit® | The Altova MissionKit provides extensive support for database management, query, and design; database integration; database differencing; and database content editing our award winning DatabaseSpy, XMLSpy, MapForce, DiffDog, StyleVision, and UModel applications. |
 | Altova DatabaseSpy® | SQL editing is a breeze with DatabaseSpy, a query and design tool. |
 | Altova XMLSpy® | Move seamlessly between XML and database data with XMLSpy. |
 | Altova MapForce® | Map between databases and XML, flat files, EDI, Excel, XBRL and Web services with MapForce. |
 | Altova DiffDog® | DiffDog is an intelligent diff / merge utility for files, directories, and database schemas and tables. |
 | Altova StyleVision® |
Generate dynamic DB reports in HTML, RTF, PDF, Word 2007+ (OOXML) and eForm with StyleVision. |
 | Altova UModel® |
UModel is a sophisticated UML tool that supports relational database modeling and development. |
Do you need to create a new database or design a database schema? Check out DatabaseSpy and UModel. Do you need to develop XML applications that integrate database data? Look no further than XMLSpy Do you have a data mapping or integration project? MapForce is the answer. Do you need to design database reports? The Altova solution – StyleVision. Do you need to difference and merge databases? DiffDog and DatabaseSpy can help. Do you need all of this functionality? Choose the MissionKit tool suite. Altova DatabaseSpy, XMLSpy, MapForce, DiffDog, StyleVision, and UModel can be used for database development and management activities for the following databases (see details in the sections below):
- Microsoft® SQL Server® 2000, 2005, 2008
- IBM DB2® 8, 9
- IBM DB2 for iSeries® v5.4, 6.1
- Oracle® 9i, 10g, 11g
- Sybase® 12
- MySQL® 4, 5
- PostgreSQL 8
- Microsoft Access™ 2003, 2007
In addition to the relational databases listed above, deep integration with IBM DB2 9 pureXML is provided throughout the Altova product line. DatabaseSpyDatabaseSpy is a multi-database query and design tool that simplifies SQL editing and database structure design for a fraction of the cost of single-database solutions. DatabaseSpy makes querying, visualizing, managing, comparing, designing, and constructing relational databases easy with advanced features and functionality. With DatabaseSpy you can: - Work with the most widely used databases including SQL Server, IBM DB2, Oracle, Sybase, MySQL, PostgreSQL and MS Access (see detailed list in Support for All Major Databases above)
- Simultaneously connect to multiple databases of different types
- Easily write SQL queries with capabilities like code completion, syntax coloring, drag and drop construction, and more
- Visualize database tables, views, and data in easily navigable windows
- Compare and merge database differences
- Compare and merge database schemas
- Convert an existing database to a new database type
- Create compelling data views with advanced SQL charting
- View XML Schemas registered in IBM DB2 9 and SQL Server databases
- Add new columns containing XML data to IBM DB2 9 and SQL Server databases, with detailed access to XML data types
- Organize database connections and related files with DatabaseSpy project files
DatabaseSpy is a multi-purpose database utility for database professionals looking for advanced functionality with an intuitive user interface.
> Read more about DatabaseSpy UModel UModel is a UML tool for software modeling and application development with support for relational databases. UModel’s advanced functionalities help users model and create robust databases using Unified Modeling Language. With UModel you can: - Automatically generate SQL CREATE scripts from a database model
- Generate Java, C#, and VB.NET code
- Import existing tables from the most widely used relational databases
- Modify diagrams for existing tables and generate SQL database change scripts
- Ensure that your database model and code remain synched with round trip engineering functions
- Manage large database projects with subprojects and three-way merge capabilities
- Work with multiple contributors - UModel supports external source control applications
- Ensure the integrity of database design with automated syntax checking
UModel simplifies development by allowing you to use UML for database modeling and creation.
> Read more about UModel XMLSpyAlthough most organizations store information in relational databases, XML has become the de facto standard for data exchange and content management. XML-based applications thus typically require bi-directional integration with relational databases, making converting back and forth between database and XML data formats a common requirement. XMLSpy offers comprehensive support for managing both formats. With XMLSpy you can: - Query and edit data in a relational database with SQL statements
- Import database data into an XML document
- Create an XML Schema from a relational database
- Export XML data to a relational database
- Generate a database schema based on an XML Schema
- Manage native XML databases – enjoy built-in support for IBM DB2 9 pureXML , Oracle's XML DBs, and SQL Server
- Leverage the XML Schema Editor with support for IBM DB2 9 pureXML, Oracle XML DBs and SQL Server third-party XML Schema extensions
XMLSpy can help you meet interoperability challenges by enabling you to quickly and accurately convert database data to an XML file and back again.
> Read more about XMLSpy MapForceMapForce is graphical data mapping, conversion, and integration tool that transforms database data to other common formats including XML, other databases, flat files, EDI, Excel 2007+, XBRL, and/or Web services. Advanced data conversion functionalities make MapForce an invaluable tool for developers, DBAs, and IT power users. Use MapForce to: - Visualize data mapping with intuitive drag and drop functionality
- Manage database integration for virtually any format including XML, other relational databases, flat files, EDI, Excel 2007+(OOXML), XBRL, and Web services
- Transform data with advanced data processing filters and built-in functions – use the visual function builder to combine multiple inline and/or recursive operations in more complex data integration scenarios
- Transform data instantly or use automatically generated Java, C++, or C# code to execute recurring conversions
- Control how data is written to the database and automate even the most advanced data management tasks through the Database Table Actions dialog box
MapForce is the first affordable, general purpose data mapping and Web services implementation tool to support all major relational databases.
> Read more about MapForce StyleVisionStyleVision is a powerful database reporting tool that allows you to design full featured reports based on relational database data as well as XML and XBRL data sources quickly and easily. StyleVision’s advanced capabilities allow developers to design flexible reports that meet the needs of a range of stakeholders. Use StyleVision to: - Build reports from database, XML and XBRL content in an intuitive, drag and drop user interface
- Design impressive charts and graphs to represent database, XML and XBRL data
- Support cross media publishing - generate report output in multiple formats (HTML, RTF, PDF, Word 2007+, and electronic forms) from a single design template
- Develop reports with advanced features including bar codes, calculations and format-based conditional output
- Enable interactive reporting by creating electronic forms for Authentic, Altova's free XML and database content editor – Authentic users can select and populate data through drop down menus, check boxes, text fields, and other electronic form controls
Database reporting is a major business requirement of virtually all organizations. StyleVision can help you design compelling reports that set themselves apart from the rest.
> Read more about StyleVision DiffDogDiffDog has added database table and schema differencing to its powerful, XML-aware, diff/merge capabilities for XML documents, directories, and ZIP files. Developers and other IT professionals can dramatically increase the efficiency of database projects with DiffDog’s advanced diff/merge capabilities. With DiffDog you can: - Compare database schemas and the contents of database tables via an intuitive visual interface
- Automatically generate SQL change scripts – there are multiple options for processing scripts including saving the file, executing it in DiffDog and sending to the SQL editing window in DatabaseSpy
- Compare multiple databases simultaneously, including those of different types
- Map columns based on name, datatype, or column position
- Save database comparison criteria in a file for re-use – database comparison files can be shared with Altova DatabaseSpy for even more functionality
- Leverage advanced XML-aware diff merge capabilities
DiffDog is a powerful yet easy-to-use diff merge tool that lets you quickly compare and merge database files and schemas so that you can focus on activities that bring more value to your project.
> Read more about DiffDog DatabaseSpyDatabaseSpy is a multi-database query and design tool that simplifies SQL editing and database structure design for a fraction of the cost of single-database solutions. DatabaseSpy makes comparing and merging the contents of database tables and schemas easy with advanced features and functionality. With DatabaseSpy you can: - Work with the most widely used databases including SQL Server, IBM DB2, Oracle, Sybase, MySQL, PostgreSQL and MS Access (see detailed list in Support for All Major Databases above)
- Simultaneously connect to multiple databases of different types
- Save database comparison criteria in a file for re-use – database comparison files can be shared with Altova DiffDog for even more functionality
- Automatically generate SQL change script – the script opens in a new SQL Editor window where you can review/edit and then manually execute
- Design database tables and schema in an easily navigable drag and drop interface
DatabaseSpy is a multi-purpose database query and design application that supports a range of database activities. DatabaseSpy helps reduce the administrative burden of comparing and merging database tables and schemas so that database professionals can focus on other activities.
> Read more about DatabaseSpy
|
|
|
|
