SQL Queries with Parameters: Support for SQL Templates in DatabaseSpy


SQL queries with parameters, also known as SQL templates, are a flexible and efficient solution for repetitive data reporting requirements, for instance allowing users to easily execute complex join statements with multiple sets of values. DatabaseSpy, the multi-database query, design, and editing tool from Altova, includes robust support for developing, executing, and refining complex SQL queries with parameters, also known as SQL templates.

Prototyping SQL queries with parameters in DatabaseSpy can even accelerate development of queries required in other projects such as database mappings in MapForce or database data sources for MobileTogether cross-platform mobile apps.

Big Data Support

Read more…

Tags: , ,

Three-Way File Comparison and Difference Merging


Manually comparing versions of a long XML Schema or document to find any differences would be a tedious and error-prone task. XMLSpy has long featured file comparison with highlighted differences in side-by-side windows with merging in either direction. And of course, DiffDog is the go-to comparison utility for text, source code, XML, JSON, and Word documents. Now both XMLSpy and DiffDog support three-way file comparison and difference merging.

Three-way file comparison is especially relevant for files managed in any source control system where two users may have started from the same source file and made different edits that need to be reconciled.

Read more…

Tags: , , ,

Add to Your Collection of Development Building Blocks


When it comes to developing sophisticated software and data integration applications, the more building blocks a developer has at his or her disposal, the better. With each release of our developer and server software, we aim to provide customers with unique tools that give them the edge to get the job done – faster, and more efficiently.

To that end, Version 2018 delivers a unique HTTP testing window, 3-way file comparison functionality, support for SQL Templates, super-powered new server options, and much more.

Read more…

Tags: , , ,

Text-to-Speech for Mobile Apps


Altova MobileTogether supports text-to-speech functionality for cross-platform mobile apps, empowering developers to add speech and build a rich multi-media user experience.

Speech can be fully integrated with text anywhere it appears in an app. For instance, an app like the Parcel Delivery MobileTogether example can be enhanced by speaking the next delivery address aloud – especially if the driver is in traffic! Or, text in message boxes of other information blocks can also be spoken by the mobile device.

We created a simple demo to experiment with the functionality of text-to-speech for mobile apps then added text-to-speech features to the Parcel Delivery app.

Text-to-speech for mobile apps

Read more…

Tags: , ,

Exploring an Unfamiliar Database with DatabaseSpy


Software developers working on a new app, data professionals in a variety of enterprises, and even database administrators often encounter unfamiliar databases and need a database tool to quickly explore tables and relationships.

Altova DatabaseSpy is a unique multi-database query, design, and comparison tool with a graphical database design editor that empowers users exploring an unfamiliar database to quickly visualize tables, relationships, and even datatype definitions that may be unique among database types.

Read more…

Tags: ,

Support for JSON5 in Altova MissionKit, Server Products, and MobileTogether


Altova products have supported JSON for several years. Now, Version 2017 Release 3 of MissionKit and Server products, and MobileTogether Version 3.2 all include support for JSON5 across the product line.

The JSON data format was originally designed to be machine-written and consumed, promoting efficient communication between servers. Usage has expanded and JSON5 is a proposed extension intended to make JSON code easier for humans to write and read.  JSON5 extends JSON by adding some ECMAScript 5 features and, like JSON, is a strict subset of JavaScript. Specifically, JSON5 permits inline and block comments, allows long strings to be split over several lines, and defines alternate legal syntax options for quotes and commas.  These features are not permitted in standard JSON, so files containing the proposed enhancements are typically identified with the .json5 filename suffix.

This post details specific support for JSON5 in each Altova product.

Learn about JSON5 support in Altova tools

Read more…

Tags: , , , , , ,

Simplifying License Management


We’ve been offering a centralized license server to all customers of our Altova server software products for quite some time. Now,  you can also manage all Altova desktop software licenses with the same license server. This support covers all MissionKit products, such as XMLSpy, MapForce, StyleVision, etc., whether they’re licensed separately or as part of a MissionKit product bundle.

Doing so greatly simplifies license management for the IT administrator in your organization and allows you to maximize your usage of the investment you’ve made in Altova software products. The Altova LicenseServer can now handle the management of installed-user, concurrent-user, and named-user licenses for all desktop developer tools and allows you to centralize license management either on a per-department level or for an entire organization.

133556519_700px

Read more…

Tags: , , ,

Mobile Apps for Enterprise Operations Management


Combining rapid mobile app development (RMAD) with a single development environment for building cross-platform apps makes Altova MobileTogether an ideal tool to create specialized mobile apps for enterprise operations management at all levels.

The development schedule using MobileTogether can be as short as a few days vs. weeks or months for traditional native platform coding. That kind of productivity makes it practical to build specialized apps that might only be used by a small number of operations managers, but greatly improve enterprise efficiency.

