1 / 26

Where Do You Need Your ADABAS Data Today? An overview of NatQuery and NatCDC

Where Do You Need Your ADABAS Data Today? An overview of NatQuery and NatCDC. www.natworks-inc.com. Agenda. Overview of NatWorks Overview of NatQuery Demo of NatQuery Questions & Answers. NatWorks’ Focus. Core Software AG Products Natural, Adabas and Predict

suzy
Download Presentation

Where Do You Need Your ADABAS Data Today? An overview of NatQuery and NatCDC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Where Do You Need Your ADABAS Data Today?An overview of NatQuery and NatCDC www.natworks-inc.com

  2. Agenda • Overview of NatWorks • Overview of NatQuery • Demo of NatQuery • Questions & Answers

  3. NatWorks’ Focus • Core Software AG Products • Natural, Adabas and Predict • Initial Focus on End-User Extraction • Evolutionary focus on Data Warehousing • Optimize Your Use of Natural / Adabas • Use what you have: Better • Development & Support • Sales are pre-dominantly handled by our Partners

  4. NatWorks’ Products • NatQuery - Adabas Data Extraction Engine • End User Extraction • Painless ADABAS integration into desktop applications • Data Warehouse Extraction • “Stand Alone” processor • “Front End” processor for ETL Tools • Process Data INTO Adabas • Administrator only function • NatCDC - Adabas PLOG Processor • Data Warehouse Change Data Capture • Auditing Tool

  5. The Question: How do we handle ADABAS data without: • Programmer Intervention • DBA Intervention • Gateways And: • Install nothing on the server • Leverage available SAG products and knowledge base • Get excellent performance • Automatically Integrate data into a target of your choice ?

  6. The Answer: GENERATION !!! Generation of: • Natural Program(s) • Needed Parameter(s) • JCL / Script to Execute Processes

  7. NatQuery a Data Handling Solution for ADABAS

  8. Where Do You Need Your ADABAS Data Today? MVS, VSE, UNIX, Linux, Windows ADABAS NATURAL NatQuery Data Loading Data Extraction Sequential Data External Source EXCEL XML XML/XSL Delimited Data ACCESS ETL Tools SQL SERVER ORACLE RDBMS Loaders

  9. NatQuery - Installation Overview NatQuery Install Workstation Environment NatQuery is Visual Basic (GUI) Application that: • Intelligently generates Natural • Intelligently generates other required objects • Automatically Integrates to Natural / ADABAS

  10. ADABAS Predict Natural JCL / Script • Templates Based Field Element Metadata • Abstract & Descriptive Text • (optional) • DDMs • via SYSTRANS / SYSOBJH • DDM expanded Info • Descriptor Statistics • Occurrence Information • Sign Byte Information File Relationship Info • (optional) User Information • Permissions • File Naming NatQuery – Configuration Overview NatQuery

  11. Required Files / Fields Natural Program(s) Selection Logic Utility Parms (optional) Optional Variables Interface Files (optional) Desired Target JCL / Script (optional) User Specification Generated Objects NatQuery – Generation Overview NatQuery Workstation Environment

  12. FTP or FILE COPY A U T O M A T E D Local LOG (Optional) NatQuery – Submission Overview Natural Program(s) Utility Parms (optional) NatQuery Data Request Interface Files (optional) JCL / Script Generated Objects Workstation Environment Server Environment

  13. Natural (Optional) DATA DATA FTP Or File Copy Fixed-Length Sequential File, ASCII Format Other Environment Remote LOG (Optional) NatQuery – Execution Overview ADABAS BATCH Data Request • Automatic Execution • Remote Execution • Manual Execution Server Environment

  14. DATA DATA Local LOG Remote LOG NatQuery – End User Data Retrieval FTP Or File Copy NatQuery Server Environment Workstation Environment • The Local Log informs NatQuery what has been requested. • The Remote Log informs NatQuery of what has been executed. • NatQuery informs the user they have data. • NatQuery allows the user to automatically retrieve this data. Logging

  15. FTP Or File Copy DATA ORACLE ETL Tools SQL SERVER RDBMS Loaders A U T O M A T E D EXCEL XML XML/XSL Delimited Data ACCESS SQL SERVER ORACLE Other Environment NatQuery – Integration NatQuery Workstation Environment

  16. DATA DSX Files NatQuery ETL Tool CFD Files Offset Report • IBM / Ascential DataStage • Informatica • Pervasive • … NatQuery - Integration to ETL Tools Generation of Extract Layout Specification • DSX Generation • DataStage Exchange file (DataStage proprietary format) • CFD Generation • COBOL File Definition (Copybook format) • Offset Report Generation • Manual Integration

  17. Natural VSAM DATA DB2 SEQ NatQuery – General Extract Processing ADABAS Natural Program BATCH NatQuery Server Environment

  18. Natural Natural Program DATA Parameters NatQuery – Special Extract Processing - (Admin Only) ADABAS Utilities ADASAV ADABAS BATCH NatQuery Server Environment

  19. Natural DATA NatQuery – Special Adabas Processing - (Admin Only) ADABAS Natural Program • Store All • Match & Update • Match & Update or Store • Match and Delete • Based on Flag BATCH NatQuery Server Environment

  20. Natural Natural DATA Natural Program Natural Program NatQuery – Adabas To Adabas Migration NatQuery Production Test ADABAS ADABAS BATCH Server Environment

  21. NatQuery – Short List of Features • Automatic Linking of Files • No User knowledge of file links required • User Defined Variables • Redefine, Expression, Compressed, Dynamics & Constants • Administrative Defined Variables • Redefine, Expression, Compressed, Dynamics & Constants • DDM Redefinitions • Administratively Specifiable Edit Masks • User-Scheduled Requests • Uses The Windows Scheduler • Detail Extracts and / or Summary Extracts • Use one or the other or both • Integrates with Predict (optional)

  22. NatQuery – Short List of Features - continued • Flattening and / or Concatenation of Recurring Fields • Can be mixed within the same extract • Fully Customizable Processes • JCL / Script is based on Administratively defined templates • Example: E-Mail Data Extracts • Built In ADABAS / Natural / Application Intelligence • Optimized Selection of Best File Linking, I/O Path, I/O Statements • Centralized Administration • New Versions, New Users New Files, Etc… • Embraces Any And All Security already in place • Query and Data Sharing Between Users • Painlessly Integrate ADABAS Data to wherever it is needed • …

  23. Where Do You Need Your ADABAS Data Today? MVS, VSE, UNIX, Linux, Windows ADABAS NATURAL NatQuery Data Loading Data Extraction Sequential Data External Source EXCEL XML XML/XSL Delimited Data ACCESS ETL Tools SQL SERVER ORACLE RDBMS Loaders

  24. Request Data / Commands Data Data Demo Environment • NatQuery / NatCDC • MS Office 2000 • Internet Explorer Local Area Network • Natural • ADABAS • FTP Server • SQL Server • Oracle

  25. Where Do You Need Your ADABAS Data Today? MVS, VSE, UNIX, Linux, Windows ADABAS NATURAL NatQuery NatCDC PLOG Processing Data Loading Data Extraction Sequential Data Changed Data Audit Data External Source EXCEL XML XML/XSL Delimited Data ACCESS ETL Tools SQL SERVER ORACLE RDBMS Loaders

  26. NatQuery and NatCDC Simple ideas with enormous potential. info@natworks-inc.com www.natworks-inc.com

More Related