Extracting the Data from the 3rd Party or Legacy System - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

The first step necessary for using the Open Ident Interface is to extract the data you want to import into Smart Materials from the system where it currently resides. This problem is closely related to the technical details of this system, so it is not possible to give a general description here. If the other system happens to be another Oracle database, you should look closely at the Smart Materials scripts B200144.SQL and OII_LOG.SQL. These scripts can serve well as a template on how to extract large amounts of data out of an Oracle database by writing a quite simple SQL*Plus script with a more than acceptable performance. For very large quantities of data, the best throughput is normally achieved by writing a specialized Pro*C program or a C program that utilizes low-level OCI calls.