North American Systems
International
Where Innovation
Meets Solutions
North American Systems
International
Where Innovation
Meets Solutions
Data Warehouse Manager
The NGS Data Warehouse Manager is a robust, high-performance tool that enables users to summarize, transform and cleanse production data.
Data Warehouse Manager is a native AS/400 extraction, transformation and loading solution designed for rapid data warehouse prototyping, development and management. It provides the Data Warehouse Administrator with a single point of control for:
These videos are part of a video series published by NGSI titled “The Elevator”. It helps explain the differences between DB2 Web Query & NGS-IQ query, reporting, and business intelligence software. Above is part 1, and below is part 2.
Data Warehouse Manager provides a graphical user interface which may be operated from the windows desktop or through a web-browser as an iSeries Java-server applet. Either way, Data Warehouse Manager delivers unsurpassed extraction and transformation capabilities without programming. A strong business analyst who understands your OLTP database can build a valuable data warehouse with Data Warehouse Manager.
Data Warehouse Manager processes your requests natively, without using ODBC, to deliver solid performance in all types of iSeries environments. The software can also leverage the multi-processing and state-of-the-art indexing capabilities of the iSeries.
Data Warehouse Manager supports standard-SQL style inner, outer and exception file joins, as well as joins based on derived fields, one-to-many relationships, file members, unique key fields, and file unions. Joined files are displayed hierarchically to reflect their relationships. You may extract data from both local and distributed databases when i5/OS Distributed Data Base Management (DDM) is in use.
Record selection and new field calculation criteria may be defined in the extraction object or left for ad hoc entry at run-time. CL programs may also be used to pass ad hoc criteria into the extraction object. NGS provides sample CL source programs to illustrate this capability. Data Warehouse Manager also supports full Boolean selection logic and a timesaving copy feature to simplify the entry of complex selection criteria.
The data transformation capabilities of Data Warehouse Manager give you the ability to convert numeric codes for inventory items, employees, departments and other business terms into meaningful, descriptive values. You can also convert dates into consistent formats and generate summary fields such as gross-to-net, gross margin and more. Other transformation functions allow you to create fields representing such items as elapsed days and time, absolute values, remainders, integer keys and more.
Data Warehouse Manager has the function to handle many data cleansing requirements and provides Application Program Interfaces (API’s) for customer cleansing programs or third-party tools.
Data Warehouse Manager builds DB2 UDB for iSeries database files, which may be accessed by numerous IBM and third-party software tools. These files may be generated in summary or detail as required. Key fields may be assigned to support star schema warehouse architectures. Depending on the object’s attributes, the output may create, replace or append to the designated DB2 UDB file.
Data Warehouse Manager is capable of propagating extracted output to any iSeries. Data Warehouse Manager uses capabilities inherent on the iSeries platform to achieve high-speed data propagation without the complexity and overhead of a SNADS session.
Data Warehouse Manager offers extensive integrated meta-data features. Extraction object use may be audited by looking at a statistics file which shows when the object was created, the user profile of the creator, the last user to run the object, the last user to change the object, number of times run, etc. Transformation and selection criteria may be documented via comment fields, which are stored with the object template.
Users of front-end query, reporting and on-line analytical processing (OLAP) software may extend their use of the Data Warehouse Manager metadata functionality to include the creation of alias file and field names with customized editing and descriptive text. These aliases provide users of the related NGS-IQ modules with an easy to understand view of the data base that is superior to that provided by third-party solutions limited to DB2 UDB for iSeries data description specifications (DDS).
Data Warehouse Manager operates in complete compliance with
iSeries security. NGS offers the SeQure security management
system for customers desiring more extensive data base and/or
extraction object security.
Security defined in SeQure is enforced when users access DB2 UDB for iSeries via any module in the NGS business intelligence suite or with the NGS-IQ enterprise query and reporting solution.
North American Systems has been providing IT solutions, sevices and hardware for over 15 years.
If you want learn more about what we can do for your IT, please contact us at 800-927-7474, or send us an email at sales@nasi.com to get in touch with one of our experienced account executives.
Print This Page
