How Data Loaders Interact with QAD

Our software is completely safe to use with QAD because we use genuine QAD business logic to perform tasks. Data Loaders provide regular Excel template files equipped with VBA macros which are connected to built-in action buttons.

These action buttons allow users to download data from QAD, work with the data easily in Excel, and then quickly and without IT help, upload modified data back to QAD.

When a user clicks on an action button, it creates a programming call through a TCP/IP connection to the QAD server where Data Loaders run a multi-thread Java listener. This listener launches a native progress 4GL session containing 32 Soft’s code which executes standard QAD programming.

When a user clicks the DOWNLOAD or DRILL DOWN buttons, Data Loaders progress program uses QAD programming to extract the data and re-direct the output to the Excel window.

When a user clicks on the LOAD button, Data Loaders scans the Excel data and validates it using genuine QAD logic. If an error is found in the data, cells with errors are instantly highlighted, so the user can quickly identify and correct any problems and then simply click the LOAD button again.

Our program will then launch a QAD program and load the clean data using a CIM load mechanism in the background. That means your Excel data is automatically entered into QAD just as if it had been manually keyed in. Once your data is sent to QAD, the output records will again be read prior to the final upload to ensure there are no errors. If errors are found, an error report will be generated and the upload will be terminated. This ensures that only error-free records are loaded and no partial upload of batched records ever occurs.

Data Loaders have layers of validation built right in
You know your data is correct and safe with Data Loaders. Along with pre-loaded genuine QAD logic validation and additional specific validation like numeric fields, text length, etc., we can add any needed client-specific validation. And, there’s QAD maintenance program validation as well as after-load validation that analyzes how the QAD program accepted the input stream. No partial upload is ever allowed. Data Loaders make sure only the good stuff gets loaded, producing the results you want.

Plus, with 3 levels of QAD security—credentials, user group access to QAD menus, and site/entity security—Data Loaders are 100% SOX compliant.

Join our mailing list
to stay informed about our solutions