CPYDB Features
Features
|
CPYDB seamlessly replicates AS/400 physical and logical files to MS SQL Server, Oracle, MS Access, MS Excel and importable flat files at high speed. Replicated data provides local and remote end-users fast and simple access to their information without consuming AS/400 resources. |
Quick Links |
|
|
|
With an amazing data replication speed, CPYDB is significantly faster than any alternative product. CPYDB also features direct TCP/IP connectivity, eliminating the need and associated costs of installing a gateway.
CPYDB’s ease-of-use is made possible by its close
resemblance to the AS/400 Copy File (CPYF) command,
already familiar to most AS/400 administrators.
CPYDB
uses the same syntax and has the same features as the AS/400 Copy File (CPYF)
command. As most AS/400 administrators and programmers are familiar with
CPYF, no training is required to use CPYDB.
CPYDB
uses the same syntax and has the same features as the AS/400 Copy File (CPYF)
command. As most AS/400 administrators and programmers are familiar with
CPYF, no training is required to use CPYDB.
CPYDB can replicate any AS/400 physical or logical file having a Data Description Specification (DDS). CPYDB’s ability to replicate logical files is particularly powerful. First, inherent AS/400 capabilities may be used for high-speed row and field data selection.
Second,
multiple AS/400 files may be logically joined together constructing a
single SQL or Oracle Server table containing the information most suitable
for the end-user, or for their Microsoft Excel, Access, Word or other
applications.
CPYDB's ability to convert 6 character AS/400 field names to database friendly ones is highlighted by how easy it is to implement. Alias names may be automatically taken from either the field's DDS column headings or description. The user may even decide to create logical files just for this purpose. Such files have no impact on system performance if index update is deferred till file open.