For instance, an app for the inventory manager for a manufacturing operation with just-in-time supply chain management can link to back-end systems to monitor inventory levels using any mobile device from anywhere in the plant or even offsite.

Read more…

Tags: , , , ,

3 Ways XML Text View Just Got Better


Though XMLSpy includes a helpful Grid View for visual editing, Text View remains the most popular pane for developers using the XML editor. Intelligent XML editing functionality helps make the job easier, and we’re continuously adding functionality to the XMLSpy Text View to facilitate this.

Let’s look at some new functionality XML developers will have at their disposal starting with Release 3 of XMLSpy 2017.

XML developer

Read more…

Tags: , , ,

MapForce Server Accelerator Edition Achieves a New Level of Data Transformation Performance


MapForce Server automates recurring execution of data mappings and transformations designed and tested using Altova MapForce. Every day, MapForce Server is employed in business communication, financial reporting, database ETL, and many other applications to transform critical data between any of XML, JSON, database, EDI, XBRL, flat file, CSV, Excel, and/or Web service formats.

Now, MapForce Server Accelerator Edition offers even faster throughput for high-performance server platforms.

Read more…

Tags: , ,

Update to Altova’s Database Tool Adds Important New Features


DatabaseSpy is the unique database tool that supports all major databases and facilitates database query, design, structure comparison, table content editing and comparison, and even generates elegant charts from query results.

The recent update of DatabaseSpy to version 2017 Release 3 adds several new features, including the ability to automatically generate a complete DDL script for any database schema.

Read more…

Tags: , ,

Use Join to Integrate Data in Any Format


Join is a powerful SQL operation implemented across most database types and familiar to database users. Join is typically used to select and combine information from multiple database tables.

Altova MapForce includes a join component for data mapping that works like a SQL join for database tables and extends data integration functionality by empowering users to join data trees of any data format. Anyone familiar with join operations for database tables will find the MapForce join component especially intuitive. A join operation in MapForce can even combine two different data formats and produce output in a new format altogether.

Read more…

Tags: , , ,

A Typical MapForce Server Use Case


Envision a manufacturing company that controls costs by exploiting a just-in-time assembly process with a very low supply of parts inventory on hand. New customer orders are logged in a sales database and at the end of every day the components needed to assemble that day’s sales are tabulated.

The IT department runs a SQL query to identify the required parts and transforms the list into a purchase order in JSON format to be transmitted to the supply chain.

Sound familiar? Our recent blog series on JSON tools and JSON data mapping were based on this real-life scenario. In this post we describe a MapForce Server use case that automates the repetitive task of generating each day’s purchase order.

Read more…

Tags: , , ,

JSON Data Mapping and Transformation with MapForce


JSON is a popular format for transferring data between systems thanks to its simple markup, small footprint, and heritage based on the JavaScript programming language. MapForce supports JSON as both an input and output format for JSON data mapping and transformation. For instance, MapForce can extract information from any popular database and produce a JSON file ready for transfer.
The Requirement: Here is an example of a typical need for JSON data mapping: A manufacturing company controls costs by exploiting a just-in-time assembly process with very little parts inventory on hand. New customer orders are logged in a sales database, and at the end of every day the components needed to assemble that day’s sales are tabulated via a query into the database. The required parts will be ordered from suppliers via a purchase order transferred in JSON format.

Read more…

Tags: , , ,

Generate PDF, Word, or RTF Documents from a Mobile App


Need to empower mobile users to capture information and generate a document or report from any remote location? MobileTogether lets you build a cross-platform mobile app to do that. You can tailor the app with all the device-specific mobile controls users expect, like check boxes, date pickers, switches and buttons, yet generate output files identical to an existing document, form, or report already familiar throughout the enterprise.

The Actions Dialog in the MobileTogether Designer lets developers define a Print To action to generate PDF, Word, or RTF documents from a mobile app. Once a document is rendered, it is saved on the mobile client for further processing. For instance, a PDF file could be emailed as a file attachment.

Generate PDF, Word, or RTF Documents from a Mobile App

Read more…

Tags: , , ,

Database Features Across the Altova Product Line


We have written previously about database features like SQL Merge for data integration, and summarized database features in the latest release. But if you’ve only used one or two Altova products, you may not be aware of the powerful support for working with relational databases is provided throughout Altova’s tightly-integrated tools.

Database features across the Altova product line

The Altova MissionKit and MobileTogether products include SQL database features with rich functionality for database-related tasks, supporting all major relational databases in their native interface languages.

Read more…

Tags: , ,

Learn About Inline XBRL and XBRL Taxonomy Packages


As adoption of the eXtensible Business Reporting Language (XBRL) for financial reporting increases worldwide, new standards are emerging to meet the needs of filing companies and developers alike. Altova’s line of XBRL-enabled products supports a wide-range of XBRL standards and is updated frequently as new specifications emerge.

