Datawatch's Monarch Data Pump Offers Shortcut for Data Conversion Projects.WILMINGTON, Mass.--(BUSINESS WIRE)--Aug. 24, 1998-- Taps Existing Reports as a Source for Populating Data Warehouses, Performing Y2K See Y2K problem and Y2K compliant. Y2K - Year 2000 Conversions and for Moving Data from Legacy Systems Datawatch Corporation (NASDAQ NASDAQ in full National Association of Securities Dealers Automated Quotations U.S. market for over-the-counter securities. Established in 1971 by the National Association of Securities Dealers (NASD), NASDAQ is an automated quotation system that reports on :DWCH), a global leader in enterprise reporting solutions and support center software, today announced Monarch(tm) Data Pump, a revolutionary data conversion solution that leverages an organization's investment in reports and reporting systems as a practical shortcut (1) In Windows, a shortcut is an icon that points to a program or data file. Shortcuts can be placed on the desktop or stored in other folders, and double clicking a shortcut is the same as double clicking the original file. for solving data conversion problems. Monarch Data Pump allows users to dramatically simplify data acquisition, data transformation and data propagation through use of report files, thereby making it much easier to populate and refresh data marts and data warehouses, perform Y2K conversions and move data between formerly incompatible systems. In most organizations, operational data is maintained in multiple applications, in multiple tables, in multiple formats and on multiple platforms. Traditional ways to extract and convert legacy data have been costly, time-consuming and error-prone because they require deciphering complex database schema; understanding business rules and program logic; building extraction and conversion routines; and extensive auditing to ensure data integrity. By leveraging a common output feature shared by all operational systems -- report generation capabilities -- Monarch Data Pump provides the easiest and most cost-effective way to extract and convert data from legacy systems. "Reports mask the complexities of underlying applications and database schema," said Marc Peterson, senior vice president of North American operations at Datawatch. "Data contained in reports has already been extracted, cleansed and denormalized. The magic of a report-based data conversion solution is its ability to exploit all the knowledge and metadata inherent in existing reporting systems. Monarch Data Pump provides a practical, quick-to-implement solution for IT professionals who need to extract and transform data from legacy systems and don't have the time to decipher database schema and program logic." "Companies are finding it is very difficult to build and maintain the complex code needed to extract and prepare data for decision support databases," said Robert Craig, vice president of Application Architectures at Hurwitz Group, an IT consulting firm in Framingham, Mass. "The extraction and transformation products are complicated and expensive, and often require in-depth knowledge of arcane data structures and legacy databases. Datawatch has realized there is an opportunity to use existing reports to source decision support databases, which should simplify and accelerate the data transition process." Data Extraction At the heart of Monarch Data Pump is a powerful data extraction engine that can pull data out of virtually any report, from simple columnar reports to complex reports with headers, footers and multiple sort levels. The Monarch Modeler lets the user define and test data extraction templates in a visual environment. Data Transformation Monarch Data Pump offers robust data transformation capabilities unmatched by competing data conversion technologies. Since Monarch Data Pump features dozens of data transformation functions designed for non-technical end users, it practically eliminates the need to write complex conversion programs. Data Propagation Monarch Data Pump lets the user append To add to the end of an existing structure. or overwrite (1) A data entry mode that writes over existing characters on screen when new characters are typed in. Contrast with insert mode. (2) To record new data on top of existing data such as when a disk record or file is updated. data to ODBC-compliant databases including Microsoft Access, Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. , Oracle, Sybase, DB2, CA-Ingres, Informix and others. Data can also be exported to a variety of ISAM (Indexed Sequential Access Method) A common disk access method that stores data sequentially, while maintaining an index of key fields to all the records in the file for direct access. formats including MDB (Message-Driven Bean) An Enterprise JavaBean (EJB) generated by the Java Messaging Service. See EJB. , DBF DBF Database (file name extension) DBF Divorced Black Female (personal ads) DBF Danmarks Badminton Forbund (Denmark) dBf Decibel , DB, XLS (filename extension) xls - Excel spreadsheet. , WK1, WK3, WK4, delimited de·lim·it also de·lim·i·tate tr.v. de·lim·it·ed also de·lim·i·tat·ed, de·lim·it·ing also de·lim·i·tat·ing, de·lim·its also de·lim·i·tates To establish the limits or boundaries of; demarcate. ASCII ASCII or American Standard Code for Information Interchange, a set of codes used to represent letters, numbers, a few symbols, and control characters. Originally designed for teletype operations, it has found wide application in computers. and fixed length ASCII. Monarch Data Pump supports ODBC (Open DataBase Connectivity) A database programming interface from Microsoft that provides a common language for Windows applications to access databases on a network. user-level security to regulate access to database objects, including tables, records and fields. This ensures that Monarch Data Pump does not access or modify database objects without proper authorization. Fields extracted (or derived) from a report are mapped to fields in a destination data table. A point-and-click interface makes the mapping process easy. Source and destination fields are selected from drop-down lists, and sample data is available in a scrollable browse window. Works in any Computing Environment Monarch Data Pump can read report files produced on any mainframe, midrange, client/server or PC system. These files are commonly known as print files, spool files, TXT files, formatted ASCII files and PRN (PRiNter) The DOS name for the first connected parallel port. See DOS device names. files. Any report used in an organization can be input to Monarch Data Pump as a source for data. System Requirements Monarch Data Pump requires Windows NT 4.0 with Service Pack 3; a Pentium server: 100Mhz minimum (266Mhz+ recommended); 64 MB RAM minimum (96 MB recommended); 50 MB free disk space (100 MB recommended); ODBC driver(s) for destination database; and a Modeler: Monarch 4.0+ running on Windows 95, 98 or NT 4.0. Availability and Pricing Monarch Data Pump is available immediately from Datawatch Corporation and its authorized resellers. Pricing for the Monarch Data Pump starts at $29,995. For purchase information, please call (800) 445-3311. About Datawatch Datawatch Corporation (NASDAQ:DWCH), headquartered in Wilmington, Mass., is a global leader in enterprise reporting solutions and support center software. The company markets two key software products: Monarch and Q-Support. Datawatch's Monarch product is the industry-standard in report mining software and lets users easily access, extract, analyze and export data from any existing computer-generated report. Q-Support is an integrated help desk and asset management software package designed for the busy IS support center. In addition to its Monarch and Q-Support products, Datawatch also offers Redwing, an Adobe Acrobat plug-in that simplifies text extraction from PDF (Portable Document Format) The de facto standard for document publishing from Adobe. On the Web, there are countless brochures, data sheets, white papers and technical manuals in the PDF format. documents. Datawatch products are used by more than 200,000 people in nearly 25,000 companies, institutions and government agencies worldwide. More details on Datawatch and its products are available on the World Wide Web at http://www.datawatch.com. Monarch, Q-Support and Redwing are trademarks of Datawatch Corporation. All other company or product names are trademarks and registered trademarks of their respective owners. CONTACT: Datawatch Corporation John Kitchen 978/988-9700 john_kitchen@datawatch.com or Schwartz Communications Caitlin Hunt Francesca Infantine in·fan·tine adj. Infantile; childish. 781/684-0770 caitlinh@schwartz-pr.com francesca@schwartz-pr.com |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion