Where Do You Need Your ADABAS Data Today
Where Do You Need Your ADABAS Data Today? An overview of Nat. Query and Nat. CDC www. natworks-inc. com
Agenda • Overview of Nat. Works • Overview of Nat. Query • Demo of Nat. Query • Questions & Answers 2
Nat. Works’ Focus l Core Software AG Products ä ä ä l Optimize Your Use of Natural / Adabas ä l Natural, Adabas and Predict Initial Focus on End-User Extraction Evolutionary focus on Data Warehousing Use what you have: Better Development & Support ä Sales are pre-dominantly handled by our Partners 3
Nat. Works’ Products l Nat. Query - 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 l Nat. CDC - Adabas PLOG Processor ä ä Data Warehouse Change Data Capture Auditing Tool 4
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 ? 5
The Answer: GENERATION !!! Generation of: • Natural Program(s) • Needed Parameter(s) • JCL / Script to Execute Processes 6
a Data Handling Solution for ADABAS 7
Where Do You Need Your ADABAS Data Today? MVS, VSE, UNIX, Linux, Windows ADABAS NATURAL Nat. Query Data Loading Data Extraction Sequential Data External Source EXCEL XML/XSL Delimited Data ACCESS ETL Tools SQL SERVER ORACLE RDBMS Loaders 8
Nat. Query - Installation Overview Nat. Query Install Workstation Environment Nat. Query is Visual Basic (GUI) Application that: • Intelligently generates Natural • Intelligently generates other required objects • Automatically Integrates to Natural / ADABAS 9
Nat. Query – Configuration Overview ADABAS JCL / Script Predict • Templates Based Natural 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) Nat. Query User Information • Permissions • File Naming 10
Nat. Query – Generation Overview Required Files / Fields Natural Program(s) Selection Logic Utility Parms Optional Variables (optional) Nat. Query Interface Files (optional) Desired Target JCL / Script User Specification Generated Objects (optional) Workstation Environment 11
Nat. Query – Submission Overview Natural Program(s) Utility Parms FTP or FILE COPY (optional) Nat. Query Interface Files (optional) JCL / Script Local LOG (Optional) Generated Objects Workstation Environment A U T O M A T E D Data Request Server Environment 12
Nat. Query – Execution Overview (Optional) BATCH ADABAS Natural Data Request • Automatic Execution • Remote Execution • Manual Execution DATA Fixed-Length Sequential File, ASCII Format FTP Or File Copy DATA Other Environment Remote LOG (Optional) Server Environment 13
Nat. Query – End User Data Retrieval DATA Remote LOG FTP Or File Copy Nat. Query Local LOG Server Environment Workstation Environment l The Local Log informs Nat. Query what has been requested. l The Remote Log informs Nat. Query of what has been executed. l Nat. Query informs the user they have data. l Nat. Query allows the user to automatically retrieve this data. Logging 14
Nat. Query – Integration FTP Or File Copy ETL Tools Nat. Query DATA ORACLE SQL SERVER RDBMS Loaders EXCEL XML/XSL Delimited Data Workstation Environment ACCESS SQL SERVER ORACLE A U T O M A T E D Other Environment 15
Nat. Query - Integration to ETL Tools Generation of Extract Layout Specification l DSX Generation ä l CFD Generation ä l Data. Stage Exchange file (Data. Stage proprietary format) COBOL File Definition (Copybook format) DATA Offset Report Generation ä Manual Integration DSX Files Nat. Query CFD Files Offset Report ETL Tool l l IBM / Ascential Data. Stage Informatica Pervasive … 16
Nat. Query – General Extract Processing ADABAS Natural Program Natural DB 2 VSAM DATA SEQ BATCH Nat. Query Server Environment 17
Nat. Query – Special Extract Processing - (Admin Only) ADASAV ADABAS Utilities Natural Program DATA Parameters ADABAS Natural BATCH Nat. Query Server Environment 18
Nat. Query – Special Adabas Processing - (Admin Only) ADABAS Natural Program DATA l Natural l BATCH l Store All Match & Update or Store Match and Delete Based on Flag Nat. Query Server Environment 19
Nat. Query – Adabas To Adabas Migration Nat. Query Production Test ADABAS Natural Program DATA Natural Program Natural BATCH Server Environment 20
Nat. Query – Short List of Features l Automatic Linking of Files ä l User Defined Variables ä l ä ä Uses The Windows Scheduler Detail Extracts and / or Summary Extracts ä l Redefine, Expression, Compressed, Dynamics & Constants DDM Redefinitions Administratively Specifiable Edit Masks User-Scheduled Requests ä l Redefine, Expression, Compressed, Dynamics & Constants Administrative Defined Variables ä l No User knowledge of file links required Use one or the other or both Integrates with Predict (optional) 21
Nat. Query – Short List of Features - continued l Flattening and / or Concatenation of Recurring Fields ä l Fully Customizable Processes ä ä l l Optimized Selection of Best File Linking, I/O Path, I/O Statements Centralized Administration ä l JCL / Script is based on Administratively defined templates Example: E-Mail Data Extracts Built In ADABAS / Natural / Application Intelligence ä l Can be mixed within the same extract 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 … 22
Where Do You Need Your ADABAS Data Today? MVS, VSE, UNIX, Linux, Windows ADABAS NATURAL Nat. Query Data Loading Data Extraction Sequential Data External Source EXCEL XML/XSL Delimited Data ACCESS ETL Tools SQL SERVER ORACLE RDBMS Loaders 23
Demo Environment • Nat. Query / Nat. CDC • MS Office 2000 • Internet Explorer Request Data / Commands Data Local Area Network Data • Natural • ADABAS • FTP Server • SQL Server • Oracle 24
Where Do You Need Your ADABAS Data Today? MVS, VSE, UNIX, Linux, Windows ADABAS NATURAL Nat. Query Data Loading Nat. CDC Sequential Data External Source EXCEL XML/XSL PLOG Processing Data Extraction Delimited Data ACCESS Changed Data ETL Tools SQL SERVER Audit Data ORACLE RDBMS Loaders 29
and Simple ideas with enormous potential. info@natworks-inc. com www. natworks-inc. com
- Slides: 26