Linux Domino to MS-SQL with Two Choices
Category Linux
FreeTDS provides an OSS solution via a set of libraries for Linux to connect natively to Microsoft SQL Server and Sybase databases. Here's how FreeTDS describes their product:
Technically speaking, FreeTDS is an open source implementation of the TDS (Tabular DataStream) protocol used by these databases for their own clients. It supports many different flavors of the protocol and supports several APIs to access it. Additionally FreeTDS works with other software such as Perl and PHP, providing access from those languages as well. There is also a native (type 4) JDBC driver available for platform-independent Java clients (including Java Server Pages applications), with support for most of the JDBC 1 API and portions of the JDBC 2 API.
FreeTDS has many possible uses. It has been used by Unix/Linux webservers to present data stored in SQL Server to the web, for porting SQL Server database code from NT to Unix, to import data into SQL Server from a Unix source, and to provide database access on those platforms such as real-time systems that have no native drivers.
The FreeTDS C libraries are available under the terms of the Gnu LGPL license, consult the COPYING.LIB file in the distribution for details. Major portions of the source code for the JDBC driver are copyright CDS Networks, Inc., or Craig Spannring, the original author of the driver, with a license which permits "[r]edistribution and use in source and binary forms, with or without modification" provided the conditions in that license are met (see the license included with the driver's distribution).
FreeTDS has an active mail list, in which you'll find the praises of Domino developers, and I know of some IBM partners who have been happy with the CSV version of FreeTDS. Apparently, the performance was surprisingly good.
If you are running Domino on Linux (good for you) then you may find yourself constrained when it comes to connectivity to other RDBMS. Obviously, DB2 won't be an issue, but interacting with a Microsoft SQL Server can be a deal breaker. You have two options: EasySoft or FreeTDS.
EasySoft offers a variety of commercial products, each of them is defined as a Bridge. For Linux to SQL Server there are three possible choices: ODBC-ODBC, JDBC-ODBC, and XML-ODBC.
FreeTDS provides an OSS solution via a set of libraries for Linux to connect natively to Microsoft SQL Server and Sybase databases. Here's how FreeTDS describes their product:
Technically speaking, FreeTDS is an open source implementation of the TDS (Tabular DataStream) protocol used by these databases for their own clients. It supports many different flavors of the protocol and supports several APIs to access it. Additionally FreeTDS works with other software such as Perl and PHP, providing access from those languages as well. There is also a native (type 4) JDBC driver available for platform-independent Java clients (including Java Server Pages applications), with support for most of the JDBC 1 API and portions of the JDBC 2 API.
FreeTDS has many possible uses. It has been used by Unix/Linux webservers to present data stored in SQL Server to the web, for porting SQL Server database code from NT to Unix, to import data into SQL Server from a Unix source, and to provide database access on those platforms such as real-time systems that have no native drivers.
The FreeTDS C libraries are available under the terms of the Gnu LGPL license, consult the COPYING.LIB file in the distribution for details. Major portions of the source code for the JDBC driver are copyright CDS Networks, Inc., or Craig Spannring, the original author of the driver, with a license which permits "[r]edistribution and use in source and binary forms, with or without modification" provided the conditions in that license are met (see the license included with the driver's distribution).
FreeTDS has an active mail list, in which you'll find the praises of Domino developers, and I know of some IBM partners who have been happy with the CSV version of FreeTDS. Apparently, the performance was surprisingly good.
- 
Comments
I cannot find a single success story regarding FreeTDS and Lotus Domino.
I have Domino up and running, I also have FreeTDS up and working with a tested connection to the M$SQL 2000 server, but can't get Domino to use FreeTDS.
Posted by Magnus At 04:15:08 PM On 05/24/2007 | - Website - |