Let’s take a closer look at two of the newer XBRL standards – Inline XBRL and XBRL Taxonomy Packages – and explore how they work.

Corporate buildings

Read more…

Tags: , ,

Automated Testing for Mobile App Development


Robust and repeatable testing improves any software development project. If you’re creating a mobile app, testing is especially critical given the unpredictable range of end user devices and location variables. Altova MobileTogether includes sophisticated Automated Testing features that let developers:

  • Record a series of user actions as a test case
  • Replay the test case in the MobileTogether Designer Simulator environment
  • Deploy test cases to the MobileTogether Server for replay on a variety of client devices
  • Retrieve Test Run results from the server and compare differences

Automated Testing for Mobile Apps

You can even modify the app to fix a bug and run the test case again to validate the results of changes, which makes this an indispensable QA tool for your mobile app development process.

Read more…

Tags: , , , ,

MapForce Supports SQL Merge When It’s the Right Tool for the Job


Large database tables can easily contain a million, even hundreds of millions of rows of data. Database administrators and others charged with maintaining such large datasets are always concerned about execution time for ETL (Extract, Transform, and Load) operations, updates, and other SQL queries. To make these operations more efficient, some — but not all — database vendors implemented a SQL merge statement to insert or update rows of an existing table as a single bulk-insert statement rather than requiring individual statements for each row.

Altova MapForce automatically supports SQL merge when it is available for the target database. Let’s look at an example.

shutterstock_66084286

Read more…

Tags: , , ,

MapForce Offers Dynamic Access to Node Names


There are situations, especially when encountering loosely structured data, where you may want to map and transform structural components of a data stream along with content. MapForce can dynamically access node names of XML elements, attributes, or text file columns such as the contents of CSV files, to target components.

Dynamic access to node names allows creation on the fly of target elements and attributes whose names do not need to be known beforehand or specifically identified in the data mapping. This feature lets you create much more generic, flexible, and reusable mappings that require less manual intervention if data models evolve.

News about Dynamic Access to Node Names in MapForce 2017

Read more…

Tags: , , ,

XML Editor Text View Gets a Big Update


Starting with Version 2017, XMLSpy developers will have access to some new, time-saving productivity tools in their favorite XML editor, including a modernized  Find/Replace dialog, an easy way to select all occurrences of a particular string, and a shortcut for finding a parent element.

I was amazed how much time and effort these new tools saved me right away – let’s take a look, and I’ll show you how.

News about XML find / replace

Read more…

Tags: , ,

Audio and Video in Cross-Platform Mobile Apps


Altova MobileTogether combines UI design by visual drag and drop with functional programming using Actions and Action Trees to let developers quickly build mobile apps for iOS, Android, and Windows devices. MobileTogether 2.2 recently added support for multimedia features that will delight end users with sound effects, video, and audio recording functionality.

Add audio and video to delight mobile app users

Read more…

Tags: , , , , ,

Excel Add-in Generates XBRL WIP Data


The reach of the eXtensible Business Reporting Language (XBRL) is rapidly expanding beyond financial reporting requirements to provide the advantages of standardized data submission across verticals. One recent development is the Work in Process XBRL Taxonomy created by XBRL.US for the surety industry.

The good news is that non-technical stakeholders can be completely shielded from the complexity of XBRL using software tools developed in concert with the taxonomy standards.

We’re excited to introduce the Altova Work in Process (WIP) XBRL add-in for Excel: a new product that lets contractors build their WIP reports directly in Excel, where they’re already comfortable working, and then export the reports in WIP XBRL for submission to sureties and underwriters.

Contractors writing WIP XBRL reports in Excel

Read more…

Tags: , ,

Scrolling Tables for Data-Driven Mobile Apps


Mobile device users always demand maximum information in the most convenient package, but small screen sizes can force a trade-off. Mobile app developers are challenged to fit data, navigation controls, and helper information all into a pleasing layout or risk frustrating end users who could be customers, colleagues, or c-level executives. MobileTogether 2.1 introduces scrolling tables and other cool new features to help developers create apps that present data elegantly and work the same way on all devices.

shutterstock_160560011

Read more…

Tags: , , , ,

What’s New in XML Schema 1.1?


Since the introduction of XML Schema 1.0, the standard has been widely adopted. Developers have requested several changes over the years, most notably the ability to specify and validate more granular business rules and also to allow flexible schema evolution. There are numerous changes and enhancements in the XML Schema 1.1 Recommendation aimed at addressing these issues.

Let’s take a look at the most notable new features and some resources for learning more or getting started right away with XML Schema 1.1.

shutterstock_137938508

Read more…

Tags: , , ,

