HP NonStop Data Transformation Engine Getting Started Guide Abstract This guide introduces the HP NonStop™ Data Transformation Engine (NonStop DTE) basic product concepts and helps you through the installation and startup process. Product Version NonStop Data Transformation Engine 6.7.
Document History Part Number Product Version Published 427629-001 NonStop Data Transformation Engine 1.0 December 2000 522434-001 NonStop Data Transformation Engine 5.0.3 November 2001 522434-002 NonStop Data Transformation Engine 6.7.1 June 2004 522434-003 NonStop Data Transformation Engine 6.7.1 October 2004 522434-004 NonStop Data Transformation Engine 6.7.
Contents Contents About This Guide ................................................................................................................... 5 Assumptions...................................................................................................................................................... 5 New and Changed Information........................................................................................................................... 5 Related Manuals..........................
Contents NonStop DTE Tuxedo Transformation Server .................................................................................................. 32 NonStop DTE CORBA Transformation Server.................................................................................................. 32 Index......................................................................................................................................
About This Guide This guide provides background information about HP NonStop Data Transformation Engine (NonStop DTE) and the Mercator product as well as a list of related guides. This guide also provides installation procedures for NonStop DTE on the HP NonStop platform. Assumptions The assumption throughout the documentation for the NonStop DTE products is that you are familiar with the use of the Windows 95/98, or the Windows NT operating system, and have some familiarity with data structures.
About This Guide 6. If you didn’t use the Integration Flow Designer in step 3 to design your map flow, refer to the NonStop Data Transformation Engine Integration Flow Designer Reference Guide now to perform the integration flow design. In addition to the manuals described above, NonStop DTE also provides the following manuals: NonStop Data Transformation Engine What’s New Reference Guide This guide provides an overview of the new features available in NonStop Data Transformation Engine version 6.7.1.
About This Guide NonStop Data Transformation Engine SQL/MX Adapter Reference Guide This guide describes how to use the NonStop SQL/MX adapter. Read this guide if you use the NonStop SQL/MX adapter for HP NonStop ZLE (Zero Latency Enterprise) to access and manipulate data contained in databases that are NonStop SQL/MX data sources. NonStop Data Transformation Engine SQL/MP Adapter Reference Guide This guide describes how to use the NonStop SQL/MP adapter.
About This Guide Conventions Several conventions and assumptions have been used to provide clearer documentation throughout the NonStop DTE manual set. Installed Path Throughout the NonStop DTE product documentation, the path where each product component is installed may be shown in the captured screen images. In the examples, the product is shown as installed in the default directory, c:\Mercator5.0, or c:\mercator. However, HP recommends installing the product into c:\NSDTE6.7.1.
Chapter 1 - Introduction Overview This chapter presents an overview of the Mercator products and describes how they address various aspects of e-business application integration. What is Mercator? Mercator is a software company that provides an E-Business Integration Broker Suite of products for enabling the integration of applications—across the enterprise, business-to-business, or business-toconsumer.
Chapter 1 - Introduction ♦ The Platform API ♦ Adapters ♦ Servers The following diagram shows how these component groups are interrelated: Server Design Studio (2) Transform Map (3) Platform API Adapter Adapter (1) (5) (4) (4) Messaging Systems, Databases & Applications The adapters connect to the platform application program interface (API) and are executed from a server by using the platform API.
Chapter 1 - Introduction ♦ Type Tree Maker – The Type Tree Maker allows you to create their own importers. It is a scripting tool that can be used to automate the capture of metadata from machine-processible sources to create graphical metadata for use in Mercator products. ♦ Map Designer – The Map Designer uses the definitions of data objects created in the Type Designer to specify the rules for the transformation and routing of data. Maps are analyzed, compiled, and tested using the Map Designer.
Chapter 1 - Introduction The following figure shows two adapters below the Platform API: Transformation Server Platform API Adapter Adapter Input Output Maps use input and output cards to specify which the adapters to use. The input cards and output cards can be overridden at runtime through the Platform API, allowing the dynamic selection of adapters. Mercator adapters fall into four classes: Utility adapters, Messaging adapters, Database adapters, and Application adapters.
Chapter 1 - Introduction Transformation Server Transformation Server Platform API Platform API Memory Adapter File Adapter OSS file The e-mail adapter automatically receives e-mail messages as sources of a map or sends e-mail messages as targets of a map. The e-mail adapter on the NonStop supports Internet E-mail (SMTP/POP3). File Transfer Protocol (FTP) is used to transport data.
Chapter 1 - Introduction NonStop DTE supports the Tuxedo and the IBM WebSphere MQ Series Messaging adapters on the NonStop platform. Database Adapters NonStop DTE does not support database adapters at this time. Application Adapters NonStop DTE does not support application adapters at this time. Server Transformation Components NonStop DTE offers a variety of execution methods.
Chapter 1 - Introduction Tuxedo Server Client Input (1) 2 Platform API 3 3 4 Memory 3 Adapter Adapter 4 Output Map ♦ CORBA Server - The CORBA Transformation Server executes a single map each time that it is called. Like the Tuxedo Server, it can exercise maps that use external adapters for output, as well as maps that return the output in the response. (Refer to the diagrams for the Tuxedo Server.
Chapter 1 - Introduction elements, and records, its strength lies in defining complete business objects. “Business objects” in Mercator’s Design Studio are the substance of business transactions such as: health claims, invoices, bank transfers, airline reservations, ship notices, or telephone bills.
Chapter 1 - Introduction 17
Chapter 1 - Introduction Defining Transformation Rules Complete definitions of data objects and the rules for their transformation are embodied in a Mercator map. Map objects are created using the Map Designer, where a graphical metaphor makes complex transformations easier to define and maintain. Maps are analyzed, compiled, and tested using the development environment. A map object can represent either a simple transformation (common to many applications), or a full mapping solution.
Chapter 1 - Introduction multiple inputs to multiple outputs. All of these capabilities supplement simple, drag-and-drop mapping where needed. Using Mercator’s E-Business Broker Suite, data in an output does not have to come from an input. You can compute data, look up something in a database, sort, extract, merge or use any of dozens of Mercator functions to create output. You can map an output to another output.
Chapter 1 - Introduction source or target from the information workflow component or at execution time. Mercator mapping solutions are resource independent. You can also use resource adapters in map rules. For example, you can use database adapters in a map rule to look up cross-reference data stored in a database. When the resource adapter you want to use varies, depending on the data content, you can dynamically allocate the resource from within a map rule.
Chapter 1 - Introduction Defining Resource Connectivity When you use the Integration Flow Designer to specify resource adapters for map components, links are automatically established when the target of one component is used as the source of another so you can see the flow of information among system components as you design.
Chapter 1 - Introduction With Mercator’s E-Business Broker Suite, you can configure your environment with multiple servers at multiple sites, each server running on the same platform or different platforms. Or, you can select one server on one platform as your transformation server. For example, you can develop a Mercator map that includes all the information about how to map your company’s data. Then, this map can be provided to another user in your company, perhaps at a different site.
Chapter 2 - Installing NonStop Data Transformation Engine Products Now that you have some knowledge of NonStop DTE products, this chapter explains how to install them on your workstation and NonStop platforms. NonStop DTE Installation Program NonStop DTE uses an installation program called IPSetup for the NonStop platform. IPSetup is a utility provided on the product CD for installing independent products.
Chapter 2 - Installing NonStop Data Transformation Engine Products CD-ROM Root Directory Contents The contents of the NonStop DTE CD are as follows: File Name AUTORUN.INF Description File containing CD AutoRun commands IPSETUP.CNT File containing help contents for the CD installation utility IPSetup. IPSETUP.EXE File containing the main executable for IPSetup. IPSETUP.HLP File containing help text for IPSetup. LICENSE.
Chapter 2 - Installing NonStop Data Transformation Engine Products CD_DOCS Subdirectory containing product documentation in the following two subdirectories: PDF_DOCS Subdirectory of CD_DOCS containing: 1. Product manuals in PDF format for viewing with Adobe Acrobat Reader 2. ACROBAT_VIEWERS subdirectory containing Adobe Acrobat Reader for DOS, OS/2, Windows, Windows NT, MacOS, Sun OS, Solaris, HP-UX, IBM AIX, and SGI IRIX.
Chapter 2 - Installing NonStop Data Transformation Engine Products NonStop Kernel Operating System (G06.06 RVU or later) HP NonStop Kernel RVU G06.06 or later G-series RVU NonStop Software T8620D40 OSS File System T9550G06 Socket Library or higher version T9551G06 TCP/IP T9552G06 TCP/IP FTP T9750G06 Safeguard T8344D44 NonStop TS/MP Pathmon T8698D46 NonStop TM/MP T2818C11 NonStop CORBA 2.6.1 T8351D46 NonStop Tuxedo 6.5 Core Services (for Tuxedo Transformation Server) T8354D46 NonStop Tuxedo/Q 6.
Chapter 2 - Installing NonStop Data Transformation Engine Products Microsoft TCP/IP stack and FTP client Workstation Disk Space Requirement 110 MB Workstation Memory Requirement 32 MB 2) Review the file USRGUIDE.PDF. This file is located in the subdirectory NSK_SW on the product CD. In the PDF file, locate the IPSetup User Guide and review the instructions for using IPSetup. You need Adobe Acrobat Reader (available on the product CD) to read or print the IPSetup User Guide.
Chapter 2 - Installing NonStop Data Transformation Engine Products system, follow these steps to unpack the NonStop DTE Tuxedo Server product files and install them: a) If you haven't already done so, log into your system and start the OSS shell by typing the following command at the TACL prompt: > osh b) Verify the directory named /usr/tandem exists and that that the current userid has write access to the /usr directory.
Chapter 2 - Installing NonStop Data Transformation Engine Products > pax -rvf T0578PAX [-s:/usr/tandem/nsdte::] In this command, the parameter to the first -s option, , specifies the custom location to place the NonStop DTE CORBA Server files. 8) Setup the OSS environment for NonStop DTE. a) If you did not install NonStop DTE in the default directory (/usr/tandem/nsdte/), change to the directory where you installed NonStop DTE by entering cd at the prompt.
Chapter 3 - Learning NonStop DTE Products Now that you understand the fundamentals of NonStop DTE, you can start expanding your knowledge about the use of these applications with the NonStop DTE manual set and the online help system. NonStop DTE Online Library For your quick and easy access to all the information, the NonStop DTE manual set contains thousands of pages of information on Mercator and NonStop DTE products.
Chapter 3 - Learning NonStop DTE Products ♦ Menus, Tools and Windows – Help is available for menu commands and tools in any main window of a client product component as well as for active windows such as any Navigator, properties window, the Organizer, a trace window and so on. ♦ Dialog – The use of each dialog is explained in a step-by-step fashion providing the information you need to complete the dialog. Some tips and helpful hints or examples may also be provided.
Chapter 4 - Upgrading From NonStop DTE 5.0.3 Chapter 4 - Upgrading From NonStop DTE 5.0.3 All the maps built for the RVU 5.0.3 have to be rebuilt for the new RVU 6.7.1. To upgrade from NonStop DTE 5.0.3 to 6.7.1, perform the following steps: 1. Back up all map, input, and user files to a separate directory. 2. Stop all running NonStop DTE processes.
Chapter 4 - Upgrading From NonStop DTE 5.0.
Index Index description, 20 A M Adapters source, 19 target, 19 Map Designer, 11 description, 18 Mapping made simple, 19 Mercator products COBOL Copybook Importer, 16 Database Interface Designer, 16 IDoc Importer, 16 Integration Flow Designer, 22 Map Designer, 18 Type Tree Maker, 16 metadata, 15 B binary data, 16 business objects, 16 C COBOL Copybook Importer description, 16 Command Server, 12, 22 CORBA server overview, 15 product number, 23 stopping, 32 CORBA server installing, 28 O Overview, 9 P P
Index U W using e-mail adapters, 12 web site, 31 Workflow management tool, 22 V Visual Basic, 6 35
