Visual Integrator has been designed to facilitate seamless integration between BEST MAS 90/200 data and other business applications. Visual Integrator can import from (or export to) any ODBC compliant source, without the need for an intermediary data file such as ASCII delimited or Microsoft Excel. If you regularly perform imports from a custom or vertical software package, you’ll find you can use Visual Integrator to make the integration virtually seamless.

Importing and exporting data from Visual Integrator is a simple process. The power of Visual Integrator, however, lies in the additional integration commands that are available. For example, Visual Integrator jobs can be scheduled to run at prescribed intervals of any length. If you need to keep your MAS 90/200 Customer Master File synchronized with a prospect database, you can set the import to run automatically every day, every hour, or even every minute. Imports can be chained together so that an invoice import automatically follows a customer import. You can even instruct the program to run a script file automatically upon successful completion of an import. If you use MAS 90/200, Visual Integrator is what you need to tie all your business software into one seamless application.

Scheduling: There are multiple methods of scheduling Visual Integrator jobs. You can place a job on the Integrator job menu for easy access, and then run the job manually. Jobs can also be run from the MAS 90/200 custom reports menu, or by using the Windows 95, Windows 98 or Windows NT scheduler or an external Windows program or script file. You can also set a schedule or cycle within Visual Integrator: run once a day, run once an hour, or run once a minute, for example.

Automatically Perform Subroutines: Run additional commands, scripts, or other functions based on three events: before job start, on job success, or on job failure. Subroutines can also be added before and after each record write, before and after assigning data fields.

ODBC Connectivity: Link multiple ODBC tables together, and point and click to select fields for importing. Visual Integrator will then automatically generate the SQL statement for import or export, and Visual Integrator permits editing of the SQL statement for advanced users. A test button provides an instant visual check of data to be imported.

User Defined Fields: If you have created user-defined fields in MAS 90 or MAS 200, these fields will appear automatically for selection when Visual Integrator operates on the entity to which they are attached (e.g. customers).

For more information, call our Sales Department and talk to a consultant about whether Visual Integrator can make your business run more efficiently.