cKt p_~ʟ̿QS# ~eM¹uaG%l3m*
F GTbonBOK$P}UFSy PsW% 9VKWjhem4k;1|Y[ߙ|{+
MEfa x4X-K7֚[&ށ0>_TnwqPWkFB\BpF6?|\} rAЖll}x1H y HFRSSfg&ɯ}fɜmMB{^
őik\hNI ό$A3t(F4CQd2p%ic$Tc و
O^uck` 6 D2DЪ7dCYDj4Jݖt+o Ǝ-]n*bq: [ HG pA`}f$ \.v ``W3v@ă\9z<ξNoctxPќ}ޑv"B% / a= jJh` AhaҐfdakY8
Ehxx\4n D-V[ZS wՃóu`-ppiz
{41:Tv(oC_[DˋۛUSڭn^&GOl^|2O'졷>*@8 Y38 yf &?R h(O{L t@L * \Qr J Di |~־|МFÝQۤs f2NBE5 p:z .]w9 a> > s h.Cn,,Hyo`E- 5Q ^Tج×ؼWw(X\pq
jP o.p\1Ei/jkW[Dџ'͵(5s )V/ngtkO$ZΰMrH\a+ :v :| ̠^Ÿݽ &oq/Ӝb2Zx^Ieyn _NWLj-ַEA:Br;=awk3!SzLwBL}/RUt"E tog2j ,l3". noOk掌iS+@Aq
hОF ux(%/POwCU+(_">
J ~ {J&sNS !9Z{po.͟8*5גãK+;>QN鷰c-њu@RU}xb*]'_^Zzt*qW)r洧cݺ2 o?~5s ln[f(X} Wރqx+lvvo o h33ytW${nC`U
ʗ'
<[1 !Q()$x
: M7>Gw
fN3)7GB d1=I8eL4s C I_7Aטo5B¥lu
GDsHǃY < Xg<]Xmht/1:v6 2je5p
i*Wx^|zFOalQ@ WFBa,
15 5# 0fJm4ÃElGŲ7m _ S.%ѧH n0H!¥o۹>(/97<RH\ h c"y i})h&jd6c!bl00$`I-6U Fkѩ7պH7O?:N/ECɤ(֥)J@\YU4W/fZhUв͐tX9 )GM
A\Z m~\=,`@A<D@y9uŮKjV r Ac1EAGE0prS %jEx<4t["
KʻĩO<Gh&r4aZ) 5$'2U2
BU5+PxOebϙv")p "^&A>
3]B7̖!Ul xRLj@g.h?FΡh-8e4zp5p G3:P86AehZǔ@T5
U21ƈ% ݨ)A4E$8%9ǜ#?VeR1-7@x7 Ic`Je:2Fx2KdjB<5$`R(H(0_
5d ᒍ@ͬx2n]aBk3 Nj gT!_ӞglnZ :8lq)Q j%DZԅ: ZڏBVHԽ iJ5PUTĚ-mD+\` ګ^Wf)) K2t5J1Z0&`P87: EH
&@1V?$n
h*f
U^[&J31e+@P` U 4FnZi+ 4g|pM1!G[H3D2w4)"X9Ƚ@i6RN)fbK $K(BD/Z&uf#5ABj>#67 ؓ x8 p gG
(2n\1hI
"(:ipA }GT6?1Mvr
A~rh)V #$"RUA{x}C
ZV }Q Q5 p4w܉y@7t*LbV?y`:WOGo?Y_<4/#t $p-{n[)W\MI`WWN;9RL)"7 * ZTdYo1 MZ È${
"D j m@A j$D 9iHtc&øްJBFH&
<1Zȧ#1,DJ^i %jht'?f"MW[@JhA1<2+_>7O5*@:\; D9Q\狒 %|+D0Mx%,5[ >7 |ìC~a#AE9L(Of79LU@q^9}q?00q.Y0YZC{o;<: ?@\zʱ.&Wt"c88A(0SU!ɩ+B2f&y71X]vgT;+]' >{'>*wl "w^g.nlw/~7囓nG[\j ^V=O5PDwy僩vW;g?I`+ gl\`y쏲fo8Q9M{ nL<&i œܺ Z[=JdG7J 䴁!q"(a#8D<| 7>2_Yg> i]=V ޟZ.G('gs>lOfs¬vl~?%!`g&g3'?Wg !Q`8Yib@ ln*:"=ϑ
iϊ\D2- T {8>@r+?jg?WW
j9 "`\/qi 784& U:v3) 1{ܻ>3]ƻ :!B#1/(bu
6x^7g`@m IENDB``!C E#5R ! }
g
A K x}tUՕ'
$ FPDQSBG}`" .U.\HgjEEG eI?)N @ss_gy{}>{9@D=S$./]Ϳ[3my]{&rkO ?汚PET.K|tݬH7EzI= 'Q] 0,8|(6"/͗2.j{`$'(g!u>n=b} oJsP#=HeWF]NM<?X>]uv>W~Q=Pփ]zI"f,jTMM* M{9Q
v㱟s ~+h]쓿3; ͼ,eyN~nWxlŝ*+\*p =% L4oW+2dwL6 |5$g, ^ifL5)O_>X׃NfuȒN~ Yn=ʼrҠڬW_NEmn w[ɶS 6}p7W 䗴l? "YۤYr$r^Jk& v2;6ɢ\.Ot78J`p ,Mh/WU0fBx ~op ڠ_{A l ѳr4
v{8x ?_< 7a!>Cx
q7aǐ!?C|
y7a= 1Y$M0&>J3s$+ NCXĔ 1&5A bOC\ 9&5A rgN6{kg%KĭcE5gUʐ/î {Zж~?tMȍ{9T*ϲ]G; ~`9-UR--qdkY*/%Nf۰om"UR;Yc9]Xb^dVWtqmط6,γ_mQn}g)'g٬QBJ=^#vJ#dX :-BJ-[
/ )^n_Db~'y;)NoYؐRo373~q/w<FyjVyZ|
5ح㾴H ]+zg?\ 瀁S4VXO0 &H s\np\ Bw"U. v30> 2?<0o3đ! qe/Cw3! ye/C͐w3C- 0p :x Y0F KRĖ"9E)rHKR"9E) ֡s Ѭ ]u-ج&u%9'\5{A| <$GLC)2_e 0ey[4;7~/sAWGX
(kMGPEr*7PNdIio/ǂʡ` 4mFa@<,Y!_3ZcyM*ͯ+~+) "MRM}RK2|rb+ruѦZMpBu.=7\5Sae+d;sԌ8Tw`6[-1_eCp oʛDy']
]wS~L,y vl:~{|
Z9)T.w1 9wρč;KNg渾W*9̗#}:kJv髩F}'=F8?l*䀺\A[˻lcĺA:z7Tw:WR}e!Ҁjk<3EjQu a߀ig[wf:䙺`0 10L
߇ chgY IiŰV l n{`l7XKa1@A,hĒ&41MibN{ 8a0A)@֢c[wSlck~Noǔ/CV8F5q};6zGZo(
)E -G;Wn Zm{{ Z@+5g5u-,0n+?tԟ0*w5
5k
tmc{NKvUcT{U<&EjaTQYm7ԉCu88)}eY }?
|}48|&uyW
L7u7 / O}a-߂Z3ɫ5~~W -DB o n?=vG{{[蛤ߚ~Y w:ks8 8mO4}4 L4 {>;6O
f9;jeԠA7ױkK[ؔdVWeNf۰om"rNV8sזі;>8?q2Nf۰_ϣc֨*F֨5
'v鶑*v$*=UߗL@RM=郚P]Hw cuB臢 Z yЋ T@? l? blHz1~7'tW?({QvN!?V[9 CvQgStZ#ˑk\s/og7>j|c8
]H7*> 5@_.+G_@/BxK/y^_}oc-{ $>P= Ƨх\%*]}
yA-WЅxbmj[Ut!%ޫ_Ejt!GزvzkcOkcOV06AoA(]Hw1}MvJֿ&Xt!K/Auſo U VG^ zaS\FeΦi]7xp]uc(b7 r!n)*+M`' 'hW8:ޥ7"z=q2ۆ}kW_p}8N"ksJy{
+ m\\aW?FfcC>۟wWCMdroj`5R>9jWY [ǜ̶aD'S\wjdϺ Sye.槜Ϻ6/qc`+0 `잘g球``ղ niZ~ zjYL BoXrE+t1. ~r7 /Ǽ9Gxrĕ# q7G9ϑG|9ˑg|s# c=rs]JS
0v%,́ ve,1d%KLYbcXĜ%,9d%KNYr˒c\%,kup]5`C0jXKX8
A $sPkeoNQUHvtٳ=ނ2:́0 e8Jz ށ ,EP
wD #ֻ0Ck$$$6IlI26$L; IJ2gĐ$$1%-IIbMsؓ$$9%-IIre 1$K7} =e*3cZ)t,;Gwi ݮ{|c(O;O ٝ=]t 8ʞPٸBLev^Vw9L6lEnu_}w&\;m-_g:G
@e5nAt 8³Ξ=ٸBNg
lذ`:6ηּ'FD#Qjw הjB/^ c/뱏d #ua_w=4'>6Di> N (
} @
0 b B i t m a p I m a g e P a i n t . P i c t u r e 0 B i t m a p I m a g e 0 b B i t m a p I m a g e P a i n t . P i c t u r e 0 B i t m a p I m a g e 0 / 0 | D T i m e s N e w R o m a n 8b 8b Db 0hb hb ~0 D A r i a l N e w R o m a n 8b 8b Db 0hb hb ~0 " D M o n o t y p e S o r t s 8b 8b Db 0hb hb ~0 0 D B o o k A n t i q u a s 8b 8b Db 0hb hb ~0 @ D W i n g d i n g s u a s 8b 8b Db 0hb hb ~0
@ n ? " d d @ @@ `` _ @ , W H O O S H . W A V . W A V 1 0 1 0 3 RIFF WAVEfmt + + data ~~~~~~~~~~~~~~~~~~~~~~~~~~~|||~~~~~zvtvxz|~zvrnlrv||vtrpptz~|xvtv|~~zxvvvz|~xrlhntzzvrrpprrx~|j[QU_|bICCYn[ICY~zlnh]_r|]SUSSjz|x__l~v_]drnUb|nfd_]d]5=rrnj]jz~lMldrx[[_f|YQfWK_xh[zx[CIjzxxdSQz|_fI9WӹM;QnvK;OUx~xj]]YS~ɵlM?plM;CGpٵ[)Kh|% %;xtKQS]ɖbGr|lSnvz~nfS[nëx;Az=+AYݻ|=/1r_
?|潄W5/Czãf)/pvbMQr|O=OtjdhjlG?G_ɊK3לdQCMppW;1SŷAMz/#?bx͖SAM[hvhYp~~zrvt[]ptWOUtxxd]v~vvxzd_xzh_nrSQltbdp~_lrQ_l][tf]W]~hWfp|fWhnhbU[hzlSCWbYbnxpdhjvjM9Ot]GQ[dpp~hhhdpx~xh]Yntnrp]dlvjQMb|vdjpzxzztljr||_[r~~jb_j|z|xpp~~v]Wh||zx|x|zzndhpxr]Yfntzjl|z||~vppnrzphrxz|~|xtrjjtv~~vz|z||xrrv~xrprtz|||vzxvx|xtx~~~~~~~zxxxx|zxz~~~rrz~|xz~~|vtx|zxz|~~~||zx|||~~zz|zz~~~~|~~||~~||zz|~||z~~~~zxzz|~~~~|~~~|~||~~~~~~~~~~~~~|||~~~~~~~~~~~~~||~~||~||~~~~|||~~~~||||~~~~~~||||~~~~~~~~~~~|~~~~|zz~~~~~~~||||~~||~~~~~|||~~~~~|||~|~|~~~~|z|~~~~~~~|||~~~~~~~~||~~~~~~~~\M t
4 0 / 4
7 _ C
+ M . O ) > 2 ! 3 ( * j + - , . & * ?
- ' " & ) $ ? U
H H H I & 1 F - ' 2 $ q 1
# $ " ( % ' ( ) O b $ ~D;P
y I $ Ib $ o,FXw i I2 $ E#5R K : I 0e 0e
A A 1 8c 8c
? 1 d 0u 0@T y2 N P ' p < ' p A) B C D| E | | + / $ V p @ g 4 2 d 2 d tb ~0lb f $ p p p p @ < 4 B d B d j 8b _ _ _ P P T 9 / 0 j R 0 _ _ _ P P T 1 0
? % O = 3 * T h e N a t W o r k s M e s s a g e
The Data Extraction Question The Arguments For Natural ( f3 Arguments Against Natural ( f3 Arguments Against Natural ( f3 " A Natural Data Extraction Wishlist 4 # f3 p
NatQuery-Data Extract Generation * ! f3 Leveraging Your Environment The NatQuery Extraction Solution The NatQuery Extraction Solution The NatQuery Extraction Solution NatQuery Administration Overview NatQuery Administration Overview NatQuery Administration Overview NatQuery Generation Overview Direct FTP Integration Overview " In-Direct FTP Integration Overview ! NatQuery Integration to ETL Tools " ! NatQuery Integration to Any2XML NatQuery Features O p t i m i z e d a c c e s s t o s o u r c e f i l e ( s ) , b a s e d o n u s e r - e n t e r e d s e l e c t i o n c r i t e r i a
A u t o m a t e d i n t e g r a t i o n t o s e r v e r
O n l y F T P i s r e q u i r e d
F u l l h a n d l i n g o f A D A B A S f i e l d t y p e s
F u l l h a n d l i n g o f A D A B A S r e c u r r i n g d a t a
n N M M NatQuery Features - continued... !
NatQuery Features - continued... !
NatQuery Features - continued... !
A u t o m a t i c L i n k i n g o f u p t o 5 P r i m a r y f i l e s
S u p p o r t f o r A u t o m a t i c L o o k - u p f i l e s
F u l l E x t r a c t o r I n t e r s e c t i o n S e t
S u p p o r t f o r U s e r - D e f i n e d V a r i a b l e s
A b i l i t y t o r e a d S e q u e n t i a l F i l e s
z G T % F NatQuery Features - continued... !
Administratively Contolled User Data Limits
Extraction Capability from VSAM & DB2
Full Support of Native Security
Natural Security & ADABAS Security
Integration to PREDICT
All field level metadata is made available for query creation
Field metadata can be passed into ETL tools
, G $ m , G " i NatQuery Features - continued... !
Y ADABAS to XML
Directly on Mainframe
ADABAS to XML / XSL
When Downloaded to the PC
...
NatQuery Benefits Cost Effective
No Middleware
No Mainframe Footprint
Demonstrable ROI
One Tool - Multiple Uses
End-User Data Extraction
Data Warehouse Extraction
Web Publishing / Data Exchange
Development Testing Tool
... t 6 l 6 l q
The Source of ADABAS Changes N A D A B A S t r a n s a c t i o n r e c o v e r y m e c h a n i s m
1 0 0 % d a t a i n t e g r i t y , a l l t r a n s a c t i o n s r e c o r d e d
T r u e P o i n t - i n - T i m e s n a p s h o t o f A D A B A S
C h a n g e d D a t a A v a i l a b l e w / o A D A B A S A c c e s s v ' / R & / # ( What is PLOG Data Good For? ADABAS Recovery Processing
ADARES Utility
Capture transactions that occur against specific files
Commonly Referred to as Change Data Capture (CDC)
Audit ADABAS Transactions
Who changed a specific record?
What changes were made by a specific person or process? 7 3 W 7 1 V The Adabas Protection Log (PLOG) A l l t r a n s a c t i o n s o c c u r i n g a g a i n s t a n y f i l e i n a n A D A B A S d a t a b a s e a r e r e c o r d e d i n t h e P L O G
E a c h r e c o r d i s i n c o m p r e s s e d f o r m
E a c h r e c o r d i s f l a g g e d w i t h a P L O G h e a d e r
H e a d e r c o n t a i n s : D a t e , T i m e , I S N , I m a g e T y p e , U s e r &
I m a g e T y p e w i l l b e a B e f o r e I m a g e o r a n A f t e r I m a g e
A S t o r e w i l l b e r e f l e c t e d a s a s i n g l e A f t e r I m a g e r e c o r d
A n U p d a t e w i l l b e r e f l e c t e d a s t w o r e c o r d s , a B e f o r e I m a g e a n d a n A f t e r I m a g e
A D e l e t e w i l l b e r e f l e c t e d a s a s i n g l e B e f o r e I m a g e r e c o r d | Z L 5 4 V L 5
%
PLOG Processing Issues A P L O G C o n t a i n s T r a n s a c t i o n s A g a i n s t A l l F i l e s
T r a n s a c t i o n s a g a i n s t s p e c i f i c f i l e s m u s t b e s p l i t o u t
A P L O G i s i n C o m p r e s s e d F o r m a t
R e c o r d s m u s t b e D e c o m p r e s s e d
P L O G R e c o r d s m a y b e V a r i a b l e L e n g t h
F i x e d L e n g t h r e c o r d s a r e e a s i e r t o p r o c e s s
A P L O G S t o r e s F u l l R e c o r d I m a g e s
U n - n e e d e d F i e l d s W i l l N e e d t o b e D r o p p e d
P L O G R e c o r d s m u s t b e P r o c e s s e d
R e c o r d s e q u e n c e s m u s t b e e x a m i n e d t o d e d u c e S t o r e , U p d a t e o r D e l e t e
D a t e , T i m e a n d E B C D I C - > A S C I I c o n v e r s i o n s / 6 $ + ! + ! o . 5 # * * C * Leveraging Your Environment ADABAS PLOG Utilities A D A S E L u t i l i t y ( A D A B A S 6 ) :
D e c o m p r e s s e s P L O G r e c o r d s
S p l i t s P L O G t r a n s a c t i o n s i n t o s e p a r a t e f i l e s ( 2 0 p e r r u n )
D o e s n o t d e l i v e r D e l t a C h a n g e s
C a n O n l y D e l i v e r O p t i m i s t i c U p d a t e s
A D A C D C u t i l i t y ( A D A B A S 7 ) :
D e c o m p r e s s e s P L O G r e c o r d s
D o e s n o t s p l i t t r a n s a c t i o n s i n t o s e p a r a t e f i l e s
D e l i v e r s D e l t a C h a n g e
C a n D e l i v e r C o m m i t t e d o r O p t i m i s t i c U p d a t e s ADABAS PLOG Processing NatCDC converts variable-length to fixed-length
User-Specified number of MU and PE occurrences
PLOG Header converted
Extraneous Fields dropped
NatQuery generates all required objects
Parameters
Programs
JCL h 0 _ ( * _ PLOG Processing Answers F A P L O G C o n t a i n s T r a n s a c t i o n s A g a i n s t A l l F i l e s
H a n d l e d b y A D A S E L
A P L O G i s i n C o m p r e s s e d F o r m a t
H a n d l e d b y A D A S E L
P L O G R e c o r d s m a y b e V a r i a b l e L e n g t h
H a n d l e d b y N a t C D C
A P L O G S t o r e s F u l l R e c o r d I m a g e s
H a n d l e d b y N a t Q u e r y / N a t C D C
P L O G R e c o r d s m u s t b e P r o c e s s e d
H a n d l e d b y N a t Q u e r y / N a t C D C / n f3 n f3 $ n f3 ! n f3 ! n f3 . # v NatCDC Processing Overview x NatCDC Features 100% Data Integrity
Simple Mainframe Installation
The Fastest Decompression
Variable-Length to Fixed Length conversion
Full Handling of all ADABAS data structures
s g } NatCDC Features w Full support for expanded files
Full generation of required objects
Field Selection Options
Integration to ETL Tools $ 2 # 2 z NatCDC Features K Data Output Options
Logical Last
First & Last
All
Extensive Reporting
... ~ ~ NatCDC Benefits Cost Effective
No Middleware
Minimal (No?) Mainframe Footprint
Demonstrable ROI
One Tool - Dual Use
Data Warehouse Change Data Capture (CDC)
ADABAS Transaction auditing
... | A E A E 5 " / 6
i ` ̙ 33 ` 3 ` 3 33 3 f ` 999 MMM ` f ` f 3 ` 3 > ? " d d @ , ? l K d @
d @ n A ` n ? " d d @ @@ `` @ n ? " d d @ @@ `` P R @ ` ` p > > { (
` TY g ֳ g ֳ ? p` H
= *
` ԵY g ֳ g ֳ ? ! H
@ NatWorks, Inc.
` Y g ֳ g ֳ ? p
H
? * X
0 ? U
# l tY g ֳ g ֳ 1 ? H
T Click to edit Master title style !
! :
T Y g ֳ g ֳ ? 0Pp@ H
R Click to edit Master text styles
Second Level
Third Level
Fourth Level
Fifth Level !
S
f Y 1 ? <
R Pacific Southwestern User Group ! !
f Y 1 ? pV
?
Chris Bradley x
` 3d h @ ? ? S {I N Q Y - 2 . p p t 0 x p @ (
0 ĸ8 P!
J
Y *
0 D8 ! J
[ * d
c $ ? -
J
0 D8
@ J
x R Click to edit Master text styles
Second level
Third level
Fourth level
Fifth level
S
6 į8 | P J
Y *
6 $8 | =
[ * H
0 h dS ? ̙ 33 8 0 _ _ _ P P T 1 0 . F| ~P 0 ( - +
# l 8 1 ? P
J
= *
# l 8 1 ? J
? *
# l d8 1 ? P J
= *
# l D8 1 ? J
? * H
0 h dS ? ̙ 33 8 0 _ _ _ P P T 1 0 . F|`~T %
R ( w
v
N 8 g ֳ g ֳ ? , $ D
0
< Effective
Data Extraction
and
Change Data Capture
for
ADABAS l = B $ B $ B <
` 8 g ֳ g ֳ ? _
@ NatWorks, Inc.
f 8 1 ? 0 nP
@ Chris S. Bradley
0
0e 0e A
? A A 1 8c 8c
? 1 d 0u 0@T y2 N P ' p < ' p A) B C D| E | |
0 J H
0 h ? S {I y _ _ _ P P T 1 0 Y + D= ' =
@B +
P : (
x
c $ 8
=
f 8 1 ? ,
n A Software AG customer who has
ADABAS & NATURAL
already has the best tools to handle
ALL
requirements for
Data Extraction & Change Data Capture 3 f3 % 7 $ v
f 8 1 ? 0 Qw
, $ D
0
v W h a t s m i s s i n g i s t h e a b i l i t y t o g e n e r a t e r e q u i r e d o b j e c t s . < < H
0 h ? S {I v _ _ _ P P T 1 0 V + c0 D ' =
@B D ' =
@B A ? %, ( < + O %, (
< + D ' = % ( D ' = % ( DD ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -s 6 B w i p e ( l e f t ) *< 3 < * +8 +0 + j + $ T I M I N G | 1 . 4 d9
% l d ` (
3
N 8 g ֳ g ֳ ? = , $ D
0
) Where Do You Need Your ADABAS Data Today? < *
` 8 g ֳ g ֳ ? !
@ NatWorks, Inc.
f ĵ8 1 ?
X Pacific Southwestern User Group ! B
f D f3 > ? t d
, $ D
0 l T @ d
T @ d
, $ D
0 B
B
f D f3 > ? t d
, $ D
0 B
` D f3 > ? @ T @ t , $ D
0 B
B
` D f3 > ? t @ t , $ D
0 B
f D f3 > ? t d
, $ D
0 B
@
` D f3 > ? t `t , $ D
0 B
f D f3 > ? t @ @ d
, $ D
0 B
f D f3 > ? t ``d
, $ D
0 B
@
` D f3 > ? t @ `t , $ D
0
0 A8
, $ D
0
U End-User
Extraction &
0 @8
@ , $ D
0
^ Data
Warehousing
/ Migration &
0 TC8
`
, $ D
0
U Change
Data
Capture &
0 G8
@ , $ D
0
V Transaction
Auditing &
0 B8
` , $ D
0
V XML &
Web
Publishing &
C , A B i g A D A B A S , $ D
0
f G8 1 ? pV
?
Chris Bradley H
0 h ? S {I t' l' _ _ _ P P T 1 0 L' + ۘi D% ' =
@B D% ' =
@B A ? %, ( < + O %, (
< + D$ ' = % ( % ( D ' = % ( DD ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -s 6 B w i p e ( l e f t ) *< 3 < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3 < * D ' = % ( D9 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -u 6 B w i p e ( r i g h t ) *< 3 < * D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3 < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3 < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % (
D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3 < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3 < * D ' = % ( | D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( p D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( d D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3 < * +P +0 + j + +0 + j + +0 + j + +0 + j + +0 + j + +0 + j + }
p 4 (
x
c $ ?8
Y
,
` H8 1 ? p
8 If Data Extraction from ADABAS is the question, then... H 9 $ 0 $ $ H
` H8 1 ?
H W h y s h o u l d n t t h e a n s w e r b e N a t u r a l ? T % $ $ 0 f3 0 $ H
0 h ? S {I y _ _ _ P P T 1 0 Y + D= ' =
@B +
k (
x
c $ 4H8
Y
T tA8 g ֳ g ֳ ? ` ` , $ D
0
Developed by Software AG specifically to access ADABAS
Most accepted method of accessing ADABAS
Best understood method of accessing ADABAS
You already have it > | ( H
0 h ? S {I
Z
_ _ _ P P T 1 0 :
+ ` D ' =
@B D ' =
@B A ? %, ( < + O %, (
< + D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * 8 % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * 8 D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * 8 b % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * 8 b D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * b % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * b D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * +8 +0 + j + : T I M I N G | 1 . 5 | 4 . | 2 . 3 | 3 . 6 (#
$ (
$ x
$ c $ TI8
Y
$
T tJ8 g ֳ g ֳ ? ` , $ D
0
O Bad Performance
" ( l
$ 6 , $ D
0 B
$
# l D 3 > ? B
$
# l D 3 > ?
$
T K8 g ֳ g ֳ ? , $ D
0
P Excellent Performance!!!
Proper use of Data Access Paths
Descriptors, Super-Descriptors, ...
Proper use of Data Access Statements
Get, Find, Read Logical, Read Physical
Proper use of Multi-Fetch / Pre-Fetch
2.5 Million Records in 4.5 minutes
Proper use of ADABAS Utlities and Natural
$ & ' & # + # & & & " + ( H
$ 0 h ? S {I _ _ _ P P T 1 0 q + /+ D ' =
@B D ' =
@B A ? %, ( < + O %, (
< + D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ D ' = % ( D ' = % ( D7 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ % ( D ' = -s 6 B w i p e ( l e f t ) *< 3 < * $ D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ 9 % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ 9 D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ 9 ] % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ 9 ] D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ ] % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ ] D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * $ % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * $ +p +0 + $ + +0 + $ + , T I M I N G | 0 . 9 | 0 . 9 ,
?
7
( @ (
( x
( c $
Y
(
T g ֳ g ֳ ? @ , $ D
0
W o n t S c a l e ( D e v e l o p m e n t & M a i n t e n a n c e E f f o r t )
E x p e r t i s e i s R e q u i r e d
N a t u r a l E x p e r t i s e
A D A B A S E x p e r t i s e
A p p l i c a t i o n E x p e r t i s e i s R e q u i r e d
P l a t f o r m E x p e r t i s e i s R e q u i r e d
P r o g r a m m e r T i m e i s E x p e n s i v e v / d / c $ B
(
3 r D 3 > ? P , $ D
0 B
(
3 r D 3 > ? P , $ D
0 1 l 0 P
( 0P
, $ D
0 T 0 P P
( # 0 0 P
b
(
` > ? 0 0 P
B
(
# l D > ? 0 @ P @
(
f d 1 ? p ` `
w C Only
true
for
traditional
approaches
to
extraction
I.E.
Hand-Coding D D >
(
T g ֳ g ֳ ? P
, $ D
0
, Scales Easily - When Natural is Generated!
> - f3 ( H
( 0 h ? S {I " ! _ _ _ P P T 1 0 ! + G8 D! ' =
@B D ' =
@B A ? %, ( < + O %, (
< + D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( / % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( / D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( / E % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( / E D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( E W % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( E W D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( W h % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( W h D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( h % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( h D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( D ' = % ( D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( , % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( , Do ' = % ( D ' =4 @B B B B % ( E ' =4 B ` B P B `B ? < * % ( $ / %, ( < + D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * ( Ds ' = % ( D ' =4 @B B B B % ( E ' =4 B ` B P B `B ? < * % ( ( / %, ( < + D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( % ( D ' = -s 6 B w i p e ( d o w n ) *< 3 < * ( D ' = % ( D ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * ( % ( D ' = + 4 8 ?d C B 1 + # p p t _ w / 2 B C B # p p t _ x B *Y 3 > B
p p t _ x < * ( D ' = + 4 8 ?\ C B # p p t _ y B C B # p p t _ y B *Y 3 > B
p p t _ y < * ( +p +0 + ( + +0 + ( + < T I M I N G | 1 . 1 | 1 . 7 | 1 . 7 | 4 . 5
, a (
, x
, c $ B8
Q
,
` 4B8 1 ? 0
i Graphical User Interface
Embedded Natural Intelligence
Embedded ADABAS Intelligence
Ability to Understand an ADABAS Application
Ability to easily integrate the PC and Mainframe
Upload, Monitor, Execute and Download
Integrate extracted data into mainstream tools
Minimal Training Required
Centralized Administration
No Mainframe Installation Required W ] V 6 # H
, 0 h ? S {I y _ _ _ P P T 1 0 Y + D= ' =
@B +
% H w (
H q
H
T D g ֳ g ֳ ? )
, $ D
0
% a
Data Extraction Solution
for
ADABAS x & 6 < < P <
H
` g ֳ g ֳ ? _
@ NatWorks, Inc.
H
~ Wf3 ? N a t Q u e r y A r i a l B l a c k 0 @ 0 0 H
H 0 h ? S {I y _ _ _ P P T 1 0 Y + D= ' =
@B +
0 (
0 x
0 c $ D8
Q
0
` D 3 1 ? 0
7 i Graphical User Interface
Embedded Natural Intelligence
Embedded ADABAS Intelligence
Ability to Understand an ADABAS Application
Ability to easily integrate the PC and Mainframe
Upload, Monitor, Execute and Download
Integrate extracted data into mainstream tools
Minimal Training Required
Centralized Administration
No Mainframe Installation Required f3W f3] f3 V 6 # H
0 0 h ? S {I y _ _ _ P P T 1 0 Y + D= ' =
@B +
* * D E M* ( w
z
, $ D
0 Z "
s * P
f W ? N a t Q u e r y A r i a l B l a c k @
w 8 T @
# P
f B
6 D > f B
6 D > @ @ x
c $ $
Q
0 $ ̙ P P
:
2
# l 3f
L" ? 0 P
| A D A B A S "! J 2
B ? 0 `
b " A D A B A S "!
U t i l i t i e s $ 2
B $ ?
^ P r e d i c t "! 0
2
B ?
>
< $ 2@R
J N a t u r a l "! B
@
B > ? PP` , $ D
0
< ?
, $ D
0
G EXCEL &
< ?
, $ D
0
H ACCESS &
< d& ?
`p , $ D
0
O
Desktop
Tools &
< & ?
, $ D
0
I XML/XSL &
< $$ ?
@ P
, $ D
0
Q Load Ready
Data & B
@
B > ? ` pP` , $ D
0 B
@
H > ? ` ppP
, $ D
0 B
@
H > ? ` P
, $ D
0 B
@
H > ? ` PPP
, $ D
0 B
@
B > ? ` P ` , $ D
0 B
@
H > ? ` P
, $ D
0 B
@
B > ? ` ` ` , $ D
0 B
@
H > ? ` ` ` P
, $ D
0 B
B > ? p , $ D
0 B
B > ? pp , $ D
0 B
H > ? p , $ D
0 B
!
H > ? p , $ D
0 | z @ p
" p , $ D
0 x B
#
H > ? @ r B
$
B > ? @ p @ `
% # P , $ D
0 N
& ` Z 2
'
s * @ Z 2
(
s * Z 2
)
s * P P Z 2
*
s * ` ` Z 2
+
s * 0 Z 2
,
s * p Z 2
-
s * Z 2
.
s * Z 2
/
s * ` @ Z 2
0
s * p Z 2
1
s * 0 Z 2
2
s * P
3
V W ? W e b A r i a l B l a c k ` p
4
< # ? 0p , $ D
0
V D B 2 "! 2
5
< # ?
0` , $ D
0
M Load Ready
Data "
7
B ( ? 0
, $ D
0
M RDBMS
of Choice " B
8
N > ? 0 ` 0 , $ D
0 B
9
N > ? P
` P
, $ D
0
:
< D( ? 0P
, $ D
0
? XML z ` 0
; `0 , $ D
0
<
< ' ? 0
X T a m i n o "! , x B
=
H > ? `
>
< ? 0 0
N Target
of Choice " x B
?
H > ? `
@
< 3 ?
0 , $ @
0
P ETL Tool
of Choice " B
A @
H Ԕ ?
, $ D
0 R 2
B
s * 3f ^ B
C
6 D 3f Ԕ
D
< D% @
O
ADASAV
Backup &
E
f ! 1 ? i
% ADABAS Extraction B
H > ? p , $ D
0 H
0 h ? S {I bT T _ _ _ P P T 1 0 S + DQ ' =
@B DgQ ' =
@B A ? %, ( < + O %, (
< + DP ' = % ( D ' = % ( D ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = + 4 8 ?\ C B # p p t _ x B C B # p p t _ x B *Y 3 > B
p p t _ x < * D ' = + 4 8 ?d C B 1 + # p p t _ h / 2 B C B # p p t _ y B *Y 3 > B
p p t _ y < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( D9 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -u 6 B w i p e ( r i g h t ) *< 3 < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3 < * D ' = % ( D3 ' =4 @B B B B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B w i p e ( u p ) *< 3 < * D ' = % ( D@ ' =A @B B B B 0B % ( D ' = 1 : B v i s i b l e *o 3 >+ B# s t y l e . v i s i b i l i t y < * % ( D ' = -o 6 B b o x ( o u t ) *< 3