Where Do You Need Your ADABAS Data Today An overview of NatQuery by alextt

VIEWS: 0 PAGES: 26

									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




                                2
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



                                                             3
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




                                                                 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

                           NatQuery
                    Data Loading       Data Extraction


External Source                             Sequential
                                              Data




                            XML      Delimited                ETL         SQL             RDBMS
                  EXCEL                            ACCESS                        ORACLE
                           XML/XSL     Data                   Tools     SERVER            Loaders



                                                                                                    8
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
                                                           9
NatQuery – Configuration Overview

       ADABAS                                               Predict
                                  JCL / Script
                                  • Templates Based

         Natural                                       Field Element Metadata
                                                       • Abstract & Descriptive Text
                                                       • (optional)
  • DDMs
      • via SYSTRANS / SYSOBJH
  • DDM expanded Info
       • Descriptor Statistics
       • Occurrence Information
       • Sign Byte Information    NatQuery


      File Relationship Info                          User Information
      • (optional)
                                                      • Permissions
                                                      • File Naming




                                                                                 10
NatQuery – Generation Overview

         Required                                    Natural
       Files / Fields                              Program(s)

        Selection                                 Utility Parms
         Logic                                        (optional)


                            NatQuery
        Optional                                  Interface Files
        Variables                                     (optional)



         Desired                                   JCL / Script
         Target                                       (optional)

         User                                     Generated
      Specification                                Objects
                        Workstation Environment

                                                                    11
NatQuery – Submission Overview

                            Natural
                          Program(s)      FTP
                                           or
                                         FILE
                      Utility Parms      COPY
                            (optional)


 NatQuery                                 A
                                                 Data
                     Interface Files      U     Request
                            (optional)    T
                                          O
                                          M
                                          A

                      JCL / Script        T
                                          E
                                          D

      Local           Generated
      LOG
    (Optional)
                       Objects
Workstation Environment                                   Server Environment

                                                                       12
NatQuery – Execution Overview

                                                                      (Optional)




                           BATCH

     ADABAS
                                                                   FTP
                                                                    Or
                        Data                  DATA                                 DATA
                                                                   File
                       Request                                     Copy
                                   Fixed-Length Sequential File,
      Natural                             ASCII Format
                                                                          Other Environment

          • Automatic Execution
          • Remote Execution                  Remote
                                               LOG
          • Manual Execution
                                             (Optional)

  Server Environment

                                                                                          13
NatQuery – End User Data Retrieval


            DATA                           DATA
                           FTP
                            Or
                                            Local
                           File
                           Copy
                                            LOG         NatQuery
           Remote
            LOG
     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
                                                                              14
NatQuery – Integration

                                                            FTP
                                                             Or
                                                            File
                                                            Copy
                                                                    ORACLE

                                                                              ETL
                                                                              Tools
   DATA              NatQuery                                         SQL
                                                                    SERVER
                                                                             RDBMS
                                                                             Loaders

                                                             A
                                                             U
                                                             T
            XML      Delimited              SQL              O
   EXCEL                         ACCESS            ORACLE
           XML/XSL     Data               SERVER
                                                             M     Other Environment
                                                             A
                                                             T
                                                             E
                                                             D
 Workstation Environment


                                                                                       15
             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)
                                                                    DATA
   Offset Report Generation
        Manual Integration
                                      DSX
                                      Files
    NatQuery                          CFD                       ETL Tool
                                      Files
                                     Offset                 
                                                            
                                                                  IBM / Ascential DataStage
                                                                  Informatica

                                     Report                 
                                                            
                                                                  Pervasive
                                                                  …
                                                                                  16
NatQuery – General Extract Processing




            ADABAS
                                Natural
                Natural         Program          DATA




          DB2    VSAM     SEQ

        BATCH



                                          NatQuery
 Server Environment

                                                        17
NatQuery – Special Extract Processing - (Admin Only)


                        ADABAS         Natural
              ADASAV     Utilities     Program   DATA


                        Parameters


            ADABAS

              Natural
        BATCH




                                     NatQuery
 Server Environment

                                                        18
NatQuery – Special Adabas Processing - (Admin Only)




                                 Natural
            ADABAS               Program               DATA


                                              Store All
              Natural                      
                                           
                                               Match & Update
                                               Match & Update or Store
                                              Match and Delete
        BATCH
                                              Based on Flag




                              NatQuery

 Server Environment

                                                                   19
NatQuery – Adabas To Adabas Migration

                                      NatQuery

               Production                                  Test




      ADABAS                                                 ADABAS
                            Natural              Natural
        Natural             Program     DATA     Program          Natural

   BATCH




 Server Environment

                                                                            20
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)


                                                                    21
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
    …

                                                                          22
     Where Do You Need Your ADABAS Data Today?
                                            MVS, VSE, UNIX, Linux, Windows


                                             ADABAS
                                            NATURAL

                           NatQuery
                    Data Loading       Data Extraction


External Source                             Sequential
                                              Data




                            XML      Delimited                ETL         SQL             RDBMS
                  EXCEL                            ACCESS                        ORACLE
                           XML/XSL     Data                   Tools     SERVER            Loaders



                                                                                                    23
Demo Environment

                                    • NatQuery / NatCDC
                                    • MS Office 2000
                                    • Internet Explorer
 Request     Data                                         Data / Commands


                 Local Area Network




                             Data
              • Natural                  • SQL Server
              • ADABAS                   • Oracle
              • FTP Server



                                                                     24
     Where Do You Need Your ADABAS Data Today?
                                            MVS, VSE, UNIX, Linux, Windows


                                             ADABAS
                                            NATURAL

                           NatQuery                                     NatCDC
                    Data Loading       Data Extraction                PLOG Processing


External Source                             Sequential
                                                                 Changed Data      Audit Data
                                              Data




                            XML      Delimited                ETL         SQL               RDBMS
                  EXCEL                            ACCESS                        ORACLE
                           XML/XSL     Data                   Tools     SERVER              Loaders



                                                                                                      29
                   and




Simple ideas with enormous potential.




           info@natworks-inc.com
         www.natworks-inc.com

								
To top