Getting Started
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
DBMS Setup Requirements
How Gateway Access Works
Oracle Access Requirements
Grant User Permissions (Oracle)
Microsoft SQL Server Access Requirements
Configure a Data Source (Windows)
ODBC Access Requirements
Grant User Permissions (ODBC)
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
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
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
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