— Ingres —

Enterprise-grade Relational Database Management System


Register Now

Actian’s Ingres is a leading, enterprise-grade database management system designed to reduce IT costs and time-to-value, while delivering the strength and features expected from an enterprise-class database. Ingres 10.2 is the latest version of the database, containing enhancements that will make it easier to internationalize customer applications. Along with improved performance and reduced configuration overhead, users can take their first steps into big data analytics with the new Window functions.

Check out these related products: Enterprise Access – lets developers build one client application that can access data on multiple DBMS platforms. EDBC – Directly connects business applications to mainframe databases.

What’s New in Ingres 10.2

  • Geospatial enhancements – We’ve added eight 2-D (flat earth), twenty-seven 3-D (round earth) and fifteen 4-D (2-D and 3-D plus time series) data types and eight linear functions
  • Remote GCA – Permits a GCA client process to connect to a remote installation without requiring a Name Server or Communications Server to be running in the client installation
  • UTF-8 Transliteration – Mapping between UTF-8 and non-UTF-8 character sets
  • Check out a short video showing how to display Ingres data geospatially using Google Maps
  • Download the Ingres/Google Maps demo source code
  • DBMS Level Authentication – Removes the need to add an operating system user every time a new user needs database access
  • IPv4 and IPv6 Data Types and Functions – IPV4 and IPV6 store host addresses in binary format
  • Per-Query Parallelism Level – Set explicit parallelism level for individual queries
  • Window Function Syntax – A great way to get started with simple analytics

Out-of-the-box spatial management

Incorporate spatial data alongside your transactional data within a single repository and remove the barriers for managing spatial data types using a file-based approach. Now you can manage spatial data as part of a transaction, and share data in spatial cases with a platform for development of modern applications.

Ingres 10.2 Benefits

  • 50 new geospatial data types
  • Simple introduction to analytics with Window functions
  • Reduced configuration overhead
  • Query parallelization
  • Simpler internationalization
  • 12 new SQL functions

Ingres 10.2 Supports

  • Safe Software’s FME
  • GeoTools Library
  • GeoServer, and more…

Enterprise Access and EDBC

Enterprise Access allows a single application to run against multiple databases without needing to know or use host specific syntax or datatypes. The Enterprise Access server implements an interface similar in appearance and behavior to each of the supported DMBS platforms. It is an Ingres connectivity option that allows Ingres applications to run against non-Ingres databases such as Microsoft SQL Server and Oracle.

EDBC provides real-time high performance read/write connectivity to z/OS databases from Windows client/server and Internet, Intranet, and Extranet business applications. EDBC directly connects business applications to enterprise databases on the z/OS mainframe platform, such as CA-Datacom/DB Database, CA-IDMS/DB Database, DB2, CICS/VSAM and VSAM.

Enterprise Access 3.0 Benefits

  • Support for Microsoft SQL Server 2014
  • Improved compatibility with Ingres 10.2, including SELECT statement enhanced with OUTER JOIN
  • Support for SQL Server Native Client 10
  • Support for Big INT data types for SQL Server, Oracle, IBM DB2 UDB
  • Extended system catalog changes for OpenROAD 6.2 features support


Platforms Supported

  • Databases: Oracle, Microsoft SQL Server, IBMDB2 UDB
  • Operating Systems*: Windows, Solaris SPARC, Solaris x86, Linux

Request Support for Additional EA Platforms

EDBC Benefits

  • ODBC access to mainframe databases
  • JDBC access to mainframe databases
  • .NET access to mainframe databases
  • SQL access to databases that don’t support SQL (VSAM and IMS)


Platforms Supported

  • Databases: CA-Datacom/DB, CA-IDMS, DB2, IMS, CICS/VSAM and VSAM on the z/OS Mainframe platforms
  • Operating Systems*: IBM z/OS
Contact Us