With the Data Import Manager, you no longer need to perform software “gymnastics” to get the information you need. By leveraging Sage MAS 500 ERP’s strong tradition as an open ERP platform, the Data Import Manager lets you easily import data from other applications and provides for a seamless migration from Sage MAS 90 or 200.
If you perform imports from a specialized software package, you’ll find you can use Data Import Manager to make the transfer virtually seamless. Importing data using Data Import Manager is a simple process. Built with .NET and SQL Server SSIS technology, this robust database mapping tool includes a simple graphical interface that lets you map data fields and import data directly from sources such as Sage MAS 90 or 200, Microsoft Access, Excel, SQL Server, XML and more.
Yet, the power of the Data Import Manager lies in its additional data controls. For example, if you need to keep your Sage MAS 500 master file synchronized with a prospect database, you can set the import to run automatically every day, every hour, or every minute. You can chain imports together, so that an invoice import automatically follows a customer import. By leveraging the power of database scripting and SQL Server SSIS you can even instruct the program to run a script file automatically before the import, upon successful completion of an import, or after an error occurs. Records with errors are identified and can be corrected and re-run later.
QUICKLINK Click to view PDF (680KB)