TIPS, the HP3000 data migration tool from Comp Three, easily and automatically converts your HP3000 IMAGE and Powerhouse schemas and data to Oracle, SQL Server or MySQL, on Windows or Unix.
TIPS is strictly an HP3000 program, with no windows component or GUI. You run it on your HP3000 and type in the database you want converted, and/or the POWERHOUSE schema for the KSAM and flat files you want converted. It then automatically creates a schema file for building your SQL database (tables, indices, reference constraints, etc.) and creates an extract file for each IMAGE dataset and each POWERHOUSE file you want converted. These files can then be moved to the target system to create and load the new SQL database. Again, in order to build and populate your new SQL database with the data just as it exists on your HP3000, all you need to do is run TIPS, type in the database name, and/or POWERHOUSE schema file name, transfer the files to the target system, and execute a single load script, provided with TIPS on the target system.
This vanilla mode supports all IMAGE types, converts IMAGE array items, converts implied decimals, converts dates, and contains other common features. Features such as skipping of sets or fields, renaming sets and fields, date conversion formats, defining which fields are dates, SQL field types, reference constraints, and number of implied decimals for converting numerics can all be controlled via the CONFIGURATION file, which you can modify.
Vanilla mode would probably work for some very simple databases currently on the HP3000, none of which we’ve had the pleasure to work on. The real power of TIPS is in its user exits, which allow you to write your own code to transform your data during extraction. The user exits, written by you in your favorite HP3000 language (we provide examples) allow you to easily create new fields, remove fields, rename fields, and, most importantly, populate your new fields or change existing ones, using whatever logic your migration requires. Even complicated transformations like splitting one dataset into two tables, or producing multiple SQL records for each input record, can be accomplished with TIPS configurable “multi-pass” capability.
The first user exit executes ONCE per extracted dataset. It receives as a parameter the IMAGE dataset name or POWERHOUSE file being extracted, and allows you to alter the table layout, if you wish, by removing fields, adding fields, renaming fields or changing a field’s definition (length, type, etc).This is accomplished by calling the runtime TIPS procedures TIPSGetFieldAttributes, TIPSPutFieldAttributes, TIPSRemoveField and TIPSInsertField, as shown in example A, below.
The second user exit executes once per extracted record. It allows you to execute your own code to alter the contents of the current record in whatever way you wish. You can examine or change the values of any field, including fields you added or deleted from the table layout in the previous user exit. This is accomplished by use of the TIPS runtime procedures TIPSGetFieldValue and TIPSPutFieldValue, in combination with your own field population logic, as shown in example A, below. The beauty of this approach is twofold:
1) The conversions can be as simple or as complex as your needs require.
2) The business logic for conversions is supplied by you, the HP3000 programmer, using the environment you’re most familiar with, and code you probably already have.
This product has been used to convert numerous production HP3000 applications to SQL Server, Oracle and MySQL environments on Windows and Unix. Even with extensive structural and data content transformations, complete database migrations can be accomplished in one or two days.
Leverage your HP3000 expertise to quickly migrate all your HP3000 data to SQL. Call Comp Three for more information or you can download your free TIPS trial version.
Click here to see coding example showing how TIPS can be used to customize your HP3000 data migration