SQL

Introducing MobileTogether - Build mobile in-house solutions faster

It's about time that I start talking about our next major product here: Altova MobileTogether is an exciting new cross-platform mobile environment that lets you build in-house mobile solutions for your workforce much faster and more productively than any other mobile cross-platform method out there. You can use MobileTogether to bring your in-house data — be it in SQL databases, XML, available as web services, etc. — to your employees on the device of their choice, be it business intelligence dashboards, elegant enterprise forms, or any other business processes from graphs for sales analytics to monitoring of business-critical data.


There are, of course, many ways to develop mobile solutions, and for external customer-facing apps the native platform approach or other multi-platform SDKs may make sense. But for in-house solutions the math just doesn't work. You need to be able to build these in a few days rather than weeks or months in order to stay on budget.


MobileTogether makes this rapid development possible by using a unique system architecture that consists of the following three components:


MobileTogether Designer

MobileTogether Designer is the IDE where you build your mobile solutions. It comes with full database-support for all major database servers as well as the ability to connect to any XML files, web services, HTML pages, or other data sources directly. If that's not enough, you can connect to FlowForce and MapForce server as an interim data transformation platform to get your data from EDI or other formats into XML easily.


Once you've defined your data sources, you then drag & drop UI controls onto your design surface and connect them with the data model. You can build powerful program logic using visual ActionTrees and for data manipulation the full power of XPath and XQuery is at your disposal.

This way you can build a powerful mobile solution in just a few hours and can test it right inside MobileTogether Designer using the built-in simulator that supports the iOS, Android, Windows Phone 8, and Windows 8 look&feel as well as many screen sizes and device options.

We have put together a few video demonstrations that show how easy it is to build a mobile solution with MobileTogether Designer.

MobileTogether Mobile App

Once you are satisfied with the way your mobile solution looks, it is time to get it onto your mobile device. The MobileTogether Mobile App is what runs your solutions on your device, and it is available for free form the respective app stores. The Mobile App is available for iOS, Android, Windows Phone 8, and even desktop Windows 8, so you can deploy your solutions to all mobile workers, no matter if they prefer a smartphone, tablet, or laptop!


Normally the MobileTogether Mobile App connects to a MobileTogether Server (see below), but for an initial trial run, you can simply connect the MobileTogether Mobile App directly to your MobileTogether Designer. Instead of starting the simulator in the designer, you select "Trial Run on Client" from the toolbar, and then you can see your mobile solution on your device and test it there, provided your mobile device is on the same local network as the computer where you are running MobileTogether Designer.

MobileTogether Server

Once you're ready to deploy your solution to your entire workforce, it is time to install and configure MobileTogether Server. This server acts as a conduit between your mobile clients and your database servers and other data sources in your IT infrastructure.


If you only want your mobile solutions to be available while the mobile devices are connected to your corporate Wi-Fi network, then it is sufficient to install the server in-house and your employees can immediately run your mobile solutions, once you've deployed them from the Designer to the Server.

If you want your employees to also be able to access your solutions while you are on the road, you will need to designate and open a port in your firewall so that the client devices can reach your server from the public Internet when they are traveling. We recommend installing an SSL certificate for that purpose so that the data connection between the clients and your MobileTogether Server is encrypted. In addition, we recommend securing the MobileTogether server with user authentication. You can choose between built-in user management, or the MobileTogether server can talk to your Active Directory server to integrate with your enterprise user management.

Alternatively, you can also install MobileTogether Server into a private cloud with a cloud provider of your choice, if you prefer to have your server running in a cloud rather than on your on-premises infrastructure.

Timeline

In May this year we first introduced Altova MobileTogether at TechEd in Houston, TX. In July we launched beta 1 of the MobileTogether Designer. In August we launched the beta 1 version of all the MobileTogether clients in the respective App Stores. And last week we launched beta 2 of MobileTogether Designer, Server, and the Apps. We expect MobileTogether to be commercially available later this fall.

Getting Started

You are invited to participate in the beta 2 and try it for yourself.


Just download the MobileTogether Designer from our website, download the MobileTogether Client from the App Store on your device, and you can be up and running and have your first solution on your device in 1-2 hours. Then, when you want to scale out to have your colleagues run it on their devices, you can download MobileTogether Server so that others can connect to it.

Altova MissionKit 2013

Just in case you missed these announcements last month, here is a quick recap of some of our blog posts about the new major features in the Altova MissionKit 2013:

But there is so much more included in version 2013 of the various developer tools across the entire MissionKit tools suite in terms of new features that we added in direct response to customer feedback:

  • Seamless integration options in Java applications for XMLSpy, MapForce, StyleVision, Authentic
  • Support for embedded XML Schemas in WSDL files
  • Enhanced WSDL documentation options
  • Flexible integration of external programs into XMLSpy
  • Support for CamelCase words in spell checker
  • Option to strip unnecessary whitespace
  • Support for Team Foundation Server MSSCCI Provider for version control systems
  • Table row and column conditions
  • XPath Evaluator extension of XPath Builder
  • Integration with Eclipse 4.2 (adds to support for earlier versions)
  • Support for US GAAP 2012 XBRL taxonomy (adds to support for earlier versions)
  • Support for UML 2.4
  • Support for SysML 1.2
  • Support for displaying .NET properties as UML associations
  • Spell checker for UML model components
  • Print results of directory comparisons in DiffDog
  • Significant performance improvements in DiffDog
  • Authentic browser plug-in for Google Chrome
  • Authentic push installer for browser plug-ins

More information on all of these new features can be found on our "What's New" page…

Using Altova tools for Cloud Computing

Obviously, cloud computing is one of the major trends of 2010 and continues to excite people. We just posted a brand new detailed article on the Altova Blog about XML in the Cloud that shows how to use DatabaseSpy, MapForce, XMLSpy, and StyleVision to work with an Amazon Relational Database Service (Amazon RDS) instance in the cloud.

Essentially the Amazon RDS is a big MySQL database in the cloud, so you can use the Data Source connection wizard in all Altova tools to easily connect with the cloud instance, just like you would connect with a local instance of MySQL:

Similarly, in a previous post last summer we showed you how to configure Altova tools to work with a SQL Server Azure instance, if you prefer the Microsoft cloud computing platform. And in another post we showed you in detail how to work with XML data in SQL Server Azure.

Check out all three articles and see how easy it is to use Altova tools not just for your enterprise in-house or classic web development projects, but also for your cloud computing projects!

Database Diff: Compare and Merge

When I mentioned our v2009 product launch before, I promised to write in more detail about some of the exciting new features we included. One of my favorite new functions that I use almost on a daily basis is actually available in two products, depending on your needs: it is the new database differencing module with full database compare and merge capabilities in both DiffDog 2009 and DatabaseSpy 2009.

Here is how it works: to compare data between different tables you select one or more tables for the "left side" of the comparison and one or more tables for the "right side":

However, unlike straight text file comparisons, where the differencing process would now start right away, for databases we recognize that the table structure is rarely the exact same, because you typically want to compare data between different servers (such as production vs. development) and one may have new columns, indexes, and the like.

So we give you the ability to define in detail how the tables should be compared. The system is, of course, intelligent enough to automatically match column names that just differ by capitalization or column position, but you can visually create a comparison map to match up other columns with this easy-to-use interface:

Once you run the differencing operation based on the comparison map you've defined, the result is displayed in this unique and intuitive table diff result view:

This view gives you the option to show or hide columns that exist in one database only, identical columns, as well as hiding rows that are completely equal or rows that exist only in the database on the left or the right. This allows you to drill down into those differences that you consider essential.

In addition to finding these differences, we do, of course, also allow you to complete the data migration and reconcile those differences:

You can choose to either merge data from left to right, right to left, or you can create a SQL script for manual review that will contain all the commands necessary to compete the merge operation (DatabaseSpy only):

If you are concerned about keeping a record of the data before the merge, you can even create a restore script for either database that lets you revert the changes made by the merge script if you ever need to do that (DatabaseSpy only).

The database diff feature supports any of the following database server platforms:

  • Microsoft® SQL Server® 2000, 2005, 2008
  • Oracle® 9i, 10g, 11g
  • Sybase® 12
  • MySQL® 4, 5
  • PostgreSQL 8
  • IBM DB2® 8, 9; IBM DB2 for iSeries® v5.4; IBM DB2 for zSeries® 8, 9
  • Microsoft Access™ 2003, 2007

And the coolest thing is that you can compare tables between connections to different database servers, which makes it an excellent tool for supporting a migration from one server platform to another that lets you verify that all data was moved properly.

As always, you can download a fully functional 30-day free trial to test this new feature yourself...