Software Modeling for Projects of Any Size


UModel is Altova’s tool for software modeling with support for all 14 UML diagrams, additional UML-style diagrams for databases and XML Schemas, plus Business Process Modeling (BPM), and SysML. UModel 2016 Release 2 adds code engineering support for C# 6.0, complementing support for Java, Visual Basic, and earlier versions of C#. Creating a UML model from existing code can be a great way to analyze and document an unfamiliar project.

BLOG_State_machine02

Read more…

Tags: , , , ,

Starting Business Reports from Word


So much content these days is in the form of Microsoft Word documents. Word is where content or report creators often begin, and it has great tools for designing layouts and including images, tables and hyperlinks, and so on. What Word lacks though, is the ability to publish dynamic content or publish multiple versions of that content using the same template in an automated way, and that’s where Altova StyleVision comes in.

StyleVision is a unique product that is often difficult to describe because it does so much. Whether you want to auto-generate an XSLT stylesheet based on a visual design, create multi-channel business reports from dynamic XML or database data, or build user-friendly enterprise forms, StyleVision has you covered.

Starting with StyleVision 2016 Release 2, you can begin your StyleVision design based on an existing Word doc. Let’s take a look at why this saves an incredible amount of time, giving report and form designers the best of both worlds.

Designing a business report

Read more…

Tags: , , , ,

Data Mapping REST Web Services


MapForce 2016 Release 2 includes expanded functionality for Web Services data mapping, providing robust support for REST Web services. MapForce accepts XML or JSON as the Web service response, allows definition of parameters, and supports custom HTTP headers. Users may define the Web service interface manually or by importing settings from a WADL file or a URL. Manual definition of REST Web Service Settings lets developers create settings based on a template URL. This is a convenient step when developers test and refine REST calls in a Web browser window, since the URL can be copied from the browser to become the template.

REST Web Services can be a pipeline of information for a data mapping project

Read more…

Tags: , , , ,

Five Not-to-Miss Features in Altova’s Latest Product Release


I’m excited to reveal some details of today’s Release 2 of Altova MissionKit 2016 desktop developer tools and software products!

v2016r2 introduces over 20 new features and updates to the Altova product line – but that’s a lot to cover in one blog post. Let’s take a look at the top five that are sure to blow your socks off.

New in Altova products

Read more…

Tags: , , , , ,

Delight Users with Mobile App Features Tailored to the Device


An incredible variety of mobile phones and tablets exist in the world today and new models are announced continuously. All these mobile devices have different specifications and capabilities, which can be a problem for developers creating mobile apps. Tablets have large screen sizes, but don’t necessarily include cellular data, default color sets vary by phone manufacturer, and built-in mobile features may behave differently in each mobile operating system. Fortunately, the MobileTogether Designer provides an integrated development environment that lets users quickly design and build cross-platform mobile app features ideally suited to each end-user’s device.

shutterstock_54317866

Read more…

Tags: , , ,

Interactive Debugger for Data Integration Projects


MapForce 2016 introduces a revolutionary data mapping debugger that lets developers working on data integration projects examine data mapping output step by step to diagnose and perfect projects of any complexity. The MapForce data mapping debugger gives users deep insight into the exact inner workings of data integration and ETL projects in a way that was never before possible.

The debugger works with all MapForce data mappings for any combination of XML, XBRL, JSON, databases, flat files, EDI, Excel, or Web services data, including chained mappings, mappings with multiple input or output components, and mappings that include user-defined functions.

Data Mapping Debugger

The MapForce data mapping debugger supports breakpoints and conditional breakpoints, and includes multiple manual stepping options to manually debug a data mapping or continue execution after a breakpoint is reached, allowing users to see as much detail as they need.
Read more…

Tags: , ,

Data Mapping Files with XML Mixed Content


As more specialized data is adapted for delivery on demand to mobile devices with smaller screens, documents with complex structures can be a challenge. Fortunately, MapForce, Altova’s graphical data mapping, conversion, and integration tool, has special features to accelerate data integration projects of all sizes.

For example, richly-formatted documents may include XML mixed content, a complex datatype that permits an XML element to contain text, attributes, and other child elements. Common instances of XML mixed content include blocks of text with tags for bold or italic fonts, or tags that select terms for indexing or other special treatment. Documents with XML mixed content can be difficult to include in a data integration project, since they appear to be free-form and unpredictable, with child elements that occur in any order or even multiple times within the parent.

Mapping_mixed_content

Read more…

Tags: , ,

Foolproof, Fast, and Flexible XML Validation Options


The most recent few releases of XMLSpy included some pretty powerful speed increases for validations jobs, achieved by strengthening synergy between Altova products. Now, developers using XMLSpy can take advantage of RaptorXML Servers installed on their network for the processing of large or complex XML, XBRL, and project-based validation jobs – directly inside the XML editor.

