Adabas Options for Unlocking Your Data

1
Adabas Options for Unlocking Your Data
2
New Adabas offerings help you... Integrate
Adabas Data Sources Across Your Enterprise
3
Adabas SQL Gateway

• Adabas SQL Gateway allows your Adabas data
  to be accessed quickly and easily by any
  ODBC/JDBC based standard SQL application

• It Helps You To
• Place information in the hands of the business
  user through desktop applications
• Eliminate the need for moving data from Adabas to
  a data warehouse for access by SQL applications
• Reduce IT requests from business users for
  information stored on Adabas

4
Do you need Adabas SQL Gateway?Business Drivers
IT
Delivers
Business Value

• Use ODBC, JDBC, OLE DB and ADO.NET as a
  programming standard for accessing data
• Are doing EAI and dont want to spend a lot of
  time and resources extracting data from Adabas
• Want to propagate data down from Adabas to a data
  warehouse via SQL
• Need real-time access to Adabas data via SQL
  reporting tools such as Crystal Reports, Business
  Objects, MS Office.

• Leverage
• Existing Standards
• Reduce Costs
• and
• Increase Productivity
• Put Information in the
• Hands of the Business User
• Put Information in the
• Hands of the Business User
• in Real-Time

5
Adabas SQL Gateway Demo
Windows 2000
O D B C
Adabas SQL Gateway Client
Data Dictionary
Desktop Apps Crystal Reports, Excel Spreadsheet,
Adhoc Query
TCP/IP
Adabas SQL Gateway Server
(V3.3)
6
Adabas SQL Gateway Architecture
Windows

z/OS, VSE, Unix, Win
O D B C
Adabas SQL Gateway Client
Adabas SQL Gateway Server
TCP/IP
Desktop Apps Crystal Reports, Business
Objects and access from .NET and OLE DB
environments
Data Dictionary
(Windows)
Java Server
J D B C
Adabas SQL Gateway Client
TCP/IP
Java Programs with embedded SQL statements
Data Dictionary
Host platforms available according to the
release schedule
(Windows)
7
Adabas SQL Gateway Components

• Client
• The Client is based on an ODBC driver It is a
  dynamic link library that all applications call
  to access data located in remote systems.
• Server
• The Server translates SQL requests into direct
  calls for Adabas.
• Data Dictionary (CDD)
• The Data Dictionary stores the database tables
  and field definitions at the client level.

8
Step by Step

• Connecting Executing Queries
• (What happens under the covers)

9
Step by Step Connecting
CONNX JDBC Driver
Any O/S
P
I
/
P
C
T
Infonaut
CONNX .NET Data
CONNX JDBC
CONNX OLEDB
CONNX ODBC
Provider
Server Service
Provider
Driver
CONNX Core
s
s
e
Windows
s
c
c
s
P
A
e
I
c

e
/
P
c
l
i
A
C
F


T
e
k
l
r
i
F
o

w
k
t
r
o
e
N
w
t
e
N

CONNX Server

CONNX CDD










(Data Dictionary)


I
Step by step Connecting.
P
A

e
s
a
b
CONNX
a
t
a
D
license files
ADABAS
File/Print Server
Mainframe
10
Step 1
CONNX JDBC Driver
Any O/S
P
I
/
P
C
Infonaut
T
CONNX .NET Data
CONNX JDBC
CONNX OLEDB
CONNX ODBC
Provider
Server Service
Provider
Driver
CONNX Core
s
s
Windows
e
c
s
c
s
A
P
e
I

c
/
e
P
c
l
i
A
C
F


T
e
k
l
i
r
F
o

w
k
r
t
e
o
N
w
t
e
N

CONNX Server

CONNX CDD










(Data Dictionary)


I
Step 1
P
A

e
s
a
b
CONNX
a
t
a
D
Using Infonaut, select a DSN or data
license files
dictionary for a connection.
ADABAS
File/Print Server
Mainframe
11
Step 2
12
Step 3
CONNX JDBC Driver
Any O/S
P
I
/
P
C
Infonaut
T
CONNX .NET Data
CONNX JDBC
CONNX OLEDB
CONNX ODBC
Provider
Server Service
Provider
Driver
CONNX Core
s
s
Windows
e
c
s
c
s
A
P
e
I

/
c
e
P
c
l
i
A
C
F


T
e
k
l
i
r
F
o

w
k
t
r
o
e
N
w
t
e
N

CONNX Server

CONNX CDD










(Data Dictionary)


I
Step 3
P
A

e
s
a
b
CONNX
a
t
a
D
The CONNX Client access the
license files
requested CDD, and keeps a copy in
ADABAS
a in local cache.
File/Print Server
Mainframe
13
Step 4
14
Step 5
15
Step 6
16
Step by Step Executing a Query
17
Step 1
18
Step 2
19
Step 3
20
Step 4
21
Adabas SQL Gateway Strengths

• High performance distributed SQL engine
• distributes query processing between multiple
  systems.
• ANSI 92 SQL Support for SELECT, INSERT, UPDATE,
  DELETE
• supports complex SQL statements, correlated
  sub-queries, unions, etc. Giving the
  flexibility of using the full power of SQL to
  accomplish business goals.
• Advanced SQL Optimizer
• tools that will display the query plan and
  allows you to adjust SQL in order to control
  query execution paths.
• Future integration with Adabas
• more tightly integrated with Adabas, offering
  enhanced SQL capabilities.

22
Platform and Feature Roadmap

• Release 1 2Q 2004
• ADABAS SQL Gateway - OS/390, z/OS and Windows
• Includes ODBC/JDBC on Windows for 3rd party
  product access
• Null Support
• Session Management capability (display/stop
  users, stop query, etc.)
• Collating descriptor support
• Release 2 - 3Q 2004
• ADABAS SQL Gateway - HPUX, AIX, Solaris, Linux
  (Intel)
• 32 and 64 bit versions supported

23
Platform and Feature Roadmap

• Release 3 - 4Q 2004
• ADABAS SQL Gateway - VSE
• Dynamic DDL
• Parallel Sysplex and multi-processor support
• Release 4 - 1Q 2005
• ADABAS SQL Gateway - BS2000
• Pre-compilers for 3GL programs containing
  embedded SQL statements (for ESQ migration)

• NOTE interim solution available for Adabas on
  all platforms using Adabas SQL Gateway on
  Windows and Entire Net-Work

24
Questions Answers