Integrating XML Documents
Data can be imported into QAD Enterprise Edition from an external customer system in a number of ways:
• Using DatasSync. DataSync synchronizes static data such as item master data among multiple, distributed databases. The data fields and the specific records to be updated are specified in a synchronization profile. DataSync does not synchronize transaction data or entire databases.
The data, as documents, is exported from and imported to each database using Q/LinQ. See External Interface Guide: Q/LinQ for a complete discussion of importing and exporting documents with Q/LinQ.
• In Excel files, using the Excel integration function available for many components. This function is mainly used for static components, such as GL accounts or cost centers (but can also be used for journal entries).
The Excel integration function lets you export existing static components to an Excel spreadsheet. You use the spreadsheet as a template in which to enter new data, and re-import the data as new data objects. This function is described in User Guide: QAD Financials.
• As XML files, using the XML Daemon or QXtend Inbound functions. This technique is mainly used for dynamic components, such as transactions.
The Excel and XML-based functions convert the imported file to an Enterprise Application business object, such as a business relation or customer invoice, which can then be processed by standard Enterprise Financials applications. The imported file must contain essential data and conform to a set file structure in order to be processed successfully as a Financials business object.
Each component has an XML schema file, which describes the structure of its data. The structure of XML documents must conform to the schema file of the business component to which they will be converted. You must therefore prepare your document carefully before beginning the integration process.