Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

About OpenLink Universal Data Access

Secure and High-Performance Drivers for ODBC, JDBC, ADO.NET, OLE DB, and XMLA

In today’s hyperconnected data-driven economy, your ability to access, transform, contextualize and distribute data affects the outcome of all your digital transformation pursuits aimed at improving both enterprise and individual agility.

The technology that enables you to store, access and disseminate data across the enterprise is of timeless value.

What are Data Access Drivers (or Connectors)?

Data Access Drivers (or Connectors) are the technology that sits between business solutions and data management applications.

This kind of technology, commonly referred to as Data-Access Middleware, profoundly impacts any organization’s ability to improve and sustain agility through data access, transformation, and dissemination.

Fundamentally, Data Access Middleware is based on open standards, to ensure a loose-coupling between front-end solutions and the back-end data management services from which data is retrieved.

Open standards associated with Data Access Middleware include ODBC (Open Database Connectivity), JDBC (Java Database Connectivity), ADO.NET (ActiveX Data Objects for .NET), OLE DB (Object Linking & Embedding for Databases), and XMLA (XML for Analysis).

What are OpenLink Data Access Drivers?

Our collection of secure, high-performance, open-standards-compliant ODBC, JDBC, ADO.NET, OLE DB, and XMLA drivers (connectors) is commercially packaged as the suite of OpenLink Universal Data Access (UDA) Drivers.

These drivers are available in three main forms:

Express Edition (Single-Tier) Drivers (ODBC only)

Our Express Edition is an easy to deploy, DBMS-specific packaging of our Lite Edition ODBC Driver for JDBC Data Sources (our Lite Edition ODBC–JDBC Bridge), bundled with a database-specific JDBC driver. This packaging allows us to provide database-specific configuration dialogs and performance optimizations which are not deliverable through the generic Lite Edition ODBC–JDBC Bridge packaging. However, these drivers are dependent upon and limited by the third-party JDBC driver and the local Java environment.

Download our Express Edition drivers today!

Lite Edition (Single-Tier) Drivers (ODBC, JDBC, ADO.NET, OLE DB, and XMLA)

Our entry-level Lite Edition ODBC drivers leverage database-specific networking (provided by each target database backend) for high-performance remote database connectivity.

There are also Lite Edition Bridge Drivers, enabling ODBC applications to connect to JDBC Data sources; and enabling JDBC, ADO.NET, XMLA, and/or OLE DB applications to connect to ODBC Data Sources.

Download our Lite Edition drivers today!

Enterprise Edition (Multi-Tier) Drivers (ODBC, JDBC, ADO.NET)

We’ve equipped our Enterprise Edition drivers with a uniquely secure database-independent communications layer that uses a “session rule-book” to describe fine-grained, attributed-based data access controls which are applied to all connections made through these components.

Download our Multi-Tier Edition drivers today!

What Benefits does OpenLink Data Access provide?

OpenLink UDA ensures that your data assets remain yours to exploit in the manner that best serves the digital business needs of your organization.

You are empowered with the freedom to mix and match best-of-class IT infrastructure components without vendor lock-in at the operating system, programming language, application server, or database level. Vendor lock-in at any of these levels ultimately impedes enterprise agility.

Which Data Access Standards Are Supported?

Our support of open standards for data access includes the following:

  • ODBC (Open Database Connectivity)
  • JDBC (Java Database Connectivity)
  • ADO.NET (ActiveX Data Objects for .NET)
  • OLE DB (Object Linking & Embedding for Databases)
  • XMLA (XML for Analysis)

What Databases Engines Are Supported?

  • DB2 5.x, 6.x, 7.x, 8.x, 9.x
  • Firebird 1.x, 2.x
  • Informix (SE, OnLine, XPS, US, and IDS) 5.x, 7.x, 8.x, 2000 (9.x), 10.x, 11.x, 12.x
  • Ingres (also known as CA-Ingres, OpenIngres, etc.) 6.4, II, 3.x, 8.x, 9.x
  • Microsoft SQL Server 4.x, 6.x, 7.x, 2000 (v8.00.x), 2005 (v9.00.x), 2008 (v10.00.x), 2008R2 (v10.50.x), 2012 (v11.00.x), 2014 (v12.00.x), 2016 (v13.00.x), 2017 (v14.00.x)
  • MySQL 3.x, 4.x, 5.x
  • Oracle 7.x, 8i, 9i, 10g, 11g, 12.x
  • PostgreSQL 7.x, 8.x, 9.x
  • Progress DBMS 7.x, 8.x, 9.x
  • Progress OpenEdge 9.x, 10.x, 11.x
  • SAP Sybase SQL Anywhere 16.x, 17.x
  • Sybase ASE (Adaptive Server Enterprise) 11.x, 12.x, 15.x
  • Sybase ASA (Adaptive Server Anywhere) 7.x, 8.x, 9.x
  • Sybase SQL Anywhere 6.x, 10.x, 11.x, 12.x
  • Sybase SQL Server 4.2+, 10.x, 11.x
  • Other ODBC-accessible data sources (4D, CSV, FileMaker Pro, Microsoft Access, Microsoft Excel, Text, etc.)
  • Other JDBC-accessible data sources (Athena, Firebird, Frontbase, hsql, Pointbase, Presto, etc.)

What Operating Systems Are Supported?

Our products are generally available for use on most versions of AIX, BSD, HP–UX, Linux, macOS, Solaris, Windows, and several other UNIX-like OS. While specific products may not currently be available for your specific OS or version, custom ports are always a possibility, and we are expert in finding alternative connection paths to serve your needs. Please contact us if you can’t easily find what you need!

  • ODBC ODBC Drivers are available for Windows, Linux, macOS, and all UNIX-like operating systems (32- and 64-bit).
  • JDBC JDBC Drivers are 100% pure Java and will run on any 32- or 64-bit platform hosting a Java Virtual Machine, whether installed as a JRE (Java Runtime Environment) or a JDK (Java Development Kit).
  • ADO.NET ADO.NET providers are available for use with 32- or 64-bit Microsoft .NET (on Windows) or 32- or 64-bit Mono (on Windows, Linux, Solaris, macOS, and others).
  • OLE DB OLE DB providers are available only for Microsoft Windows (both 32- and 64-bit).
  • XMLA XMLA providers are available only for 32-bit Microsoft Windows.

How Can I Use and Benefit from OpenLink Data Access Drivers?

Reaping the benefits of these drivers starts by simply acquiring and/or developing database independent solutions that are compliant with the ODBC, JDBC, ADO.NET, or OLE DB standards, and then installing the appropriate UDA driver(s) for the database(s) to which you need access.

End-users just need to connect your Spreadsheet, Business Intelligence, Analytics, or Web Application to your back-end database, without writing a single line of code or requiring any exposure to the complexities of networking or low-level database interaction.