Altova Developer Connection Newsletter Archive

Below is the text of the Altova Developer Connection Newsletter for July 2010

In This Month's Issue:

New MapForce HL7 Online Training Course Available

Tech Note – Using DatabaseSpy to Connect to a SQL Azure Database in the Cloud

Save 20% on our Affordable, Advanced UML Modeling Tool until July 31

New MapForce HL7 Online Training Course Available

Altova MapForce provides support for mapping to and from Health Level 7 (HL7) electronic healthcare records in both their legacy EDI format and the more recent XML-based standard. A new HL7 MapForce module, the latest course added to the Altova Online Training program, helps users begin their HL7 integration and mapping projects with step-by-step tutorials, evaluation exercises, and an opportunity to work with real HL7 files and functions.

The course begins with a high level introduction to HL7 that explores the current standards and the structure of EDI and XML-based HL7 files. The next chapter introduces HL7 integration and provides a tutorial for using MapForce to connect to a database and other data sources. With a better understanding of HL7 and MapForce's powerful integration capabilities, Chapter 3 walks through the conversion of an EDI HL7 version 2 file to an XML-based HL7 version 3 file.The final chapter then focuses on adding locally-defined information, or z-segments, to the HL7 EDI components as well as how to add a z-segment to a configuration file, EDI collection file, and HL7 segment file.

To access this HL7 MapForce course or view a complete list of training topics now available visit the Altova Online Training page: http://www.altova.com/aot/online-training.aspx

To learn more about all of the powerful integration capabilities available in MapForce download a 30-day trial here: http://www.altova.com/download.html

Tech Note – Using DatabaseSpy to Connect to a SQL Azure Database in the Cloudt

Azure™ is built on Microsoft® SQL Server® technologies and is designed to provide a highly-available and scalable database service hosted by Microsoft in the cloud. Developers who deploy databases in SQL Azure do not have to install, setup, patch, or manage any relational database software; they simply manage their own database structure and content.

DatabaseSpy, our unique multi-database query, design, and comparison tool, allows you to build a manual connection string and use SQL Server syntax and datatypes to connect to SQL Azure databases for performing typical database development and maintenance tasks.

The latest Altova Tech Note “Build an ODBC Connection String for SQL Azure in the Cloud” provides step-by-step instructions for building a connection string from DatabaseSpy to an Azure database. Read it now here: http://www.altova.com/Build-ODBC-Connection-String.html

For examples of several typical operations you may want to perform as you migrate an existing database to the cloud, check out the Altova Blog here: http://blog.altova.com/2010/07/connecting-databasespy-to-sql-azure.html

To download a free, 30-day trial of Altova DatabaseSpy visit: http://www.altova.com/download.html

Save 20% on our Affordable, Advanced UML Modeling Tool until July 31

Altova UModel, our UML modeling tool, starts at just $149 and delivers the most advanced features in the industry for a fraction of the cost of competing tools.

With the release of Version 2010 Release 3, UModel added support for C# 4.0, the latest version of the programming language, and integration with Visual Studio® 2010 to its already impressive line-up of functionality that includes support for:

All 14 UML 2.3 diagrams
SysML and BPMN
Code generation and reverse engineering of Java, C#, and VB .NET
Round-trip engineering
XMI import / export
Eclipse integration
32- and 64-bit versions
And much more

And from now until July 31, 2010, you can get Altova UModel for an additional 20% off its regular low price! Just visit the Altova Online Shop https://shop.altova.com and enter code JULY10 during checkout.