Easysoft Data Access Middleware

Easysoft provides interfaces between data and the applications that use it.
  • Manufacturer: Easysoft

  • E-Mail: sales@easysoft.com

  • URL: http://www.easysoft.com/

  • Price: Free for single users, commercial licenses vary

  • Reviewer: Jon Valesh

Easysoft provides interfaces between data and the applications that use it. With Easysoft's products, you can access any ODBC data source from just about any computer system, and you can allow access to many Linux databases from ODBC clients. To use real-world examples, you can access Access on a Win98 desktop from your Linux web server, or your MySQL database from Excel.

Very few assumptions are made about what you will do with that data once you have it. Use it with PHP or iHTML, write custom C code, access it from Python or Perl or a Java applet; Easysoft doesn't care.

Easysoft provides a combination of their own ODBC-ODBC bridge software to allow access to remote database servers, and unixODBC 1.8.10 to access Linux database software. Access to SQL databases is through Easysoft's SQL-ODBC gateway package. This standardization on ODBC for all database access gives two important benefits: your programs will be totally free of database-specific dependencies, and you can seamlessly access multiple databases without special code. Not only databases, you can access any data source that has an ODBC driver.

Installation

On Easysoft's web page (http://www.easysoft.com/), they claim you can install their ODBC-ODBC bridge in one to two minutes. They aren't far off. It actually took closer to five minutes, but perhaps I was having a slow day.

Easysoft supports Linux as just one of about a dozen platforms, and they obviously know having a distribution that works regardless of one's system type is very important. In the Linux arena, they have libc5 and glibc 2.1 versions for Intel x86 and Alpha processors. Installation is done without the use of a system package tool and requires superuser access, because several new libraries are added and files in your /etc directory are changed. All files are placed in the /usr/local/easysoft directory. If downloaded from Easysoft's web page, the software is packaged in a compressed tar file and installation is a two-step process. First, you must unpack the obscenely long-named tar file, change to the newly created directory and run the install script.

The install script is a model of how self-installing Linux programs should behave. You are asked a series of questions about which components you would like installed, what directory to place the files in and how everything should be set up. Given the quality of the installation script, very little would be gained by using distribution-specific package tools, and Easysoft's already daunting array of download options would increase unnecessarily.

One stage of the setup includes running Easysoft's license management software. This application collects personal information about you and how you will use the product, and contacts Easysoft's servers through the Internet to request a license key. If you don't have an Internet connection, you can print out the collected data and mail it to Easysoft via real-space mail.

The Easysoft's installation script installs unixODBC. Easysoft listens on port 8888 for ODBC requests and 8890 for HTTP requests.

Easysoft's package is made up of separate client/server applications. The clients and servers are a rather mix-and-match affair. You can run a Windows server and Linux clients, or Linux and OpenVMS servers and Java clients (using the ODBC-JDBC bridge), or whatever your application demands. For most users, the servers would be installed on the company database server computers, and the clients would end up wherever the data was needed. This could be your web server, a desktop computer running a database client application, or both. This gives you great flexibility in choosing your data sources, and even allows some unlikely combinations like using spreadsheets on desktop computers as data sources for dynamically updating web pages.

Using the Software

Easysoft's tools are designed to facilitate getting data for your applications, not writing them. In fact, they don't really even provide the API. If you know how to use database tools, Easysoft's products will give you access to a wider range of data sources. If you don't, they provide some tutorial information to point you in the right direction, but that's about it.

The APIs you use are specific to your language or development environment, not Easysoft's product. Most aren't that complicated, but it is totally a matter of what tools you are using. If writing PHP scripts, you connect to your databases with the PHP ODBC support. A command such as @odbc_pconnect(<datasource>, <username>, <password> ) establishes the connection to the data source, returning a string if the connection is successful. Once connected, you request data by assembling a string with your query, and running another API command to execute it. If you are writing in Perl, you use the DBM::ODBC API to access the data sources. If your development tools include an ODBC API, chances are you can use Easysoft's tools to provide access to a wider range of data sources.

______________________

White Paper
Linux Management with Red Hat Satellite: Measuring Business Impact and ROI

Linux has become a key foundation for supporting today's rapidly growing IT environments. Linux is being used to deploy business applications and databases, trading on its reputation as a low-cost operating environment. For many IT organizations, Linux is a mainstay for deploying Web servers and has evolved from handling basic file, print, and utility workloads to running mission-critical applications and databases, physically, virtually, and in the cloud. As Linux grows in importance in terms of value to the business, managing Linux environments to high standards of service quality — availability, security, and performance — becomes an essential requirement for business success.

Learn More

Sponsored by Red Hat

White Paper
Private PaaS for the Agile Enterprise

If you already use virtualized infrastructure, you are well on your way to leveraging the power of the cloud. Virtualization offers the promise of limitless resources, but how do you manage that scalability when your DevOps team doesn’t scale? In today’s hypercompetitive markets, fast results can make a difference between leading the pack vs. obsolescence. Organizations need more benefits from cloud computing than just raw resources. They need agility, flexibility, convenience, ROI, and control.

Stackato private Platform-as-a-Service technology from ActiveState extends your private cloud infrastructure by creating a private PaaS to provide on-demand availability, flexibility, control, and ultimately, faster time-to-market for your enterprise.

Learn More

Sponsored by ActiveState