Go to the NEW OTC internet service: www.otc.pl

Please follow above link to be redirected to the new internet information service of the OTC Company.
Thank you.

OTC logo

Mediator for SQL Server


 

Table of contents...
Write your comments here...


OTC News


Mediator for Oracle
Mediator for Microsoft SQL Server
Mediator for Sybase Adaptive Server Anywhere
Terminal for CA-Clipper (DBF version)Terminal for CA-Clipper (Mediator version)


Download evaluation programs...

 

 MEDIATOR for  SQL Server
  Wind for Clipper's sail

Mediator for SQL Server enables any CA-Clipper application to work in Microsoft SQL Server 7 database environment. Mediator allows to save the most valuable thing - thousands of tried-and-true lines of code while replacing the data storing methods, which are the weakest elements of CA-Clipper. Porting data to SQL Server database means the end of problems  with damaged indexes, tables that are too big or insufficient protection. Additionally using Mediator enables CA-Clipper programmers to use full capabilities of Microsoft SQL Server.

Mediator enables a quick and easy achievement of technological breakthrough in the software, requiring incomparably lower expenses than are traditionally associated with upgrading the software.

How does CA-Clipper/MEDIATOR application work?

Mediator is RDD driver. RDD standard (Replaceable Data Driver) is used with CA-Clipper tools beginning with version 5. After linking Mediator libraries, CA-Clipper application connects with MEDIATOR server working with SQL Server, instead of the traditional reading *.dbf files. CA-Clipper/Mediator application follows a client-server model: data processing (selection, index modification, sorting) is located on the server, while data presentation is located on workstations.

Information flow in MEDIATOR system

Mediator server can work on the computer with SQL Server database installed, or it can communicate with a database located on another computer using network libraries.

System architectures.

Profits gained from using Mediator

Overcoming of typical defects and limits of CA-Clipper application

Data security provided by advanced database server

Access to RDBMS features for CA-Clipper programmers (transactions, SQL, Transact SQL procedures)

Wide choice of standardized tools for an extensive data analysis

Possibility of gradual migration to Graphical User Interface environment

Effective and secure work in Wide Area Network

Cooperation with Terminal software for connecting tens of workstations via low throughput connections

Low costs of porting and implementing of the application


System requirements

Server

CPU:   Intel Pentium, PRO, II, III
Operating System:  Microsoft Windows NT
Database: Microsoft SQL Server 7

Workstations

CPU:   80x86, Pentium
Operating System:  DOS, DOS Windows 95/98/NT
Network:  TCP/IP or IPX/SPX

Tools

CA-Clipper 5.2e/5.3, Blinker 4.0 or later

[All listed names are registered trademarks of respective companies]


 

Home ] Up ] Mediator for SQL Server - FAQ ]

Please send any questions or comments regarding our web site to: webmaster@otc.pl or write on comments page.
Copyright (C) 1999 OTC S.A.
Last modified: 2000-04-17