Home > Software > Sage 500 > Modules > Customization > Data Import Manager

Data Import Manager

Easily import data from other applications
With the Data Import Manager, you no longer need to perform software “gymnastics” to get the information you need. By leveraging the strong Sage 500 ERP (formerly Sage MAS 500) tradition as an open ERP platform, the Data Import Manager lets you easily import data from other applications on a one-time or recurring basis.

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 Microsoft 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 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 500 ERP 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 rerun later.
Benefits of Data Import Manager for Sage 500:
  • Import entity or transaction information from a wide variety of formats
  • Built-in defaults for required fields with ability to override
  • Wizard-based interface for simplified data mapping
  • Automated error reporting for invalid data ensuring referential integrity
  • Ability for novice users to run import jobs created by database experts
  • Run imports one time or schedule to run on a regular basis
  • Security to control user access to predefined import job
Data Import Manager
Questions? Please call us at 1-949-583-9500 x2500 or email us at .