ADABAS C In The Network

1
ADABAS C In The Network

• Horst Kinzinger
• Software AG
• Dieter Storr
• SAG User Group Germany
• Presentation from
• April 1996

2
Contents

• ADABAS C On The Mainframe
• ADABAS C In The Network
• Several Problem Descriptions
• Used Software
• Problem Solutions
• Examples From The Praxis
• Data Security
• Scenario in SAG world
• Note Now, connections are possible with NET-WORK
  or TCP/IP

3
(No Transcript)
4
Entire Network and ADABAS STAR
5
Who the hell talked about plug and play
6
ADABAS C at the MF with PC access (RDA)
7
Remote Direct Access using NATURAL Lightstorm
ADABAS C
ENTIRE NET-WORK
ENTIRE NET-WORK
NATURAL lightstorm
8
ADABAS C at the MF with PC access (RPC)
9
Remote Procedure Call
ADABAS C
NATURAL RPC Server
ENTIRE Broker
ENTIRE NET-WORK
ENTIRE NET-WORK
NATURAL lightstorm
10
(No Transcript)
11
(No Transcript)
12
Stored Procedures Triggers (ADABAS C 6.2)
ADABAS C stored Procedures Triggers
ENTIRE NET-WORK
ENTIRE NET-WORK
NATURAL / 3GL
13
ADABAS C on the MF and on the PC with PC access
14
ADABAS C on the MF and the PC with PC access
LAN
OS/2 UNIX WIN/NT
15
ADABAS C on the MF and on the PC witht PC access
Store
ADABAS C
ENTIRE NET-WORK
Remote Direct Access
ENTIRE NET-WORK
ENTIRE NET-WORK
NATURAL lightstorm
NATURAL lightstorm
LAN
Read
ENTIRE NET-WORK
ENTIRE NET-WORK
NATURAL lightstorm
NATURAL lightstorm
ADABAS C
ADABAS C
OS/2 UNIX WIN/NT
NODE4711
16
ADABAS C on the MF, download data for PC
17
File - Transfer
ADABAS C
NATURAL
ENTIRE CONNECTION
3270 Emulation
ASCII File
ENTIRE CONNECTION
Data format - Winword Mail Merge - EXCEL
Tables
18
ADABAS C MF, SQL access from PC with RDA
ADABAS C
ENTIRE NET-WORK
ENTIRE NET-WORK
ADABAS SQL EXPRESS
Application
19
ADABAS SQL Server
ADABAS C
ADABAS SQL Server
ENTIRE NET-WORK
ENTIRE NET-WORK
Application
20
ADABAS C on the MF Access with ESPERANT from the
PC
21
Access to ADABAS C via ESPERANT
ADABAS C
ADABAS SQL Server
ENTIRE NET-WORK
ENTIRE NET-WORK
ODBC Driver
ESPERANT
22
End-user tools for VSAM and DL/1
ADABAS C
SQL Server
DL/1 Bridge VSAM Bridge
ENTIRE NET-WORK
ENTIRE NET-WORK
ODBC Driver
ESPERANT
23
ADABAS C on the PC HOST accesses (RDA) to the PC
24
Remote Direct Access zum PC
NATURAL
ENTIRE NET-WORK
ENTIRE NET-WORK
ADABAS C
25
ADABAS C on the PC, host accesses (RPC) to the PC
26
RPC from MF to PC
NATURAL
ENTIRE BROKER
ENTIRE NET-WORK
ENTIRE NET-WORK
WIN NT OS/2 UNIX
NATURAL RPC Server
ADABAS C
27
ADABAS C on the host and data replication to the
PC
28
Data Replication
ADABAS C
ENTIRE TRANSACTION PROPAGATOR
ENTIRE NET-WORK
ENTIRE NET-WORK
ADABAS C
29
Application of DDE communication

• NATURAL transfers data to EXCEL
• Start NATURAL server applications via PC macros

30
Data exchange via DDE
ADABAS C
ENTIRE NET-WORK
ENTIRE NET-WORK
NATURAL lightstorm
DDE Interface
MS EXCEL MS ACCESS
31
Start of server applications via PC macros
ADABAS C
NATURAL RPC-Server
ENTIRE BROKER
ENTIRE NET-WORK
ENTIRE NET-WORK
NATURAL lightstorm
Makro
MS EXCELMS WINWORD
32
Data security in the network

• Users Solution
• ADARUN parameter LOCALYES/NO
• NATURAL parmameter TF
• NTTF macro in NATURAL parameter modul
• UDB parameter
• USER EXITs in ADALNKB of ENTIRE NET-WORK
• Check NOVEL USER-ID with LOGON GUARD
• Check VSAM accesses with SAF interface

33
Data Security of the mainframe database
TOP-Secret RACF ACF2
ADABAS C ADAESI
ENTIRE NET-WORK
ENTIRE NET-WORK
ENTIRE NET-WORK ADAESI
34
(No Transcript)
35
Problems

• No writes to multiple databases in the entire
  network in one transaction
• ASCII / EBCDIC translation
• Binary definition of alpha fields is not possible
• Error handling
• Localize errors