raptorxml

The XML validator in XMLSpy is powered by the Altova RaptorXML validation engine, which already provides the closest possible standards conformance coupled with fast validation speeds. However, the validation rates achieved are still limited to single-core execution on the CPU available in the developer’s machine.  RaptorXML Server, on the other hand, benefits from the substantial increase in processing power afforded by multi-CPU, multi-core servers for increased throughput and more efficient memory utilization.

What does this mean for you? Let’s take a look at some of the advantages of connecting XMLSpy to RaptorXML Server.
Read more…

Tags: , , , ,

DiffDog E-book Now Available


We’ve published an e-book in multiple formats for your favorite tablet or other e-reader.

DiffDog Field Trials e-book cover image

DiffDog Field Trials is a collection of information from the Altova blog, Tech Notes from the Library section of the Altova Web site, and DiffDog product feature pages. The e-book describes a wide range of real-world applications for DiffDog, Altova’s XML-aware diff/merge tool for files, folders, directories, and databases.

You can download DiffDog Field Trials from the Altova Web site in various formats:

· EPUB (1.57 mb)

· Kindle (3.08 mb)

· PDF (11.1 mb)

· iBooks (16.5 mb)

Or, look for DiffDog Field Trials soon in your favorite online electronic bookstore.

Editing EPUB files with DiffDog

As you can see from the list above, EPUB, the XML-based free and open e-book standard by the International Digital Publishing Forum (IDPF), is potentially the most efficient sharable file format. An EPUB document is based on a ZIP compressed archive containing style information, text formatted as html, and the images that appear in the e-book.

Altova XMLSpy provides powerful support for accessing, editing, validating and previewing EPUB 2.x documents. We used XMLSpy to assemble the EPUB version of our book, where we were able to interactively preview the result as we worked:
XMLSpy EPUB Preview Window Read more…

Tags: , , , , ,

Directory Sync Tools: Move over little dog, a new DiffDog is moving in


Altova DiffDog was originally launched in 2005 as a diff/merge tool with XML-aware functionality to help users identify differences between XML files. It even identifies files that are XML-equivalent but appear different in a text comparison because of spacing, line-ending, or attribute order variations. Altova DiffDog DiffDog has continually improved over time with many new features including:

DiffDog 2011 Release 3 adds a new simplified directory sync feature to its robust folder diff/merge functionality. The Synchronize Directories dialog now includes a button at the top to select a complete directory sync in a single step. Folder sync tool mode selection The Fully Synchronize feature produces an exact copy of the source directory, even if the target has newer versions of some files, and deletes files from the target that don’t exist on the source, making this choice a quick tool to backup complex directories containing many files and sub-folders. DiffDog provides a summary of all actions to be taken before any files are copied or deleted: Folder sync summary If you want to prevent a file being overwritten or deleted from the target directory, you can click Cancel, and then use the Manual Override feature to ignore or reverse the copy direction for any file pair. Folder sync tool Manual override option Pretty good trick for an app that’s older than 42 in dog years*, isn’t it? Find out for yourself how DiffDog can faithfully synchronize your directories – download a fully-functional, free 30-day trial! * Popular myth suggests that one calendar year for a software developer is equivalent to 7 years in the life of a dog. For a more complete discussion of canine lifespan, see the Wikipedia article titled Aging in Dogs.

Tags: , ,

New XML Schema Editing Tools in XMLSpy


Let’s take a look at some of the new features for working with XML Schemas in the latest release of XMLSpy.

Sorting in Schema View

When you’re working in the graphical XML Schema editor, you can now sort some or all of the schema components alphabetically with a single click. This is a huge time saver when you need to organize large schemas that have evolved over time and for understanding new schemas that come across your desk. Simply click the A-Z button in the Schema Overview window and select the sort options you prefer. Your components are instantly sorted in the graphical view… xmlspy-sort-schema …and when you click over to Text View, the schema code itself is reordered and organized.

Schema Refactoring

Another new feature that’s invaluable when working with complex schemas or ones inherited from other developers is schema refactoring support. Taking advantage of XMLSpy’s powerful Find in Schemas functionality, you can quickly locate all the instances of a global element or type across a schema – and all imported and included schemas – and then rename that component in each place it occurs. This makes schema refactoring easy while ensuring the validity of all impacted schemas.

Intelligent Support for Changing Types

You may also find the need to change the type of an element or a base type, which previously meant reconfiguring all the facets associated with that component. This new feature gives you the option to preserve any facets or attributes that are compatible with the new type. Rename components to refactor schema  

Customizable XML Schema Documentation

