| |
|
Real-Time
Syteview uses a set of programs called DataLinks to link
tables in your Progress database to matching tables in your
SQL Server database in real-time. The moment a record is created, modified or deleted in one of your Progress tables a table trigger executes a small piece of code which writes
the changes made out to a small text file which is immediately read by one of the DataLink programs. The DataLink
program then transforms the text file into an SQL Server compatible record format and depending on the type of change made
either inserts the record into the SQL Server table, or modifies or deletes the existing record in the SQL Server table.
The impact of this process on your existing Progress database server is minimal. Thousands of record
changes can be exported from your Progress server with less than one second of CPU time and zero disk accesses.
Web Interface
Once Syteview has your data, it is available to anyone or any process with the proper
credentials using Microsoft and internet standard methods and interfaces. User authentication is handled by
standard Microsoft Authentication services, while your data is returned to the user by a
Microsoft IIS web server in either generic HTML tables or in Microsoft Excel format.
Any device capable of requesting and displaying HTML formatted data or Excel spreadsheets can be used.
Syteview comes with a set of easily customized HTML templates already configured to display
much of your Syteline™ data.
These templates include web pages that allow your users to fill in fields describing the data they wish to
retrieve, and with the click of a button the requested data is displayed - anywhere, at anytime.
For a more powerful data linking and replication toolset providing multiple data formats and multiple replication destinations
please check out our SyteLink Toolset.
|
|
|