viasql technical overview. viaserv, inc. 2 viasql support for s/390 n originally a vse product n...
DESCRIPTION
Viaserv, Inc. 3 Two ViaSQL Offerings n ViaSQL Direct –entry-level –two-tier -- simpler system –web-oriented n ViaSQL Integrator –three-tier -- adds ViaSQL Gateway –supports transfer, CICS clients, RPCs –more configuration and administration optionsTRANSCRIPT
![Page 1: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/1.jpg)
ViaSQL
Technical Overview
![Page 2: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/2.jpg)
Viaserv, Inc. 2
ViaSQL Support for S/390
Originally a VSE product OS/390 version released in 1999 Identical features and functions Same workstation, LAN, server, etc. environments
and tools
![Page 3: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/3.jpg)
Viaserv, Inc. 3
Two ViaSQL Offerings
ViaSQL Direct– entry-level– two-tier -- simpler system– web-oriented
ViaSQL Integrator– three-tier -- adds ViaSQL Gateway– supports transfer, CICS clients, RPCs– more configuration and administration options
![Page 4: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/4.jpg)
Viaserv, Inc. 4
ViaSQL Direct
OS/390
CICS
Legacy Data Server
DB2
VSAM
IMS
Seq.
RSP
Other
ViaSQL Direct
ODBC or JDBC Driver
WebServer
Browser
ViaSQL Direct
ODBC or JDBC Driver
ViaSQLAccess Server
ODBC or JDBCTool
APPC (SNA, LU6.2)
TCP/IP TCP/IP
APPCWeb
![Page 5: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/5.jpg)
Viaserv, Inc. 5
ViaSQL Direct Clients
ODBC v3.5– 32-bit Windows clients (95, 98, NT, 2000)
JDBC v1.0– Java 1.1 and Java 2 platforms– Type 4 driver (written completely in Java)
• runs on Java virtual machines on any platform (OS/390, Windows NT/2000, UNIX)
![Page 6: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/6.jpg)
Viaserv, Inc. 6
ViaSQL Direct Data Sources
Dynamic SQL access to DB2– SELECT, INSERT, UPDATE, DELETE– GRANT/REVOKE/etc.
Programmatic access through RSPs– all data sources accessible from CICS region
Dynamic SQL access via Legacy Data Server– VSAM, IMS, sequential (Datacom coming soon)
![Page 7: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/7.jpg)
Viaserv, Inc. 7
ViaSQL Direct Functions
Execute any SQL allowed by site– SELECT results returned as relational result sets in ODBC
datatypes Execute any Remote Stored Procedure (RSP)
– may return result sets or messages MS-SQL Server 7 Linked Server connection
– Remote Procedure call (rpc): SQL, RSP (no Transfer)– Distributed Queries– Passthrough queries (Openquery method)– Data Transformation Services (DTS)
![Page 8: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/8.jpg)
Viaserv, Inc. 8
Remote Stored Procedures (RSPs) Customer-written CICS program called by the ViaSQL
Access Server Uses
– business logic– data access logic– static access to DB2– access to data sources not supported by Legacy Data Server
![Page 9: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/9.jpg)
Viaserv, Inc. 9
ViaSQL Direct Uses
Simple desktop access Simple laptop access Web / Application Server access MS SQL Server 7 access / integration
![Page 10: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/10.jpg)
Viaserv, Inc. 10
Web Architectures — LAN
OS/390
CICS
Legacy Data Server
DB2
VSAM
IMS
Seq.
RSP
Other
WebServer
Browser
ViaSQL Direct
ODBC or JDBC Driver
ViaSQLAccess ServerTCP/IP
APPCWeb
![Page 11: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/11.jpg)
Viaserv, Inc. 11
Web Architectures — OS/390
OS/390
CICS
Legacy Data Server
DB2
VSAM
IMS
Seq.
RSP
Other
Browser
IBM WebSphereApplication
Server
ViaSQL Direct
JDBC Driver
ViaSQLAccess Server
Web
![Page 12: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/12.jpg)
Viaserv, Inc. 12
ViaSQL Integrator
OS/390
CICS
Legacy Data Server
DB2
VSAM
IMS
Seq.
RSP
Other
Browser
WebServer
Viaserv ODBC Driver
ViaSQLAccess ServerTCP/IP
APPC
Web
Viaserv ODBC Driver
ODBC Tool
Open Client
ViaSQL Gateway
Open Server
Windows NT/2000
Open ClientTool
Open Client
Standard Network Connectivity
![Page 13: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/13.jpg)
Viaserv, Inc. 13
ViaSQL Integrator Clients
ODBC– uses Viaserv ODBC driver (not ViaSQL Direct ODBC Driver)– 32-bit Windows clients (95, 98, NT, 2000)– ODBC v3.5– requires underlying Open Client installation (converts ODBC to
Open Client) Open Client v.10.4 and later
– v.11.1.1 recommended– shipped with ViaSQL Integrator on Gateway CD
![Page 14: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/14.jpg)
Viaserv, Inc. 14
ViaSQL Integrator Data Sources
Dynamic SQL access to DB2– SELECT, INSERT, UPDATE, DELETE– GRANT/REVOKE/etc.
Programmatic access through RSPs– all data sources accessible from CICS region
Dynamic SQL access via Legacy Data Server– VSAM, IMS, sequential (Datacom coming soon)
![Page 15: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/15.jpg)
Viaserv, Inc. 15
ViaSQL Integrator Functions
Execute any SQL allowed by site– SELECT results returned as relational result sets in ODBC
or Open Client datatypes Execute any RSPs Transfers Client Services Applications (CSAs)
– CICS client access to LAN databases Sybase ASE / MS SQL Server 7 integration
– Distributed queries (ASE 11.5 or later)– Remote Procedure call (rpc): SQL, RSP, Transfer
![Page 16: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/16.jpg)
Viaserv, Inc. 16
The ViaSQL Transfer
Move data between OS/390 and a LAN database– Sybase, MS SQL Server, Oracle, ODBC– either direction– one-step data extraction, movement, format, load
Useful for data staging, reporting databases, data warehousing, data migration
ViaTransit utility– transfer building– transfer scheduling and automatic execution– pre- and post-transfer processing
![Page 17: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/17.jpg)
Viaserv, Inc. 17
Client Services Applications (CSAs) CICS client access to LAN database
– Sybase, MS SQL Server, Oracle, ODBC– execute SQL or stored procedure– results returned to CICS program– useful for data synchronization
CICS client access to ViaSQL Gateway– execute a transfer– useful for distributed sites with host-managed systems
![Page 18: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/18.jpg)
Viaserv, Inc. 18
Remote Procedure Calls (RPCs)
DBMS client access to OS/390– MS SQL Server (linked server connection)
• Uses ODBC connection (ViaSQL Direct or ViaSQL Integrator)– Sybase server to server connection
• Uses ODBC connection to ViaSQL Gateway (ViaSQL Integrator)– Oracle (Java or external procedure)
Application options– User perspective - single data source (transparent access)– Dynamic SQL or Stored procedures / Triggers
Useful for data synchronization
![Page 19: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/19.jpg)
Viaserv, Inc. 19
Hybrid Environments
ViaSQL Direct components shipped with ViaSQL Integrator
Hybrid environments supported– single ViaSQL Access Server transaction supports access from
both ViaSQL Direct ODBC Driver and ViaSQL Gateway– Legacy Data Server and RSPs never know
![Page 20: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/20.jpg)
Viaserv, Inc. 20
The ViaSQL Configurator — 1Required ComponentsFunction ViaSQL SystemOS/390 Server Administrator
WorkstationClient
ViaSQL Direct ViaSQL Access Server ViaSQL Direct ODBC DriverViaSQL Direct JDBC Driver
Dynamic SQL access to DB2
ViaSQL Integrator ViaSQL Access Server ViaSQL Gateway Open ClientViaserv ODBC Driver (optional)
ViaSQL Direct ViaSQL Access ServerLegacy Data Server
Legacy DataManager
ViaSQL Direct ODBC DriverViaSQL Direct JDBC Driver
Dynamic SQL access to VSAM orsequential data
ViaSQL Integrator ViaSQL Access ServerLegacy Data Server
ViaSQL Gateway Legacy DataManager
Open ClientViaserv ODBC Driver (optional)
ViaSQL Direct ViaSQL Access ServerLegacy Data ServerIMS Interface
Legacy DataManager
ViaSQL Direct ODBC DriverViaSQL Direct JDBC Driver
Dynamic SQL access to IMS
ViaSQL Integrator ViaSQL Access ServerLegacy Data ServerIMS Interface
ViaSQL Gateway Legacy DataManager
Open ClientViaserv ODBC Driver (optional)
![Page 21: ViaSQL Technical Overview. Viaserv, Inc. 2 ViaSQL Support for S/390 n Originally a VSE product n OS/390 version released in 1999 n Identical features](https://reader035.vdocuments.us/reader035/viewer/2022062302/5a4d1b2f7f8b9ab05999a4da/html5/thumbnails/21.jpg)
Viaserv, Inc. 21
Required ComponentsFunction ViaSQLSystem OS/390 Server Administrator
WorkstationClient
ViaSQL Direct ViaSQL Access Server ViaSQL Direct ODBC DriverViaSQL Direct JDBC Driver
Programmatic access (RSP) to allOS/390 data sources
ViaSQL Integrator ViaSQL Access Server ViaSQL Gateway Open ClientViaserv ODBC Driver(optional)
Transfer ViaSQL Integrator ViaSQL Access Server ViaSQL Gateway
Automated transfer preparationand execution
ViaSQL Integrator ViaSQL Access Server ViaSQL GatewayViaTransit TransferServer
ViaTransit TransferManager
OS/390 client access (CSA) toLAN
ViaSQL Integrator ViaSQL Access Server ViaSQL CSA Server
The ViaSQL Configurator — 2