Another option schema developers have requested quite often is the ability to customize the comprehensive XML Schema documentation generated by XMLSpy. This is now possible via integration with StyleVision. The StyleVision stylesheet design tool provides countless advanced options for customizing the documentation templates, from adding your company’s logo and branding to changing the appearance and organization of the documentation completely. StyleVision integration also gives you the option to generate documentation in PDF in addition to the HTML, Word, and RTF output options available for the fixed documentation in XMLSpy. Here’s an an example of XML Schema documentation we customized for the fictional Nanonull corporation: Embed image in XML XMLSpy 2011r2 also ships with several useful documentation templates that can be used as is or customized further in StyleVision:

  • XML Schema Structure Overview: documents the structure of global elements and complex types to the number of levels you specify
  • All XML Schema Type Derivations: displays all simple and complex types and their derived types in a tree format
  • XPath List: generates all possible XPath statements that are possible for a schema based on a user-specified number of levels
  • Statistics: lists the numbers of elements, types, attributes, groups, etc., for the overall schema, and for each associated schema file

To use a custom schema documentation template, you must have XMLSpy and StyleVision installed. If you are a MissionKit customer, you already have both tools and can take advantage of this feature and countless other options for working with XML Schema, from stylesheet and report design, to data mapping, and more. If you aren’t currently a StyleVision customer, grab a free trial from our Web site. The XBRL and WSDL documentation generated by XMLSpy may also be customized using StyleVision.   As always, we rely on your input and feature requests when planning each release – please let us know what you think of these new features and what you’d like to see in the next product version by leaving a comment here on the blog.

Tags: , , ,

Altova Tools for IT Professionals – Tell Us Your Story


MissionKit XMLSpy and the other tools in the Altova MissionKit are well-known in the development community as the go-to toolset for XML, data integration, UML, and database development projects. But Altova tools are also used by IT professionals to efficiently complete a variety of enterprise support tasks: XMLSpy is an advanced tool that makes XML documents easy to navigate and edit. Do you use XMLSpy to edit or validate any of the wide variety of XML configuration and data files increasingly essential to today’s IT environments? MapForce integrates and maps data between any combination of XML, databases, flat files, EDI, Excel 2007, XBRL, and/or Web Services. Have you ever used MapForce to merge an end-user’s Excel data into a database? DatabaseSpy is the unique multi-database query, design, content editor, and comparison tool selected as Roundup Champion by Redmond Magazine. Have you used DatabaseSpy to browse an unfamiliar database or build a SQL query to get a quick answer? And who could forget DiffDog? At every trade show visitors come to the Altova booth to rave about Altova’s file, folder, and database diff/merge tool. Do you depend on DiffDog to quickly identify changes between the live instance of a mission-critical file or folder and a backup copy? If you’re an IT professional who uses Altova tools to support the technical infrastructure of your enterprise, we’d like to hear your story. Click here to visit the Altova Case Studies page and check out the right margin to contact us. Of course you can comment right here too!

Tags: , , , , , ,

Integration Watch: Remember good tools at low cost?


Andrew Binstock, principal analyst at Pacific Data Works, recently published a great article in SD Times about some of the software tools he relies on to make his life easier. In “Integration Watch: Remember good tools at low cost?” he notes:

“Today, of course, tools are either free or terribly expensive; there is little middle ground. And there are very few small vendors of tools, with the notable exception of the components market for Windows applications—but those are more libraries than pure tools. One vendor, however, that has persevered making great [tools] at remarkably approachable prices is Altova, which has put out a variety of interesting products for a long time.”

Read the complete article here and let us know what you think! What are some of the inexpensive software tools that you rely on?

Tags: , ,

Diff / Merge Tools and Dog Food


Since its release in 2005, the Altova marketing team has been actively using the DiffDog diff / merge tool to compare and merge changes on our Web pages (something Product Marketing Manager David McGahey likes to call “eating our own dog food.” Get it? Dog food? Anyway…). We create and edit our content directly in XML using the XMLSpy XML editor and use WinCVS as our version control client. This way, we [not-so-technical marketing folks] can easily view and revert changes to any files in our CVS repository. When we need to compare changes made in two versions of a given file, we simply highlight the versions and launch DiffDog directly from WinCVS. It’s a lightning-fast way to see exactly what has been changed. image Our Web Development team also makes good use of DiffDog’s directory comparison functionality to diff and merge between our test and live Web servers.

Using DiffDog with Team Foundation Server

Jeff Levinson, Microsoft MVP and Application Lifecycle Management practice lead at Northwest Cadence, also recently shared his DiffDog story in an online article for Visual Studio Magazine, “Performing Comparisons with Team Foundation Server.” He details how you can replace the default merge tool in TFS with DiffDog. Do you have any stories to share about how you use our tools? Let us know!

Tags: , ,

Technical Brief: Streamlining Localization Processes with Altova Tools


