|
 |
ViaSQL Transfer |
The ViaSQL TRANSFER feature allows PC-clients or mainframe applications to
seamlessly move data between z/OS or VSE and any LAN DBMS. Use ViaSQL for
bi-directional data transfer to Microsoft SQL Server, Sybase SQL Server or ASE,
Oracle, Informix, and others.
Data may be moved in either direction, entire
tables or subsets of tables may be moved, and the transfer may be repeated
as often as required. The transfer function supports data migration and
staging applications, and can be used in data replication applications.
TRANSFER statements come in two flavors:
|
 |
Bulk Transfer moves data in mass between data sources |
|
|
Template Transfer executes INSERT, UPDATE, or DELETE
statements against a destination table.
|
Transfers may be initiated from front-end tools, PC-based or web-based
client applications, mainframe-based CSAs, or from
SQL Server RPCs.
This flexibility allows transfers to be scheduled and managed in a variety
of ways. The "what" and "where" of the transfer process is specified by a
SQL-like TRANSFER statement that is executed by ViaSQL Gateway. See some
sample Transfer Statements.
In addition, a Windows-based GUI tool called ViaTransit™,
adds the ability to schedule, and monitor transfer operations.
On the mainframe, the ViaSQL Access Server is the other partner in the transfer
operation, and calls either the Legacy Data Server or DB2 as appropriate.
For mainframe data sources not directly supported by ViaSQL, the ViaSQL Access Server
can call customer-written RSPs or XSPs
to participate in the transfer operation.
On the LAN, the ViaSQL Gateway uses any of three APIs to communicate with the LAN DBMS:
|
|
|
|
Open Client |
Sybase |
|
OCI |
Oracle |
|
ODBC |
any DBMS for which a 32-bit ODBC driver is available |
|
