xPort for AREV (Advanced Revelation)

xPort for AREV

This package transfers data from your Advanced Revelation database quickly and completely. Click here to download and try the software or purchase a license key.

xPort provides you with the tools required to analyze and transfer data to common ASCII, TXT, CSV, DIF, DBF (dBase) and XML formats. Prototype DML and control files can be generated to facilitate loading to database platforms such as MS-Access, MS-Excel, MS-SQL Server, Oracle, IBM DB2 and others.

Revelation knowledge is helpful but not essential to use our software. Our expert services are available to help you migrate your complex applications when needed.

AREVGateway is an add-on package that enables real-time replication of AREV data to any SQL-compliant database. It is comprised of an AREV MFS trigger which creates XML documents based on specified field mapping and groups. These documents are then immediately processed by a Windows service to simultaneously update any number of databases. AREVGateway also provides SMTP e-mail output with attachments which is entirely controlled from AREV. Please contact us for details.

xPort Features:

  • Fully supports all versions of Advanced Revelation including AREV32,
  • Access to OpenInsight databases is via Advanced Revelation,
  • Unlimited output file and record sizes,
  • Exports stored and calculated (symbolic) values,
  • Normalizes (explodes) multi-valued fields,
  • All tools are executable as commands from TCL or from within AREV applications
  • API available for custom projects

Data Export Tools:

  • Includes a data mining function to determine which information should be exported,
  • Auditor report highlights potential data integrity and dictionary problems before exporting,
  • Auditor expands export field size definitions to eliminate data loss,
  • Provides simple field selection and formatting tools,
  • Generates special spacing, counting and constant fields,
  • Formats all dates to a selected format,
  • Data filtering option eliminates invalid characters found during export,
  • Export options and parameters are saved as reusable templates,
  • Normalizer utility provides statistics to decipher a file.

Output Capabilities

  • Auditor produces detailed record layout and content statistics in an ASCII text file,
  • Standard fixed-length ASCII text files,
  • Exports variable DIF/CSV (delimited) files with fieldname header option,
  • Comprehensive DBF (Dbase III Plus) format including memo fields,
  • XML entities (within ASCII files) with automated DTD file based on schemas
  • Tab-delimited ASCII files with create table scripts and bulk loader format files for MS-SQL,
  • ASCII or XML format with create table scripts and SQL*Loader control file for Oracle,

.