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

In today's knowledge economy your ability to exploit data ultimately determines success. Thus, the technology that impacts your ability to store, access, and disseminate data across the enterprise is of ever-increasing value.

Knowledge is the basis of competitive advantage, but there is no knowledge without Information, and there is no Information without Data. Basically, there is no such thing as Information Technology (IT) without Data.

What is Universal Data Access Middleware?

Universal Data Access (UDA) middleware defines a category of software that provides transparent access to data sources (such as databases) from Desktop Productivity Tools, Application Development Environments, and Web & Internet Points of Presence.

Why Is It Important?

UDA middleware ensures that your data assets remain yours to exploit in the manner that best serves the needs of your organization. You are empowered by having 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. The cost of vendor lock-in at any of these levels ultimately impedes enterprise agility.

UDA middleware from OpenLink Software describes a collection of industry standards-compliant Data Access Drivers that support the following:

How Do I Put UDA to Use?

You simply acquire and/or develop database independent solutions that are ODBC, JDBC, OLE DB, or ADO.NET compliant, and then install the appropriate UDA driver(s) for the database(s) to which you need access.

UDA utilization can be as simple as connecting your Spreadsheet or Word Processor to your back-end database, without need of a single line of code or any exposure to the complexities of networking and low-level database interaction. It may be a little more involved if you are an applications or systems programmer. Irrespective of why you seek to exploit UDA based middleware, it will always ultimately provide better value to your enterprise than any proprietary (aka Native) alternative.

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
  • Ingres (also known as CA-Ingres, OpenIngres, etc.) 6.4, II, 3.x, 8.x, 9.x
  • Microsoft SQL Server 6.x, 7.x, 2000 (8.x), 2005 (9.x), 2008 (10.x)
  • MySQL 3.x, 4.x, 5.x
  • Oracle 7.x, 8i, 9i, 10g, 11g
  • PostgreSQL 7.x, 8.x
  • Progress DBMS 7.x, 8.x, 9.x
  • Progress OpenEdge 10.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
  • Sybase SQL Server 4.2+, 10.x, 11.x
  • Other ODBC-accessible data sources (Text, CSV, Microsoft Access, 4D, FileMaker Pro, etc.)
  • Other JDBC-accessible data sources (Firebird, Frontbase, hsql, Pointbase, etc.)

What About Operating System Support?

Products from OpenLink Software are generally available for use on most versions of AIX, BSD, HP-UX, Linux, Mac, 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.

  • ODBC Drivers are available for Windows, Linux, Mac OS X, Mac OS 9, and all UNIX flavors (32 and 64 bit).
  • JDBC Drivers are 100% pure and run on any platform hosting a Java Virtual Machine (runtime environment).
  • ADO.NET providers are available for use with Microsoft .NET (on Windows) or Mono (on Windows, Linux, Solaris, Mac OS X, and others).
  • OLE DB providers are available only for Microsoft Windows (32 and 64 bit).