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.


Enterprise Access


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
  • 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

  • ESRI’s ArcGIS for Desktop
  • Safe Software’s FME
  • GeoTools Library
  • GeoServer, and more…
Certified_OGC_Compliant_Logo_Web Ingres 10.2 is OGC compliant. To learn more:

Enterprise Access and EDBC

Enterprise Access is an Ingres server that makes other databases look like an Ingres database. It is an Ingres connectivity option that allows Ingres applications to run against non-Ingres databases such as Oracle. Enterprise Access allows a single application to run agains multiple databases without needing to know or use host specific syntax or data types.

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

What’s New for Enterprise Access

  • 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 Catalogs changed to support OpenROAD 6.2 Features

Click here for the Ingres Enterprise Access FAQ

Enterprise Access Platforms Supported

  • Databases: Oracle, Microsoft SQL Server, IBM DB2 UDB
  • Operating Systems*: Windows (EA 3.0)


*For a complete list of support platforms visit the Actian Support website

EDBC 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


*For a complete list of support platforms visit the Actian Support website

Make sure your version of Enterprise Access or EDBC is still supported. Visit the Actian Support web pages and click on the Lifecycle Dates tab.


Adult Hadoop Has Arrived! My thoughts on Strata + Hadoop Wor...

I am always invigorated by industry events like Strata + Hadoop World.  There’s nothing quite like being surrounded by people ... continue reading

What’s So Great About Open?

When Actian announced the highest performing, most industrialized  SQL-in-Hadoop capability via Actian Vortex in June of last year, in essence ... continue reading
Actian Vector Express Lesson 3 – Derive Fields and Do Lookups for BI | Watch Video
Vector Express Lesson 2 – ETL load of 2 files with the same structure | Watch Video

Check out the 2015 Gartner Magic Quadrant for Data Warehouse...

For the second year in a row, Actian has been positioned as a Visionary in Gartner’s Data Warehouse and Data ... continue reading
Actian Vector Express Lesson 3 – Derive Fields and Do Lookups for BI | Watch Video
< Show Me More >
Contact Us