XMLSpy Database Connection Wizard
The Database Connection Wizard originally developed for Altova DatabaseSpy is now also used in XMLSpy, MapForce, and StyleVision.
In both the Enterprise and Professional Editions of XMLSpy® 2017, the Database Connection Wizard provides a new, simplified, and standardized method to connect to any database for data import and export, or to create an XML Schema from a database structure (or vice versa).
The Database Connection Wizard in XMLSpy lets you to connect to any of these databases:
- Firebird 2.5
- IBM DB2 for iSeries® v6.1, 7.1
- IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
- Informix® 11.70
- Microsoft Access™ 2003, 2007, 2010, 2013
- Microsoft® Azure SQL
- Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
- MySQL® 5, 5.1, 5.5, 5.6
- Oracle® 9i, 10g, 11g, 12c
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
- Progress OpenEdge 11.6
- SQLite 3.x
- Sybase® ASE 15
To take advantage of the Connection Wizard in XMLSpy to create an XML Schema from a database structure, follow these easy steps:
- Select 'Create XML Schema from DB Structure' from the XMLSpy Convert menu.
- If it is not automatically selected, highlight the Connection Wizard icon at the upper left of the dialog to connect to a known database. (The other two options let you quickly build new connection strings for ADO and ODBC databases.)
- Choose the radio button for your database type and click 'Next'.
- The next steps vary in details based on the database type you choose, but you will be offered a list of databases already known to your system. Choose one and complete the connection.
- A hierarchical tree of the database tables will be displayed. Simply choose the tables you want, modify any settings in the Options tab as necessary, and click 'Import'.
XMLSpy reads the table structure, builds the XML Schema, and opens it in the graphical Schema/WSDL view for visualization and editing.
The Connection Wizard is just as convenient when you connect XMLSpy to a database for importing or exporting data. It works the same when you connect to a database using Altova MapForce, StyleVision, and DatabaseSpy.