OpenLink Rails ODBC Adapter

OpenLink Ruby on Rails ODBC Adapter

Developer(s)	OpenLink Software
Operating system	Cross-platform
Type	Rails, Ruby, ODBC, Databases, Data Architecture, Software
License	Dual Licensed: GPL and Commercial
Website	Official Web page

The OpenLink Ruby on Rails ODBC Adapter is a native Ruby on Rails adapter providing transparent and consistent access to the Rails ActiveRecord Framework library.

The OpenLink Ruby on Rails ODBC Adapter is released as free, open source software under the GNU General Public License. It requires the Ruby ODBC Adapter for operation.

OpenLink Rails ODBC Adapter

The OpenLink Rails ODBC Adapter has been designed to provide a generic data access layer to the Rails ActiveRecord Framework library, enabling connectivity to any ODBC enabled database. This is achieved through use of the Ruby ODBC Adapter from Christian Werner for the bridge from Ruby to the C-based ODBC API.

The OpenLink Rails ODBC Adapter has been tested extensively with the OpenLink ODBC Drivers. For full functionality, ActiveRecord requires specific features in the underlying ODBC drivers, and the OpenLink drivers were enhanced for this purpose. For this reason, it is recommended that the OpenLink Rails ODBC Adapter be used with these drivers where possible. The Rails Adapter does work to a fair degree with other third party ODBC Drivers.

The following ODBC enabled databases are tested and certified compatible (see the project site for database-specific notes):

• Oracle
• Informix
• Ingres
• OpenLink Virtuoso
• SQL Server
• Sybase
• MySQL
• PostgreSQL
• DB2
• Progress

Installation

Details on the installation of the Rails ODBC Adapter can be obtained from the official OpenLink Rails ODBC Adapter site, but in summary are:

1. Install Ruby
2. Install Ruby ODBC Adapter
3. Install Ruby Gems
4. Install Ruby on Rails
5. Install Rails ODBC Adapter

See also

• OpenLink Software, the company that builds and maintains the Rails ODBC Adapter
• OpenLink ODBC Drivers, extended and certified specifically for use with the Rails ODBC Adapter
• Ruby on Rails, introduction to Ruby on Rails

External links

• Official Ruby on Rails Web site
• Official Rails ODBC Adapter Web site
• Official OpenLink Software Web site
• OpenLink ODBC Drivers Product URI
• Rails ODBC Adapter Product URI