Database Solutions

Altova SQL Database Solutions

Powerful support for working with relational databases is provided throughout the tightly-integrated tools that comprise Altova MissionKit. Supported databases include:

  • Microsoft® SQL Server® 2000, 2005, 2008, 2012
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1
  • Oracle® 9i, 10g, 11g
  • MySQL® 4, 5, 5.5
  • IBM DB2® 8, 9, 9.5, 9.7, 10.1
  • IBM DB2 for iSeries® v6.1, 7.1
  • Informix® 11.70
  • Sybase® 12, Sybase ASE 15, 15.7
  • Microsoft Access™ 2003, 2007, 2010, 2013

With support for all major relational databases alongside today’s most prevalent standards-based data formats, Altova MissionKit is your go-to toolkit for working in a multi-platform, real-world database environment.

The Problem

Database tools are often targeted to a specific DBMS, which becomes complicated - and expensive - quickly, since today's organizations often manage in-house systems from multiple database vendors. Adding to the challenge is the necessity to integrate that database data with other formats to meet information exchange, reporting, and compliance requirements.

The Altova Solution

Altova MissionKit SQL database tools support all major relational databases in their native interface language. MissionKit provides rich functionality for all database-related tasks.

MissionKit tools connect to relational databases using a consistent, familiar SQL query interface and share a common a graphical development paradigm that makes it easy to tackle virtually any database design, integration, or reporting challenge.

Generation of royalty-free C#, C++, and Java code for automating data integration projects, plus optional integration with Visual Studio and Eclipse, give you flexible development and deployment options at no extra cost.

DatabaseSpy

  • Multi-database, query, design, and comparison tool.
  • Enables SQL editing, database structure design, database content editing, and more, through its intuitive database connection wizard and graphical UI.
  • Converts easily between database types.
  • Generates SQL charts and graphs.

MapForce

  • Graphical, any-to-any data mapping tool with support for integrating any combination of XML, databases, flat files, EDI, XBRL, and Web services data.
  • Drag and drop to define mappings, data processing rules, filters, and functions.
  • Preview results immediately, and generate royalty free code.
  • Automate mappings using MapForce Server.

StyleVision

  • Visual design tool for integrating, combining, and publishing database, XML, and XBRL data.
  • Drag and drop to design attractive reports for simultaneous publishing in HTML, PDF, Word, and e-Forms.
  • Use auto-generated XSLT for ongoing reporting needs.
  • Build Authentic eForms for database content editing.
  • Automate processing using StyleVision Server.

UModel

  • UML modeling tool with unique relational database modeling functionality.
  • Drag and drop to design attractive reports for simultaneous publishing in HTML, PDF, Word, and e-Forms.
  • Import existing tables from relational databases to create UML database diagrams. Diagram modifications create a SQL change script.
  • Design new database tables and relationships from scratch and issue SQL CREATE scripts.

DiffDog

  • Powerful diff / merge utility with support for SQL databases.
  • Diff database tables to compare and merge content using a graphical interface.
  • Diff database schemas compare database structures and visually identify and merge differences.
  • Review and issue SQL change scripts to merge differences.
MapForce database mapping

Altova MissionKit wins “Best Development Environment!”

Altova MissionKit

Get all these products in a highly-integrated XML, SQL, and UML tool suite – at an attractive discount. You'll get 7 tools for less than the price of 2!