• Getting Started
•  1. Introduction
  • Operating Environment Differences
  • Introduction to Enterprise Access
  •  The Ingres Solution
    • Structured Query Language (SQL)
    •  Possible Gateway Configurations
      • Local Gateway Configuration
      • Mixed Gateway Configuration
      • Remote Gateway Configuration
  •  User Interfaces
    • OpenROAD Support
    • Embedded SQL and OpenAPI Support
    • ODBC Driver Support
    • JDBC Driver Support
    • Character-Based Tools Support
  •  Enterprise Access Installation Overview
    • Installation Prerequisites
    • Installation Procedure
  • Connect to the Host DBMS through the Gateway
  • Your Support Options
•  2. DBMS Setup Requirements
  •  How Gateway Access Works
    •  Oracle Access Requirements
      • Grant User Permissions (Oracle)
    •  Microsoft SQL Server Access Requirements
      • Configure a Data Source (Windows)
    •  DB2 UDB Access Requirements
      • Grant User Permissions (DB2 UDB)
•  3. Installation for Windows
  • Installation Prerequisites
  •  Install Enterprise Access for Windows
    • Enterprise Access Shortcuts
  • Post-Installation Configuration (Windows)
  •  Unattended Installations
    • Response File Creation Options
    •  Install Enterprise Access using a Response File
      • Response File Parameters
      • Sample Response File
•  4. Installation for UNIX
  •  Installation Prerequisites
    • Gateway System Administrator Account
    • Account Permissions
    • Create the Account
    • Create a Gateway System Directory
    • Set Up the Local Environment
  •  Installation Options for UNIX
    • New Installation
    • Existing Enterprise Access Installation
    • Existing Ingres Installation
  •  Post-Installation Configuration (UNIX)
    • Commands to Control the Gateways
    • Create a Gateway Alias
    • Build the Gateway Catalogs
    • Add an Automatic Startup Command
    • Allow Access on Systems Using Shadow Passwords
    •  Establish User Access to Tools and Databases
      • Edit User Login File to Facilitate User Access to Tools
      • Edit User Login File to Set Up Shared Library Paths
    • View Contents of Your Current Installation
    • Use Terminal Monitor to Access the Gateways
•  5. Managing Network Communications
  •  Network Utilities
    • Open a Network Utility Window
    • Add a Virtual Node
    • How You View Server Information
    • Additional Virtual Node Procedures
    • Advanced Node Parameters
    • Additional Logins for a Virtual Node
    • Test Node Feature
    • Connect to Servers and Gateways
    • How You Exit Ingres Network Utility
  •  Direct Connect
    • Configure Direct Connect
    • II_GC_REMOTE Server Setting
•  6. Managing Databases
  •  Database Object Manager
    •  Open a Database Object Manager Window
      • Drill-Down Capability
      • Example Database Objects Display
    • Database Object Properties
    • Database Object Management
  •  Ingres Visual SQL Utility
    •  Open a Visual SQL Scratchpad Window
      • SQL Assistant
      • Example SQL Scratchpad Results
    • How You Exit the Data Administration Utilities

Getting Started

How You Exit the Data Administration Utilities