MASTransit Home Page
From time to time, I will be writing a brief article about some professional tools that may give your software support, or professional consulting practice the ‘edge’ over your competition. These articles will introduce you to software and tools that you may never have heard of; however, they are not intended as either a guide as to the specific use of those products, nor a formal endorsement of either the product or its’ developer(s).
MAStransit* is an enhancement for MAS applications developed by Sage Software. The MAStransit module provides the functionality for copying data from a Sage® MAS system to a Microsoft® SQL Server database. Sage® MAS data that has been converted to SQL can integrate with a variety of available and customizable tools designed to report, or perform data mining tasks. In addition SQL data can be easily exported/imported into formats that permit migration of the data for other applications such as QuickBooks.
MAStransit is designed to export MAS data to Microsoft's SQL Server products. MAStransit uses Packages to specify how data should sync. This feature allows for group related data to sync at the same time. MAStransit is designed to support multiple packages, scheduled at the same time or different times. Each package can be configured differently, depending on your needs.
For instance, you can specify a different Sage location, company, and SQL database for each MAStransit package. You can select one or more tables/columns to copy, and change the destination table/column name. Depending on your bandwidth allocation, you can adjust the bulk copy size and the copy timeout.
Got a client who wants the last 15 years of their Sage® MAS data converted to QuickBooks, then this product is just the thing; of course, it isn't going to be as simple as baking a chocolate cake, there is a substantial learning curve to this product, but with study and practice, you can accomplish what otherwise might seem the impossible. This isn't one of those 'few hundred' dollar applications either, you can expect to pay 'in the thousands' for this product, still the same if you plan on providing MAS extraction data services, tools like this warrant such cost.
So if you need to get 'all' of the data out of Sage® MAS for almost any purpose, MAStransit is the tool you have been looking for.
*-MAStransit is a HighTower, Inc. enhancement for Sage MAS applications.