Rapid globalization has had a profound effect on the documentation requirements of many forward-thinking companies. The need to quickly and accurately localize content for distribution to a host of different languages, while at the same time adhering to strict budgetary requirements, means that many companies have to rethink their legacy documentation technologies and workflows. XML and single source publishing have revolutionized content management, document exchange, and multilingual communications by separating content structure from appearance. An XML-based documentation system can greatly reduce costs through facilitating ease of conversion for delivery to many different data formats and types of applications. However, in order to take advantage of the full benefits XML provides, changes must be made in the traditional documentation workflow process. Throughout the documentation workflow, checks and balances are underway to ensure high quality content delivery. The single source concept ensures that these processes (i.e. conversion, edits, etc.) do not have to be repeated or reworked – that all content in the repository requires only minimal restructuring and promotion before being loaded to respective applications for delivery. In a global setting, where documentation needs to be simultaneously distributed to a variety of different languages, archival XML source documents can easily be translated by applying translation scripts as well as rendering scripts that can localize formatting attributes based on language-specific requirements. In addition, translation and maintenance costs can be significantly reduced by normalizing content for an international market.

XML Documentation

XML has long been lauded by the publishing industry as a cost-cutting solution to many process-related issues in content production and delivery. Having content converted to XML allows for enhancements in content organization, indexing, linking, storage, reuse and delivery/display. But just having content converted to XML does not allow it to reach its full benefit. XML and its associated technologies call for redesigned workflows to demonstrate their enormous potential. An optimized workflow for content publishers requires minimal process repetition. Once content is delivered, it is edited and converted to XML and stored in a centralized single source repository within the content management architecture. The XML files themselves will be minimally defined (tagged) so as to allow maximum flexibility. This repository now becomes the core storage mechanism for all deliverable content. It is on the delivery side that this process model demonstrates its primary benefits. Storing content in the single source repository transforms exporting the content to different formats and applications for delivery into a primarily automated process. There is no need for additional conversions or edits each time content is to be delivered to a different medium. In addition, any complications that arise will now be instantly recognized as process-oriented rather than data-oriented.

Translation

Legacy translation memory databases attempt to modularize content by segmenting source and translated text and storing it in a searchable database for reuse. Though these partially automated systems have been proven to reduce costs when compared to manual processes, the fact that translation is generally done at the sentence level means that is often taken out of context and therefore often loses its meaning. XML documents, on the other hand, are inherently modular and do not require the extensive parsing applied by traditional translation memory systems. In addition, XML assets can easily be encoded (with metadata, for example) and tracked throughout the translation process, ensuring that it remains closely associated with the contextual information often required by translators. An XML-enabled single source publishing model is designed to leverage content reuse, enabling organizations to save significant time and money through reducing or even eliminating repeated translations. XML gives publishers the ability to conceptually segment content assets for translation purposes, while at the same time keeping them closely tied to context. In the case of document frameworks, such as technical publishing, where text is often repeated in many different places, the ability to consolidate resources offers potentially enormous savings in translation costs alone.

Standards

A growing number of emerging standards are designed to aid in the localization of document frameworks. Methodologies for translation workflows and document exchange are designed to streamline content management architectures for multilingual environments. These include:

  • Translation Memory eXchange (TMX) – a vendor-neutral XML standard for the exchange of translation memory data between tools and/or translation vendors
  • Term Base eXchange (TBX) – an open XML-based standard for exchanging structured terminological data
  • Open Lexicon Interchange Format (OLIF) – an open, XML-compliant standard for the exchange of terminological and lexical data
  • XML Localization Interchange File Format (XLIFF) – an XML-based vocabulary for the exchange of localizable software and document-based objects and related metadata (XLIFF is also represented in the DITA Translation Subcommittee)
  • Translation Web Services (TransWS) – specifies the calls needed to use Web services for the submission and retrieval of files and messages relating to localization projects
  • XML-based Text Memory (xml:tm) – an open XML standard for embedding text memory directly within an XML document using XML namespace syntax

The extensible nature of XML lends itself to the creation of a wide variety of industry specifications, many of which enable businesses to streamline business processes and improving communication.

Formatting

In today’s global marketplace, organizations are often challenged with having to produce content in a variety of different languages. In a traditional documentation workflow model, this is an extremely arduous process. Legacy publishing software such as Quark, PageMaker, FrameMaker, etc. require expensive and resource-intensive desktop publishing and engineering processes for repurposing. In addition, these page layout applications are generally not well suited for delivery to multiple output formats. XML is inherently extensible, offering an infinite number of ways to define and structure markup. This flexibility also enables it to handle arbitrary data structures and convey information for both human users and machines for processing. In addition, XML also provides broad support for Unicode characters, enabling the automation of text normalization processes and making it natively accessible to multilingual environments. An XML documentation framework offers significant productivity enhancements to the localization workflow. The separation of content from structure and appearance that is inherent to XML gives companies the ability to translate text while at the same time maintaining the document structure dictated by an XML Schema or DTD. Any additional formatting that is required can also be simultaneously implemented through the application of XSLT and/or XSL:FO stylesheets.

