Software Product Description ___________________________________________________________________ PRODUCT NAME: DEC DB Integrator Gateway SPD 47.35.04 for SYBASE[R], Version 3.1A DESCRIPTION DEC DB Integrator Gateway for SYBASE (SYBASE Gateway) provides appli- cations and tools with direct, read/write access to SYBASE SQL Server databases. This access can be via interactive or dynamic SQL inter- faces. Client/server access is enabled by drivers for Microsoft[R] Open Database Connectivity (ODBC) applications. Optional support for em- bedded SQL and SQL module language programming is available. DEC DB Integrator (DBI) extends the functionality of the SYBASE Gate- way by providing a native integration of SYBASE databases with data sources accessed by other DB Integrator gateways. DBI clients may di- rectly access and join views of tables existing on multiple databases. These views may be horizontally or vertically partitioned and be based on tables existing on any database accessible by DB Integrator gate- ways. These DBI views may be pre-defined or dynamically declared. DBI servers maintain a persistent catalog of metadata extracted from SYBASE databases. DBI uses this metadata along with information on net- work and underlying database manager capabilities to optimize cross- database joins. The SYBASE Gateway is available on the Digital UNIX[R] Operating Sys- tem on AXP systems, workstations and servers and on the OpenVMS Op- erating System on Digital AXP and VAX systems, workstations and servers. Features Standard SQL Interfaces DIGITAL July 1995 AE-Q2BCE-TE DEC DB Integrator Gateway SPD 47.35.04 for SYBASE[R], Version 3.1A The SYBASE Gateway provides direct, read/write access to SYBASE SQL Server databases through standard DEC SQL interfaces. These interfaces include a dynamic SQL interface, an interactive SQL facility and the SQL/Services server. SQL data manipulation language (DML) is fully supported. SQL data def- inition language (DDL) support is limited to operations required to create and maintain tables and indexes and to grant and revoke access to database objects. The dynamic SQL interface compiles and executes SQL requests passed through its call interface. This programming approach is highly ef- fective in applications such as ad-hoc query access where the exact parameters of requests are not known until runtime. It is compatible with any programming language that supports the host operating sys- tem calling standards. The dynamic memory handling capabilities of Ada, C and PL/I enable these languages to take full advantage of the power and flexibility of this approach. The interactive SQL facility supports interactive query and update of data and management of table and view metadata in SYBASE SQL Server databases. All data format translations are performed automatically by the SYBASE Gateway as part of handling requests to read and update data. Desktop Connectivity The SYBASE Gateway includes ODBC drivers for Microsoft Windows[TM] and Windows NT[TM]. These drivers enable read/write access to databases via SYBASE servers over DECnet, TCP/IP and Novell[R] NetWare[R] (IPX /SPX) transports. Network transport alternatives depend on the selected desktop and SYBASE Gateway platforms. [1] Distributed Data Access The SYBASE Gateway supports access from remote clients and to remote SYBASE SQL Server databases. ____________________ [1] ODBC client access via the Novell NetWare (IPX/SPX) transport is sup- ported only by SYBASE Gateways running on OpenVMS VAX platforms 2 DEC DB Integrator Gateway SPD 47.35.04 for SYBASE[R], Version 3.1A Performance The SYBASE Gateway selects access strategies that minimize data trans- fer activity. Wherever possible, selection, filtering, and statisti- cal operations are done by the SYBASE SQL Server RDBMS. A log of com- munications activity and errors may be maintained to assist in prob- lem isolation and evaluation. Disk Space Requirements Table 1 lists the disk space required to install and operate SYBASE Gateway software by hardware/operating system platform (Platform). The common requirement represents the space required to store software ob- jects that are common to DBI and the DB Integrator family of gateways. If one of these products is already installed on the system or clus- ter, the permanent disk space requirement will be decreased by this amount. ___________________________________________________________________ Table_1:__Disk_Space_Requirements_by_Platform______________________ Disk Space Required (512 Byte Blocks) Platform_______Install_____Permanent____Common_____________________ OpenVMS VAX 50,000 40,000 30,000 OpenVMS AXP 66,000 56,000 42,000 Digital_UNIX___79,260______79,260_______73,260_____________________ These counts refer to the disk space required on the system disk. The sizes are approximate; actual sizes may vary depending on the user's system environment, configuration, and software options selected. Additional space must be allowed for programs, logs, temporary database cache files and user interface software. 3 DEC DB Integrator Gateway SPD 47.35.04 for SYBASE[R], Version 3.1A SOFTWARE REQUIREMENTS SYBASE Gateway for OpenVMS VAX Software Requirements o OpenVMS VAX Operating System V5.5-2 - V6.2 o SYBASE[R] Open Client, Release 4.6.1 or 4.6.2 o SYBASE SQL Server, Release 4.8 - System 10 Network Transport Options The SYBASE Gateway for the OpenVMS VAX platform will require one or more of the following network software products to support direct ac- cess to local and remote databases by client applications. o DECnet transport - DECnet for OpenVMS VAX, V5.5-2 - V6.2 o TCP/IP transport - DEC TCP/IP Services for OpenVMS VAX, V3.0 - V3.1 o Novell NetWare - SQL/Services and DEC ODBC Driver client applica- tions communicating via Novell NetWare require a Novell IPX/SPX trans- port - InterConnections Leverage for NetWare File Sharing Services (FSS), V1.5 - V2.0 SYBASE Gateway for OpenVMS AXP Software Requirements o OpenVMS AXP Operating System, V6.1-V6.2 o SYBASE[R] Open Client, Release 4.6.2 o SYBASE SQL Server, Release 4.8 - System 10 Network Transport Options The SYBASE Gateway for the OpenVMS AXP platform will require one or more of the following network software products to support direct ac- cess to local and remote databases by client applications. o DECnet transport - DECnet for OpenVMS AXP, V6.1 - V6.2 4 DEC DB Integrator Gateway SPD 47.35.04 for SYBASE[R], Version 3.1A o TCP/IP transport - DEC TCP/IP Services for OpenVMS AXP, V3.0 - V3.1 SYBASE Gateway for Digital UNIX AXP Software Requirements o Digital UNIX Operating System V3.0, V3.2 o SYBASE Open Client, Release 10 o SYBASE SQL Server, Release 10 Network Transport Options The SYBASE Gateway for Digital UNIX will require one or more of the following network software products to support direct access to lo- cal and remote databases by client applications. o DECnet transport - DECnet/OSI, Version 2.0, for Digital UNIX o TCP/IP transport - Included with the Digital UNIX Operating Sys- tem ORDERING INFORMATION DEC DB Integrator for SYBASE for OpenVMS VAX Traditional Software Licenses: QL-0U4A*-** Concurrent Use Licenses: QL-0U4AA-3* Software Documentation: QA-0U4AA-GZ Software Product Services: QT-0U4A*-** Software Media: QA-0U4**-H* (TK, Mag Tape, CD) Software Media: QA-VWJ8A-H8 (Consolidated CD) DEC DB Integrator for SYBASE for OpenVMS AXP Traditional Software Licenses: QL-0U5A*-** Concurrent Use Licenses: QL-0U4AA-3* Software Documentation: QA-0U4AA-GZ Software Product Services: QT-0U5A*-** Software Media: QA-0U5**-H* (CD-ROM) Software Media: QA-03XAA-H8 (Consolidated CD) 5 DEC DB Integrator Gateway SPD 47.35.04 for SYBASE[R], Version 3.1A DEC DB Integrator for SYBASE for Digital UNIX Traditional Software Licenses: QL-2RZA*-** Concurrent Use Software Licenses: QL-2RZAM-3* Software Documentation: QA-0U4AA-GZ Software Product Services: QT-2RZA*-** Software Media: QA-2RZ**-H* (CD-ROM) Software Media: QA-054AA-H8 (Consolidated CD) * Denotes variant fields. For additional information on available li- censes, services, and media, refer to the appropriate price book. 6