Software Product Description ___________________________________________________________________ PRODUCT NAME: DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A DESCRIPTION DEC DB Integrator Gateway for PC Data (PC Data Gateway) provides ap- plications and tools with direct, read/write access to data sources which support a Microsoft[TM] Open Database Connectivity (ODBC) in- terface. The PC Data Gateway works with ODBC Data Drivers which meet the following standard conformance levels: ODBC API (Level 1) ODBC SQL Grammer (minimum) The PC Data Gateway includes the Microsoft ODBC Pack 2 files which in- cludes an ODBC administrator, ODBC Driver manager, and ODBC Drivers for the following data sources: Microsoft ACCESS Microsoft Excel Microsoft FoxPro Microsoft SQL Server Borland dBase[TM] Borland Paradox[R] Btrieve text files The PC Data Gateway is available on Digital UNIX and OpenVMS Alpha and VAX. The client software is installed on these platforms and the server software runs on Windows 3.1, Windows 95, and Windows NT platforms. The PC Data Gateway can be used to provide remote access to PC Data sources from Digital UNIX and OpenVMS platforms. Remote client access DIGITAL September 1995 AE-QQDHA-TE DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A is also available through SQL/Services and ODBC drivers which are in- cluded as part of the DB Integrator Gateway. (See Desktop Client Soft- ware section for a complete list of remote clients supported by the PC Data Gateway.) DEC DB Integrator (DBI) extends the functionality of the PC Data Gate- way by providing a native integration of databases accessed by PC Data Gateways and other DB Integrator gateways. DBI clients may directly 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 these gateways. DBI views may be pre-defined or dynamically declared. DBI servers maintain a persistent catalog of metadata extracted from databases served by PC Data servers. DBI uses this metadata along with information on network and underlying database manager capabilities to optimize cross-database joins. Features Standard SQL Interfaces The PC Data Gateway provides direct, read/write access to PC Data data sources 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) is not supported. 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 operating system's call- ing standards. The dynamic memory handling capabilities of Ada, C and P/I enable these languages to take full advantage of the power and flex- ibility of this approach. 2 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A The interactive SQL facility supports the interactive query of databases accessed through PC Data servers. Required data format translations are automatically performed. Optional SQL Compiler Support Support for SQL 3GL application development is available with the op- tional purchase of a DEC SQL development licenses. DEC SQL develop- ment licenses provide precompiler support for embedded SQL applica- tions, a compiler for SQL module language programs and an application programming interface (API) to support the development of client/server applications. Embedded SQL programming places SQL language statements in line with host language statements. Precompilers replace these SQL statements with call statements and object modules. The modified host language program is compiled and linked with the object modules to form an ex- ecutable image. Precompilers for DEC C, DEC Ada, DEC COBOL, DEC For- tran, DEC Pascal and PL/I for OpenVMS are included. Table 1 describes the DEC SQL precomplier support by platform. ___________________________________________________________________ Table_1:__DEC_SQL_Precompiler_Support______________________________ Language Software Platform Compiler____________OpenVMS_VAX____OpenVMS_AXP_____Digital_UNIX____ DEC Ada X X - DEC C X X X Digital UNIX C - - X DEC COBOL X X X DEC Fortran X X - DEC Pascal X X - PL/I_for_OpenVMS____X______________X_______________-_______________ 3 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A These precompilers support an optional Federal Information Process- ing Standards (FIPS) flagger that allows the user to identify any SQL statements which are not in the current ANSI/ISO SQL standard. An ex- ception flagger for the Multivendor Integration Architecture (MIA) stan- dard is also provided. The SQL module language processor allows SQL statements and multistate- ment procedures to be grouped into modules. When these modules are com- piled, the resulting object modules can be linked with objects cre- ated by any language compiler that complies with the OpenVMS calling standard. The SQL module language compiler also supports FIPS and MIA flagging. SQL/Services API programming libraries are used to interface client applications to the SQL/Services server. MS-DOS[R] or MS Windows client applications can be written in Microsoft C. Macintosh[R] client ap- plications can be written in MPW[TM] C or ThinkC. A DEC SQL development license also includes SQL/Services client pro- gramming libraries for Microsoft Windows[TM], Windows NT[TM], Digi- tal UNIX, MS-DOS, Sun[R], ULTRIX or OpenVMS platforms. The following table summarizes SQL/Services network support. Clients other than the DEC ODBC Driver for MS Windows are based on the SQL/Services API. 4 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A ___________________________________________________________________ Desktop SQL/Services Network Support Client_____________DECnet_TCP/IP____IPX/SPX___AppleTalk[R]_________ DEC ODBC Driver X X X - for MS Windows MS Windows X X X - MS-DOS X X X - OS/2[R] X - - - Macintosh X X - X SPARCstation[TM] - X - - Windows NT X X X - Digital UNIX/1 X X - - AXP OpenVMS X X - - ULTRIX_____________X______X_________-_________-____________________ CONFORMANCE TO STANDARDS DB Integrator and all DB Integrator Gateways compile with the Inter- national Standard,ISO/IEC 9075:1992 and the American National Stan- dard, ANSI X3.135-1992, Database Language SQL, Entry-Level specifi- cation, and the Federal Information Processing Standard for Database Language SQL (FIPS SQL) as defined in FIPS PUB 127-2. The DEC ODBC Driver for MS Windows complies with the Microsoft Open Database Connectivity specification V2.0. Disk Space Requirements Table 3 lists the disk space required to install and operate DBI soft- ware by hardware/operating system platform (Platform). The common re- quirement represents the space required to store software objects that are common to DBI and the DB Integrator family of gateways. If one of these products is not already installed on the system or cluster, the disk space requirement will be increased by this amount. 5 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A ___________________________________________________________________ Table_3:__Disk_Space_Requirements_by_Client_Platform_______________ Disk Space Required (Blocks) Platform_______Install_____Permanent____Common_____________________ OpenVMS VAX 56,000 46,000 30,000 OpenVMS 72,000 62,000 42,000 Alpha Digital UNIX 85,000 85,000 73,260 Alpha______________________________________________________________ ___________________________________________________________________ Table_3:__Disk_Space_Requirements_by_Server_Platform_______________ Disk Space Required (Megabytes) Platform_________________Install_____Permanent_____________________ PC Data Server Only 8.5 MB 0.2 MB Server_&_ODBC_Drivers____8.5MB_______5.5MB_________________________ 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. OPTIONAL HARDWARE For desktop clients based on DEC ODBC Driver for MS Windows, Microsoft Windows or MS-DOS[R] : o Personal Computer XT, Personal Computer AT[R], or equivalent o Ethernet LAN connectivity 6 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A For SQL/Services Macintosh platform: o Macintosh Plus, Macintosh SE and SE/30, Macintosh II, IIx, IIcx, IIci, and IIfx, Macintosh portable o Ethernet LAN connectivity For Sun[R] platform: o SPARCstation[TM] 1 o Ethernet LAN connectivity SOFTWARE REQUIREMENTS PC Data Gateway Windows Server Software Requirements One of the following operating systems: Winwows V3.1 - V3.1.1 Windows 95 Windows NT Network Transport Options The PC Data Gateway Windows Server requires the following network soft- ware to support client access from Digital UNIX and OpenVMS Client sys- tems: o Windows Sockets Compliant TCP/IP PC Data Gateway for OpenVMS VAX Cleint Software Requirements o OpenVMS VAX Operating System V5.5-2 - V6.2 Network Transport Options 7 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A The PC Data Gateway for the OpenVMS VAX platform will require one of the following network software products to suport communications with the PC Data Gateway Windows Server: o TCP/IP transport - DEC TCP/IP Services for OpenVMS VAX, V3.0 - V3.1 The PC Data Gateway for the OpenVMS VAX platform will require one or more of the following network software products to support access via remote desktop clients: 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 PC Data Gateway for OpenVMS Alpha Client Software Requirements o OpenVMS AXP Operating System, V6.1-V6.2 Network Transport Options The PC Data Gateway for the OpenVMS Alpha platform will require one of the following network software products to suport communications with the PC Data Gateway Windows Server: o TCP/IP transport - DEC TCP/IP Services for OpenVMS VAX, V3.0 - V3.1 The PC Data Gateway for the OpenVMS Alpha platform will require one or more of the following network software products to support access via remote desktop clients: o DECnet transport - DECnet for OpenVMS AXP, V6.1 - V6.2 o TCP/IP transport - DEC TCP/IP Services for OpenVMS AXP, V3.0 - V3.1 8 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A 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 PC Data Gateway for Digital UNIX Alpha Software Requirements o Digital UNIX Operating System V3.0, V3.2 p> Network Transport Options The PC Data Gateway for the OpenVMS Alpha platform will require one of the following network software products to suport communications with the PC Data Gateway Windows Server: o TCP/IP transport - DEC TCP/IP Services for OpenVMS VAX, V3.0 - V3.1 The PC Data Gateway for the OpenVMS Alpha platform will require one or more of the following network software products to support access via remote desktop clients: o DECnet transport - DECnet/OSI, Version 2.0, for Digital UNIX o TCP/IP transport - Included with the Digital UNIX Operating Sys- tem DESKTOP CLIENT SOFTWARE REQUIREMENTS This section describes the prerequisite operating system and network- ing software required by DB Integrator and DB Integrator Gateway Clients. ODBC and SQL/Services Clients A site-wide right to use SQL/Services and Digital ODBC client soft- ware is included with each traditional or concurrent use license for the DB Integrator or DB Integrator Gateway 9 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A Parties selling or distributing a software product that incorporates Digital Equipment Corporation's SQL/Services client application pro- gramming interface, may copy and distribute the SQL/Services client runtime libraries with that software product. Parties selling or distributing a software product that incorporates the Microsoft ODBC application programming interface, may copy and dis- tribute Digital Equipment Corporation's Digital ODBC Driver distri- bution kit with that software product. The Digital ODBC Driver kit must be distributed in a manner that guarantees the end-user will receive the entire contents of the DEC ODBC Driver kit. MS Windows v3.1 Clients o Microsoft Windows, V3.1 o MS-DOS Operating System, V5.0 - V6.2 o One of the following network products: - PATHWORKS for DOS, V4.1A - PATHWORKS V5, V5.0A or V5.1 for DOS and Windows client software - PATHWORKS for DOS (TCP/IP), V2.0 - A Windows Sockets V1.1 specification compliant transport. [4] - Novell NetWare 3.11 Windows Workstation Client with IPX.COM or IPXODI.COM, and NETX shell Windows NT on Intel[TM] and Alpha Clients o Microsoft Windows NT Operating System, V3.1 - V3.5 o One of the following Network products: - PATHWORKS for NT V4.1 ____________________ [4] PATHWORKS V5, V5.0A and V5.1 for DOS and Windows client software and FTP[R] PC/TCP V2.3 have been fully tested with the SQL/Services and ODBC driver clients. Other transports that comply with the Windows Sockets V1.1 specification may function correctly but have not been fully tested by Digital 10 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A - A Windows Sockets V1.1 specification compliant transport - Novell NetWare 3.11 Windows Workstation Client with IPX.COM or IPXODI.COM, and NETX shell MS-DOS Clients o MS-DOS Operating System, V5.0 - V6.2 o One of the following network products: - PATHWORKS for DOS, V4.1A - PATHWORKS V5, V5.0A or V5.1 for DOS and Windows client software - PATHWORKS for DOS (TCP/IP), V2.0 - PATHWORKS V5, V5.0A or V5.1 for DOS and Windows client software with PATHWORKS V5.1.102 or higher PATHWORKS socket library - Novell NetWare 3.11 Windows Workstation Client with IPX.COM or IPXODI.COM, and NETX shell Digital UNIX Clients o Digital UNIX Operating System, V3.2 o One of the following network products: - TCP/IP which comes with the Digital UNIX operating system - DECnet/OSI, V2.0, for Digital UNIX (Required for DECnet applications only) ULTRIX/RISC Clients o ULTRIX Operating System, V4.1 - V4.3 o One of the following network products: - TCP/IP that comes with ULTRIX Operating System - DECnet/OSI for ULTRIX, V5.1, for RISC and VAX (Required for DECnet applications only) 11 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A Sun OS Client o SunOS[TM], V4.1.3 o One of the following network products: - TCP/IP that comes with Sun OS Operating System SQL/Services Macintosh System 6.0.8 Clients o Macintosh Operating System V6.0.8 o One of the following network products: - PATHWORKS for Macintosh, V1.2A - AppleShare[R] Workstation Software for System V6.0.8 (Required for PATHWORKS installation) o Required for application development only - MPW Development Environment, Version 3.2.3, and MPW, Version 3.2.3, C compiler - Symantec[R] ThinkC, V6.0.1, and ThinkC, V6.0.1, C Compiler for the Macintosh system SQL/Services Macintosh System 7 Clients o Macintosh Operating System, V7, V7.1 o One of the following network products: - PATHWORKS for Macintosh, V1.2A - AppleShare Workstation Software for System 7 (required for PATHWORKS installation) o Required for application development only - MPW Development Environment, Version 3.2.3, and MPW, Version 3.3.1, C compiler - Symantec ThinkC, V6.0.1, and ThinkC, V6.0.1, C Compiler 12 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A Optional SequeLink Clients If clients or network transport are required, but not supported ODBC or SQL/Services clients, optional SequeLink[TM] client/server soft- ware is available to work with DB Integrator and DB Integrator Gate- ways. SequeLink is client/Server middleware developed by Techgnosis, which can be used cooperatively with Digital's DB Integrator and DB Integrator Gateway products. SequeLink Clients or Servers can be pur- chased through Digital or its resellers. The following table contains a list of the SequeLink clients and Networks: ___________________________________________________________________ Table_4:__Optional_SequeLink_Client/Network_Support________________ Desktop Transport Client_________________Supported___________________________________ Windows 3.x WIN Sockets TCP PATHWORKS 5.x SPX/IPX NetBIOS NetBUEI Macintosh 6.x-7.x MAC TCP/IP 1.x PATHWORKS 5.x Appletalk 1.5 HP UX 8.x-9.x Native TCP AIX 3.2x Native TCP Solaris 2.x Native TCP Sun OS 5.3 Native TCP DG Aviion Native TCP SCO UNIX Native TCP Digital UNIX 1.3-3.2 Native TCP Sequent Native TCP Unisys R4 Native TCP 13 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A ___________________________________________________________________ Table_4_(Cont.):__Optional_SequeLink_Client/Network_Support________ Desktop Transport Client_________________Supported___________________________________ ULTRIX 4.3a Native TCP VMS AXP 1.5-6.2 DECNET TCP VMS_VAX_5.5-6.2________DECNET______________________________________ OPTIONAL SOFTWARE The following products can be used in combination with DB Integrator any DB Integrator Gateway, Data Distributor or Sequelink product. The folowing is a list of products available through Digital or its re- sellers. o DEC DB Integrator Gateway for RMS o DEC DB Integrator Gateway for DB2 Client o DEC DB Integrator Gateway for ORACLE o DEC DB Integrator Gateway for SYBASE o DEC DB Integrator Gateway for SequeLink o DEC DB Integrator Gateway for EDA/SQL o DEC DB Integrator Gateway for Custom Drivers o DEC DB Integrator Gateway for DBMS o DEC DB Integrator Gateway for DSM o DEC DB Integrator Gateway o DEC Data Distributor o SequeLink Clients o SequeLink Server for DB Integrator o SequeLink Server for DB2/400 14 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A o SequeLink Server for DB2/2 o SequeLink Server for DB2/6000 o SequeLink Server for DB2/MVS o SequeLink Server for Informix o SequeLink Server for Ingres o SequeLink Server for Interbase o SequeLink Server for Oracle o SequeLink Server for Progress o SequeLink Server for Cincom o SequeLink Server for Teradata GROWTH CONSIDERATIONS The minimum hardware/software requirements for any future version of this product may be different from the requirements for the current version. DISTRIBUTION MEDIA TK50, Mag Tape For OpenVMS VAX, this product is available on 9-track 1600 BPI Mag- netic Tape, TK50 Streaming Tape. CD ROM For all supported server operating systems this product is available on CD-ROM. Consolidated CD ROM For all supported server operating systems this product is available on the layered products consolidated CD-ROM. 15 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A ORDERING INFORMATION DEC DB Integrator Gateway for PC Data for OpenVMS VAX Traditional Software Licenses: QL-3DYA*-** Concurrent Use License: QL-3DYAA-3* Software Documentation: QA-3DYAA-GZ Software Product Services: QT-3DYA*-** Software Media: QA-3DYA*-** (TK, Mag Tape, CD) Software Media QA-VWJ8A-H8 (Consolidated CD) DEC DB Integrator Gateway for PC Data for OpenVMS Alpha Traditional Software Licenses: QL-3DZA*-** Concurrent Use License: QL-3DYAA-3* Software Product Services: QT-3DZA*-** Software Documentation: QA-3DYAA-GZ Software Media: QA-3DZAA-H8 (CD-ROM) Software Media: QA-03XAA-H8 (Consolidated CD) DEC DB Integrator Gateway for PC Data for Digital UNIX Alpha Traditional Software Licenses: QL-3DXA*-** Concurrent Use License: QL-3DXAM-3B Software Documentation: QA-3DYAA-GZ Software Product Services: QT-3DXA*-** Software Media: QA-3DXAA-H8 (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. SOFTWARE LICENSING This software is furnished only under a license. For more information about Digital licensing terms and policies, contact your local Dig- ital office. License Management Facility Support 16 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A This layered product supports the OpenVMS License Management Facil- ity. Traditional and Concurrent Use licenses are available. A Tradi- tional license permits an unlimited number of authorized users to ac- cess this product on a single, identified processor. A Concurrent Use license allows any one user at a time to access the layered product. For this software product a user is defined as an OpenVMS process serv- ing either an individual or another local or remote process. For more information on the License Management Facility, refer to the OpenVMS Operating System documentation. Client Software Licensing Parties selling or distributing a software product that incorporates the Microsoft ODBC application programming interface, may copy and dis- tribute Digital Equipment Corporation's DEC ODBC Driver distribution kit with that software product. The DEC ODBC Driver kit must be dis- tributed in a manner that guarantees the end-user will receive the en- tire contents of the DEC ODBC Driver kit. SOFTWARE PRODUCT SERVICES A variety of service options are available from Digital. For more in- formation, contact your local Digital office. SOFTWARE WARRANTY Warranty for this software product is provided by Digital with the pur- chase of a license for the product as defined in the Software Warranty Addendum of this SPD. [R] AppleTalk, and Macintosh are registered trademarks of Apple Computer Inc. [R] IBM and OS/2 are registered trademarks of International Busi- ness Machines Corporation. 17 DEC DB Integrator Gateway for PC Data SPD 63.32.00 Version 3.1A [R] Microsoft, MS, and MS-DOS are registered trademarks of Microsoft Corporation. [R] Novell and NetWare are registered trademarks of Novell, Inc. [R] ORACLE is a registered trademark of Oracle Corporation [R] Sun is a registered trademark of Sun Microsystems, Inc. [R] FTP is a registered trademark of Schere Laboratories, Inc. [R] SYBASE is a registered trademark of Sybase, Inc. [TM]MPW is a trademark of Apple Computer Inc. [TM]DB2 is a trademark of International Business Machines Corpora- tion. [TM]Windows is a trademark of Microsoft Corporation. [TM]SPARCstation is a trademark of Sun Microsystems, Inc. [TM]The DIGITAL Logo, AXP, ClusterWide, DATATRIEVE, DEC, DEC Ada, DEC Fortran, DECdtm, DECnet, Digital, OpenVMS, PATHWORKS, ULTRIX, ULTRIX, VAX VAX 11/750, VAX 11/780, VAX 6000, VAX 8200, VAX 8250, VAX 8300, VAX 8350, VAX 8500, VAX 8530, VAX 8550, VAX 9000, VAXstation 4000 VLC, VAXcluster, VAXft, VAXserver, VAXstation, VAX RMS, VMS, VMS RMS and VMScluster are trademarks of Digital Equipment Corporation. All other trademarks and registered trademarks are the property of their respective owners. ©1995 Digital Equipment Corporation. All rights reserved. 18