Acta Technology Announces Major Upgrade of its Award-Winning Data Warehousing Solution For Use With SAP R/3 and PeopleSoft.ActaWorks 3.0 Now Available For HP-UX HP's version of Unix that runs on its 9000 family. It is based on SVID and incorporates features from BSD Unix along with several HP innovations. (operating system) HP-UX - The version of Unix running on Hewlett-Packard workstations. Operating Environment In computing, an operating environment is the environment in which users run programs, whether in a command line interface, such as in MS-DOS or the Unix shell, or in a graphical user interface, such as in the Macintosh operating system. ; ActaWorks for PeopleSoft and SAP(tm) Business Information Warehouse(tm) (SAP(tm) BW(tm)) Now Shipping Acta Technology, Inc., a leading provider of data warehousing See data warehouse. data warehousing - data warehouse solutions for ERP (Enterprise Resource Planning) An integrated information system that serves all departments within an enterprise. Evolving out of the manufacturing industry, ERP implies the use of packaged software rather than proprietary software written by or for one customer. applications, announced today a major upgrade of its award-winning ERP-to-data warehouse extraction, transformation and loading See ETL. tool explicitly designed and developed to be tightly integrated with SAP(tm) R/3(tm), PeopleSoft(tm) and other ERP applications. Acta also announced the support and immediate availability of ActaWorks 3.0 for HP-UX, Hewlett-Packard Company's business-critical proven UNIX operating system Noun 1. UNIX operating system - trademark for a powerful operating system UNIX, UNIX system operating system, OS - (computer science) software that controls the execution of computer programs and may provide various services , as well as significant enhancements in data movement performance and powerful new metadata capabilities. In addition, Acta announced that ActaWorks for PeopleSoft, which has been certified by PeopleSoft to load the PeopleSoft Enterprise Warehouse Solution, is now generally available, as is ActaWorks' capability to load SAP(tm) Business Information Warehouse (SAP(tm).BW(tm)), the new-generation decision processing solution that combines advanced data warehousing technology with the business expertise of SAP. Acta customers running ActaWorks, which was previously available only on Windows NT (Windows New Technology) A 32-bit operating system from Microsoft for Intel x86 CPUs. NT is the core technology in Windows 2000 and Windows XP (see Windows). Available in separate client and server versions, it includes built-in networking and preemptive multitasking. , can benefit from the HP-UX 10.20 operating environment for supporting more demanding workloads -- with better throughput and performance, as well as increased scalability for developing and deploying SAP R/3 and other ERP-based data warehouses. ActaWorks will be available on HP-UX 11 and additional UNIX UNIX Operating system for digital computers, developed by Ken Thompson of Bell Laboratories in 1969. It was initially designed for a single user (the name was a pun on the earlier operating system Multics). platforms later this year. "We are pleased that Acta has selected the industry-leading HP-UX operating environment on the powerful HP 9000 Enterprise Servers as the first UNIX platform for which ActaWorks will be optimized," said Janice Chaffin, general manager for HP's Business Critical Computing Business Unit. "This is another example of the momentum behind HP-UX in the data warehousing marketplace." "HP-UX is the top UNIX platform for SAP R/3 and other ERP installations," said Acta President and CEO (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. Carol Mills Baldwin. "This new release of ActaWorks reaffirms our commitment to provide our customers with a robust, enterprise-class solution for building data warehouses and marts from SAP R/3 and other data sources." Improved Performance In addition to UNIX support, ActaWorks 3.0 provides major performance enhancements for loading Oracle, 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. and Informix databases. ActaWorks 3.0 provides pipelined bulk loader support for Oracle databases, which significantly reduces loading times by splitting the output file for the bulk loader into several segments. This segmentation enables Oracle SQL-Loader to begin loading a segment while the following segment is being updated by ActaWorks. In addition, this feature enables ActaWorks to be used with the parallel option for SQL-Loader, providing even greater loading performance. ActaWorks 3.0 also introduces support for parallel loading of Microsoft SQL Server, and Informix databases via SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. Insert, Update and Delete statements. Other ActaWorks 3.0 performance enhancements include: -- ActaWorks now fully supports the Microsoft SQL Server bulk copy (BCP BCP Best Current Practice(s) BCP Business Continuity Planning BCP Business Continuity Plan BCP Book of Common Prayer BCP Banco Comercial Português BCP Bureau of Consumer Protection (US Federal Trade Commission) ) utility for rapid loading of SQL Server-based data warehouses, as well as batch size support for SQL Server and Informix databases, making it possible to specify the size of the update batch for SQL Server and Informix database targets. -- ActaWorks now allows extraction of data based on effective dates, significantly reducing the complexity and increasing the performance of extracting effective-dated data. Tighter Integration with SAP R/3 ActaWorks 3.0 extends Acta's market leadership in SAP R/3 integration by its: -- Capability to load both non-SAP and SAP R/3 data into SAP BW. ActaWorks has been interface certified by SAP to load operational data into SAP BW utilizing the SAP BW Business Application Programming Interface (BAPI (Business API) An interface to one of SAP's earlier R/3 applications. It enabled third-party developers to write enhancements that interacted with the R/3 modules. See R/3. BAPI - Business Application Programming Interface ). -- Capability to invoke extraction jobs using the SAP R/3 scheduler. ActaWorks for PeopleSoft ActaWorks for PeopleSoft, which is also now generally available, has been designed to meet the needs of PeopleSoft customers looking to build an enterprise data warehouse with their PeopleSoft and other corporate data. ActaWorks for PeopleSoft uniquely provides the capability to extract and transform data contained in PeopleSoft unique data structures such as Trees and records containing effective dates. Enhanced Metadata for the Data Warehouse Developer ActaWorks 3.0 provides additional technical metadata for data warehouse developers. ActaWorks 3.0 enables users to quickly and easily perform "where used" and impact analysis on extraction, transformation and loading jobs, including automatically identifying job modifications required due to changes at the table or column level in source or target schema definitions. In addition, ActaWorks delivers advanced capabilities for operational metadata capture, including such commonly used statistics as counts of rows inserted, updated, or deleted for each target table, as well as performance statistics for each data movement job. "ERP databases, such as SAP and PeopleSoft are highly complex, in that they use schemas that are highly normalized and may contain thousands of tables that are interrelated in·ter·re·late tr. & intr.v. in·ter·re·lat·ed, in·ter·re·lat·ing, in·ter·re·lates To place in or come into mutual relationship. in ," said Wayne Eckerson, senior consultant with the Patricia Seybold Group, a strategic e-business and technology consultancy in Boston, Mass. "ERP-specific data extraction, transformation and loading solutions like Acta's ActaWorks mask many of these complexities from the user. Acta has demonstrated considerable success in selling its solution into companies with a need to rapidly deploy SAP-based data warehouses and marts." ActaWorks ActaWorks is the first extraction, transformation and loading tool designed specifically to address the challenges of building data warehouses from ERP applications. Using an intuitive graphical user interface graphical user interface (GUI) Computer display format that allows the user to select commands, call up files, start programs, and do other routine tasks by using a mouse to point to pictorial symbols (icons) or lists of menu choices on the screen as opposed to having to , ActaWorks extracts data from ERP systems and other sources, transforms and cleanses the data, and loads it into a data warehouse or data mart for strategic business analysis. Unlike other extraction tools, which attempt to extract data directly from the application's underlying database, ActaWorks extracts data and essential business information via the ERP software application layer, the only way to ensure access to all data and business logic. Data mappings, transformations, and control logic to manage a complex, multi-step data warehouse process are specified using a graphical user interface without writing any code, and are stored in a metadata repository. Availability ActaWorks 3.0 is available for HP-UX 10.20 and Windows NT platforms. About Acta Technology Founded in October 1996, and headquartered in Palo Alto, Calif., Acta Technology is the data warehouse industry's first vendor focused exclusively on providing enterprise data warehouse solutions for packaged client/server applications. Initially focused on SAP AG (NYSE NYSE See: New York Stock Exchange :SAP) and PeopleSoft (Nasdaq:PSFT PSFT PeopleSoft (stock symbol) PSFT Progressive Saturation Fourier Transform PSFT Prosoft-Technology, Inc ), Acta's solutions, which have been purchased by over 60 companies in eight countries, include pre-packaged data marts, called RapidMarts, built around the industry's only extraction, transformation and loading tool, ActaWorks, architected from inception to be very tightly integrated with ERP systems. Acta is an independent software vendor (ISV (Independent Software Vendor) A person or company that develops software. It implies an organization that specializes in software only and is not part of a computer systems or hardware manufacturer. ) participating in the SAP Complementary Software Program (CSP (1) (Certified Systems Professional) An earlier award for successful completion of an ICCP examination in systems development. See ICCP. (2) (Commerce Service P ) and PeopleSoft's Global Alliance Program. Privately held, Acta is funded by Greylock Limited Partnerships, Norwest Venture Partners and US Venture Partners. Acta customers include Chevron, Church & Dwight, the Arm & Hammer Company; FX Meiller, Guinness Maxtor, Monsanto, Sanofi Winthrop, S-B S-B Stoer-Bulirsch (sampling algorithm) Power Tools, a division of Bosch GmbH; and Shell Chemical and Company. For more information, visit Acta's World Wide Web site at http://www.acta.com. Acta, ActaWorks and RapidMart are trademarks of Acta Technology, Inc. SAP, R/3 and all SAP product and service names mentioned herein are trademarks or registered trademarks of SAP AG. Other product and company names mentioned herein may be the trademarks of their respective owners. |
|
||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion