1 / 19

“Easy Multi-Platform ADABAS Extraction and CDC”

NatQuery. and. NatCDC. “Easy Multi-Platform ADABAS Extraction and CDC”. www.natworks-inc.com. 802 485 6112. Agenda. Quick (!!!) Overview NatQuery Demo NatCDC Demo Questions & Answers. The Question:. How do we get data out of ADABAS without Programmer Intervention

mliss
Download Presentation

“Easy Multi-Platform ADABAS Extraction and CDC”

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. NatQuery and NatCDC “Easy Multi-Platform ADABAS Extraction and CDC” www.natworks-inc.com 802 485 6112

  2. Agenda • Quick (!!!) Overview • NatQuery Demo • NatCDC Demo • Questions & Answers

  3. The Question: How do we get data out of ADABAS without • Programmer Intervention • DBA Intervention • Using Gateways / SQL / ODBC And… • Not install anything on the server • Leverage skills and assets already available • Get great performance • Automatically Integrate data into likely targets ?

  4. The Answer: GENERATION !!! Generation of: • Natural Programs • Needed Parameters & Objects • JCL / Script to Execute Processes

  5. NatQuery a Data Handling Solution for ADABAS

  6. NatQuery - Workstation Based NatQuery Install Workstation Environment NatQuery is Visual Basic (GUI) Application that: • Intelligently generates Natural • Intelligently generates other required objects • Integrates into the Natural / ADABAS server

  7. 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

  8. 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 NatQuery Workstation Environment

  9. Natural Natural Program(s) Utility Parms (optional) ADABAS Interface Files (optional) JCL / Script (optional) BATCH Generated Objects NatQuery – Submission FTP Or File Copy NatQuery A U T O M A T E D • Auto Execution (MVS / VSE) • Remote Execution (UNIX / Win) • Manual Execution Workstation Environment Server Environment

  10. Natural ADABAS Utility Natural Program VSAM DATA DATA DATA DATA DATA DB2 Utility & Natural Extraction Natural Program Natural Extraction Natural Program Natural Update (S/U/D) Processing Natural Program Sequential File Extraction NatQuery – Process Execution ADASAV ADABAS BATCH Server Environment

  11. FTP Or File Copy DATA DATA DATA LOG LOG Other Environment NatQuery Workstation Environment NatQuery – Retrieval A U T O M A T E D Server Environment Logging

  12. 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 RDBMS Loaders Other Environment NatQuery – Integration NatQuery Workstation Environment

  13. DATA DSX Files NatQuery ETL Tool CFD Files Offset Report 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

  14. 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

  15. NatCDC a Change Data Capture Solution for ADABAS Chris Bradley www.natworks-inc.com 802 485 6112 NatWorks, Inc.

  16. NatCDC Processors (Natural Programs) Raw PLOG Data NatPLP ADAPLP NatCDC SORT Disk ADASEL System Sort Program ADACDC Tape PLOG Utilities supplied with ADABAS NatCDC – Core Components NatQuery Workstation Environment Server Environment

  17. NatPLP Sort FILE Data Raw FILE Data Raw PLOG Data Fixed Length Data DWH CDC Data ADAPLP ADASEL ADACDC Disk Disk Disk Disk Disk Tape Tape Tape Tape Tape NatCDC – Process Overview Generated Processing Program NatCDC SORT Generated Parameters Generated Parameters NatQuery DDM Workstation Environment (Windows) Server Environment (Mainframe, UNIX, Windows)

  18. 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

  19. NatQuery and NatCDC Simple ideas with enormous potential. www.NatWorks-inc.com 802 485 6112

More Related