Data Import and Export
Memex Patriarch is capable of importing data from a variety of sources. This allows our clients to retain their incumbent systems without the need to invest time and resources transferring or replicating data into Memex systems.
The Memex XML-based Generic Data Loader enables users to extract data from their organization’s native data sources and transform it into a format that can be imported into the Memex system. The Data Loader is primarily used to bulk-load extremely large quantities of data into a Memex system on a periodic basis. This could be once an hour, once a day, or once a week, and is entirely dependent on the organization’s requirements for non-dynamic data updates.
The Data Loader uses the industry-recognized XML format, so there is no need to understand the complexities of importing data in a Memex format- the Data Loader performs the necessary conversions. It can create, delete and move Memex databases; and append, delete and edit records from the Memex databases. By submitting XML files in conformance with published schemas, then, an organization can use any data source available it.
When there is an obvious need to continuously stream data into a Memex system, a SOAP interface is required, a module which streams individual records into the system. Uniquely, this allows Memex to create a real-time environment where data appears as soon as it is entered into any of the integrated system databases. This is a powerful capability which ensures that whenever a user performs a search for data, they can be sure they are viewing results generated from live information.
Memex Patriarch can also export data to a variety of sources, allowing that data to be shared with third parties. To do this, Memex uses simple flat and XML files. By default, the files are exported in a CSV format, but the file format can be also be configured to meet specific client needs. The XML files are exported to a schema specified by Memex, and the export generates schema files to accompany the data exported in XML format. This process is utilized to allow large quantities of data to be “dumped” from the system.
