|
| ||||||||||||||||||
 |  |  |  |
Easysoft Data Access is a series of programs that allow you to have heterogeneous access to any database on any platform.
With Easysoft software you can connect applications on more platforms to more database systems than ever before.
This section explains how the Easysoft SQI-Sage Tetra CS/3 Driver works, and provides an overview of the installation procedure.
Sage Tetra CS/3 is a modular financial system offering a variety of functionality from routine accounting to sophisticated business management tools.
You can combine different modules to tailor the system precisely to your company's needs.
Sage Tetra CS/3 is a real-time multi-user system. For example, once an invoice is entered by one user, another user can generate a report drawing on the very latest data.
Sage Tetra CS/3 is also a client server system. When the Sage Tetra CS/3 server is installed on a Unix machine, you might use the Sage Tetra CS/3 Windows GUI client to work with the Sage Tetra CS/3 data from a Windows PC, but it is more difficult to work with the Sage Tetra CS/3 data within other Windows applications such as Microsoft Excel.
This is the shortcoming that the Easysoft SQI-Sage Tetra CS/3 Driver overcomes.
The Easysoft SQI-Sage Tetra CS/3 Driver is an ODBC 3.5 driver which allows you direct access to C-ISAM based Sage Tetra CS/3 data using ODBC-compliant applications such as Microsoft Excel, or JDBC-compliant applications such as bespoke web programs.
Once connected to your Sage Tetra CS/3 data, you can query it for precisely the information you want.
The Easysoft SQI-Sage Tetra CS/3 Driver provides:
The Easysoft SQI-Sage Tetra CS/3 Driver is part of the Easysoft Data Access product range: the integrated data access middleware suite created to simplify the development and deployment of powerful ODBC and JDBC solutions with no compromise on performance, functionality and scalability.
The Easysoft SQI-Sage Tetra CS/3 Driver uses established Easysoft Data Access components to achieve its data access:
For example, if your Sage Tetra CS/3 server is on Unix box, a user running Microsoft Excel on a networked PC can connect to the Sage Tetra CS/3 data on the server.
Integrated with the Easysoft components is unixODBC, the open source ODBC driver manager for Unix, which enables you to configure more than one ODBC driver on your Unix server.
The unixODBC driver manager is installed as part of the Easysoft SQI-Sage Tetra CS/3 Driver installation.
From your ODBC or JDBC application, you select a function which involves accessing the Sage Tetra CS/3 data (for example, you run a query to display all outstanding invoices).
The function passes from the application to the Easysoft ODBC-ODBC Bridge client or the Easysoft JDBC-ODBC Bridge client on your local machine, then across the network to the Easysoft ODBC-ODBC Bridge server or the Easysoft JDBC-ODBC Bridge server on the server machine.
It then passes into the unixODBC driver manager which directs the SQL query to the Easysoft SQI-Sage Tetra CS/3 Driver, which reads table and column information directly from the Sage Tetra Data Dictionary and interfaces to the Sage Tetra data.
It converts SQL statements into commands that can query the Sage Tetra CS/3 data, and returns a result set back to the querying application (via unixODBC and the Easysoft ODBC-ODBC Bridge or the Easysoft JDBC-ODBC Bridge).
For more information about the Easysoft ODBC-ODBC Bridge or the Easysoft JDBC-ODBC Bridge, please visit the Easysoft web site at http://www.easysoft.com.
You can find out more information about unixODBC from the unixODBC Project web site at http://www.unixodbc.org.
| This manual describes how to use the Easysoft SQI-Sage Tetra CS/3 Driver with the Easysoft ODBC-ODBC Bridge, but you can install it for use with the Easysoft JDBC-ODBC Bridge equally well. |
To install and configure the Easysoft SQI-Sage Tetra CS/3 Driver:
1. Install the Easysoft SQI-Sage Tetra CS/3 Driver on the server (and optionally the Easysoft ODBC-ODBC Bridge server or Easysoft JDBC-ODBC Bridge server), which also optionally creates a data source on the server to point to your Sage Tetra CS/3 data (see Installing the Easysoft SQI-Sage Tetra CS/3 Driver).
2. License the Easysoft SQI-Sage Tetra CS/3 Driver, which also automatically licenses the Easysoft ODBC-ODBC Bridge (see Licensing the Easysoft SQI-Sage Tetra CS/3 Driver).
3. Enable users and grant them access to your Sage Tetra CS/3 data (see Administration).
4. Optionally, install the Easysoft ODBC-ODBC Bridge client on the machine of each Sage Tetra CS/3 user (see Installing the Easysoft ODBC-ODBC Bridge client).
5. Optionally, create a data source on each of your client machines to connect to your Sage Tetra CS/3 data via the Easysoft ODBC-ODBC Bridge (see Setting up a data source on your Windows client).
The installation of the Easysoft ODBC-ODBC Bridge and the Easysoft JDBC-ODBC Bridge are explained briefly in this manual, but for full details please refer to the product-specific documentation.
| Copyright Notice |
| | | |