Altova Tools for XML-based Single Source Publishing in a Global Environment

There are, of course, several different methods for internationalizing content with XML technologies. Included below are just a few of examples of how Altova tools can be used to streamline global publishing workflows. Multiple Output Formats
StyleVision is a graphical stylesheet design tool that enables users to create one design for simultaneous output to HTML, RTF, PDF, Word 2007 (OOXML), and Authentic electronic forms. stylesheet_designer Language-specific Stylesheets
StyleVision also supports user-defined parameters that allow designers to maintain the modularity of their XML assets through the application of variables. This enables publishers to add unlimited new languages to their documentation by importing language-specific stylesheets and leaving XML content untouched. Design Overview Of course, this approach to multi-lingual publishing can lead to the creation of an enormous number of stylesheets that are increasingly difficult to maintain. SchemaAgent, Altova’s XML-based file management system offers advanced support for managing XSLT (as well as XML Schema and WSDL) document relationships in a large publishing environment. xslt_component  XSL Lang() Function
StyleVision also supports the XSL lang() function, which pulls the correct translation from XML source document(s) based on the xml:lang attribute. In this scenario, the translations could be stored together in one XML instance as specified in the xml:tm standard, or stored separately in language-specific directories. Properties WYSIWYG Authoring Tool
Authentic gives content contributors the opportunity to edit XML directly through e-Forms based on the stylesheet design created in StyleVision. Authentic is available through a free license so that it can be deployed to an unlimited amount of users without increasing costs. This enables translators to work directly with XML, rather than having it transposed at a later date for publishing. Authentic e-Forms tool Authentic also includes a multi-lingual spell-checker that references built-in dictionaries in 18 different languages and vocabularies, allowing writers and translators to ensure the accuracy of their work. Spelling options

Conclusion

Single source publishing calls for the creation of a centralized store of content that can be accessed, reused, and deployed to a variety of different mediums. This enables the integrity of the content to be maintained throughout an infinite number of iterations. In a large documentation localization pool, the ability to adapt to different language and formatting requirements provides significant business advantages. There are several different approaches to maintaining single source content for a global audience. A careful and informed approach to preparing and storing content assets can ensure a variety of benefits including increased quality and consistency, reduction of translation costs, and increased longevity of translation investments. In addition, the XML-enabled single source publishing model facilitates document repurposing for delivery to a variety of different formats, making it accessible to end-users in HTML, RTF, PDF, Word 2007 (OOXML), etc. Incorporating this system within organizations documentation workflow processes enables the presentation accurate, consistent, and standardized information. XSL transformations apply format-specific processing instructions while ensuring that document content and structure remain intact. Migrating content to XML-based single source publication workflows requires some initial planning and technology investment, but the rewards are numerous. Cost reductions in translation and type-setting, faster time-to-market, and the ability to adapt to new language and data structures requirements in the future make the relatively small investment worthwhile. Discover how single source publishing can optimize your global documentation workflows with a free trial of StyleVision.  Please note that StyleVision and the other products mentioned above are available as part of Altova’s software bundle, MissionKit, which offers XML and data management tools for distributed publishing environments.   This technical brief and other resources are available in the Altova Library.

Tags: , , , ,

White Paper: Reaping the Benefits of pureXML with Altova Tools


The IBM® DB2® data server offers a scalable and reliable information infrastructure that provides seamless integration of XML and relational services. Now with the deep integration of Altova tools and DB2 9, users can query, exchange, transform, and edit their XML artifacts more quickly, easily, and accurately.
Demonstrated using an online brokerage scenario, this white paper shows how the integration of Altova tools with DB2 allows users to:

  • Design and perfect XQuery statements faster, with real-time validation for a faster and more robust design time experience.
  • Preview, edit, and validate XML data stored in the database with just a few clicks
  • Easily manage XML Schemas in the DB2 9 Schema Repository
  • Map XML data from the database to a CSV file or convert it to an HTML table or other format

The solutions to the business problems presented in the white paper show how DBAs and developers working with real-world XML applications can benefit from the integration of Altova tools with IBM DB2 9.
Access the white paper here to read more about these solutions and view screenshots: https://www.altova.com/resources_wp.html#ibm_whitepaper

Get more information about using Altova tools when working with IBM DB2 9 pureXML here: https://www.altova.com/IBM_DB2_9_pureXML.html

Download a free 30-day trial of the Altova MissionKit here: https://www.altova.com/download.html, and see how working with XML-related technologies in DB2 9 is enabled by Altova tools.

Tags: , , ,