SRTransportTM

A Data±Warehousing Solution for NEXTSTEP.

SRTransport loads your database with legacy data. Begin by specifying a data source and a data destination. Configure data changes with a robust expression language. Configure data validations in the same way. Choose a mode for importing rows of data into your database. Finally run your transport configuration! View the data as it's read from the data source, as it's changed and validated, and at the last step, as SQL that is executed in your database.

SRTransport in batch mode:

Once you've used SRTransport.app to specify a transport configuration, you can execute that transport in the background, and on a variety of machines. The batch mode program srtransport is provided with SRTransport. srtransport is a Unix command line program. It reads its configuration from a .transport file and a .filedesc file (both are created by SRTransport.app).

Batch mode program srtransport  is available (possibly at extra cost) on the following platforms:
	NEXTSTEP (HP PA-RISC, INTEL, MOTOROLA)
	Sun Sparcstations (Sun OS and Solaris [call for Solaris86])
	HP UX
	DG UX

Licensing:

Schema Research products are licensed on a floating concurrent execution basis. The license is installed in a table in a database. Software is executed on any machine as long as the license database is accessible and the number of licensed users has not been exceeded.

Installation:

If you're installing file SRTransport.app, drag SRTransport.app to directory /LocalApps or to ~/Apps.

If you're installing file SRTransport.app.compressed, drag it to directory /LocalApps or to ~/Apps. Select (click on) SRTransport.app.compressed in the File Viewer and choose Decompress from the file menu.

If you're installing file SRTransport.app_0.chunk, drag it to directory /LocalApps or to ~/Apps. After the first disk is read, you will be asked for the second disk.

Accessing your server:

To access your dataserver with SRTransport, your dataserver must be installed, and it must be accessible from your NEXTSTEP machine. If you can access your Sybase SqlServer with isql or if you can access your Oracle dataserver with sqlplus, then SRTransport can access your server. Your dataserver can be executing on any machine on the network, including your own workstation.

Using SRTransport:

To demonstrate SRTransport, follow the following instructions:

1	Create a Sybase database, or use an existing one.
2	Create the invoice table by executing script sample/invoice.sql in your default database.
		isql -Usally -P < invoice.sql
3	Execute SRTransport.app.
4	Command-drag file sample/invoice.transport to the SRTransport.app icon.
5	You'll be told that invoice.filedesc can't be found. Click Ok.
6	You'll be asked to login to your database server and choose a database. Choose
	the database where you created the invoice table.
7	Choose Open in the Source area.
8	In the Open Panel, find and choose the file sample/invoice.filedesc.
9	Command-drag file sample/invoice.data to the file-well in the .filedesc window.
10	In the invoice.filedesc window, choose Save.
11	Choose Preview to see the rows of data parsed from the data file.
12	In the invoice.transport window, choose Save.
13	Choose the Transport button, to enter a window where you can actually transport
	rows from the data file to your table.
14	Check the boxes labled 'Trace SQL' and 'Pause on Error'.
15	Choose the Run button to actually transport rows to the table.


Once you've explored SRTransport, you can perform the tutorial. Choose Help in the Info menu, and search for keyword tutorial.


For more information:	Schema Research Corporation
	2603 Broadway, Redwood City, CA 94063 USA
	Phone (415) 368 8477   Fax (415) 368 8479
	Email: Products@LSC.com