PLATFORMS: Honeywell is running Oracle Applications 10.7 software on a variety of platforms, including HP 9000 and SUN Solaris systems. SmartDB Workbench also runs on other UNIX and Windows NT environments.

PROBLEM SOLVED: As part of their Year 2000 readiness strategy, Honeywell Corporation, the global leader in control technology, made the decision to have all of their operating units that had not already done so implement the Oracle applications suite as their ERP solution. In addition, those units already running Oracle were to upgrade to release 10.7, which Oracle Corporation recommends in its Year 2000 support strategy. One of the operating units was the Honeywell Technology Center (HTC). HTC had already begun the process of implementing Oracle Applications 10.7 and, as such, was to be the first operating unit to perform a data conversion under the new initiative. The first and overriding goal was a successful, accurate, efficient and timely data conversion to support the scheduled go-live date. PRODUCT FUNCTIONALITY: The SmartDB Workbench is a graphical development environment for data movement tasks. It allows analysts to work directly and visually with a data extract file or table to create data "templates." A data template allows the analyst to point to and name a data element in the extract file; the contents of this element can be defined either from its fixed position in the data file or by user-specified delimiters. The analyst can then define the data format and null-allowed attributes for each data element, along with any validation, transformation, lookup or filter rules specific to that data element. The extract file being referenced can be tested against the rules that the analyst has applied to them, allowing the analyst to identify any logic errors or data problems before attempting to actually load the data tables.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access