SR·Transport & SR·Agent Data Sheet

Sept.24, 2002

Data – can't live with it – can't live without it ! SR·Transport makes it easy.

E T L

Extract Data

Transform Data

Load Data

Functions

Expressions

Custom SQL

Scripting

Split Fields

Merge Fields

Convert Schemas

Auto insert,
update, delete ...

Validation

Qualification

Reconnection

Deadlock Retry

Reject Management

SR·Transport bridges data between applications, databases and documents. It simplifies data translation, allowing disparate system to communicate. It is used by programmers and non-programmers alike, to create automatic data interfacing solutions.

SR·Transport

Saves IT Budget

SR·Transport does not require a programmer. Your "domain expert" can be very effective because they know the data and they use SR·Transport to manipulate it.

SR·Transport eliminates the custom programming of data interfaces.

Reduces Development Time

SR·Transport handles complex data issues easily by providing powerful transformation functions.

SR·Transport runs interactively providing immediate feedback and inspection of input data and the transformed results.

Minimizes CPU Time

SR·Transport is fast, processing data through its optimized mapping engine.

SR·Transport gives you access to all the high speed features of your database server software. Bulk load operations are orders of magnitude faster than SQL insert statements.

Ensures High Reliability

SR·Transport provides validation of your data, and manages rejected data in such a way that you always know what you have (or don't) and why.

S·RTransport is robust to interruptions, reconnecting to a database server if disconnected.

SR·Transport is extensible. A full-featured scripting language provides a rich set of functions, and direct access to your own code.

Module	Capability
Oracle	Access to Oracle tables, views and stored procedures.
Sybase	Access to Sybase tables, views, stored procedures and bulk-copy modes.
OpenBase	Access to OpenBase tables, views and stored procedures.
XML	Transport directly to or from documents on the internet.
JDBC	Move data to and from any data source with its JDBC driver. Oracle, Sybase and OpenBase drivers included.
Java	Move data to and from your Java data objects. Call 'setter' and 'getter' methods.
EOF/ODBC	Import or export data via Enterprise Objects. Integrate business object processing and validation into the transports.
File	Interpret fixed-width or delimited data files, and perform consistency checks.
DBF File	Interpret DBF data files, a legacy file format, still used by many applications.
Archive	Store data in binary files for later transporting.
Custom	Script your own custom solutions by calling into a rich set of functions for working with files, the internet, Java, COM and your own private API's.
Enscribe	Access to Enscribe data files. Extract only.

Platforms

SR·Transport – Mac OS X Win NT/2000
SR·Agent – Win NT/2000 Mac OS X Solaris HPUX Linux

510-748-9014 888-296-4453 510-748-9584 fax SchemaResearch.com