Implementing Business Intelligence BI using the Adabas SQL

Implementing Business Intelligence (BI) using the Adabas SQL Gateway Patrick Gould Natural Conference 2006

Why we need Business Intelligence? n Business Intelligence enables organizations to make well informed business decisions and thus can be the source of competitive advantages n The ultimate objective of business intelligence is to improve the timeliness and quality of information dd. mm. yyyy Software AG

Why we need Business Intelligence? n Business intelligence reveals to you: u The position of your firm as in comparison to its competitors u Changes in customer behavior and spending patterns u The capabilities of your firm u Market conditions, future trends, demographic and economic information u The social, regulatory, and political environment u What the other firms in the market are doing u You can then deduce from the information gathered what adjustments need to be made u Businesses realize that in this very competitive, fast paced, and everchanging business environment, a key competitive quantity is how quickly they respond adapt to change dd. mm. yyyy Software AG

Benefits of Business Intelligence n BI provides many benefits to companies utilizing it. It can eliminate a lot of the guesswork within an organization, enhance communication among departments while coordinating activities, and enable companies to respond quickly to changes in financial conditions, customer preferences, and supply chain operations. BI improves the overall performance of the company using it dd. mm. yyyy Software AG

Benefits of Business Intelligence n Information is often regarded as the second most important resource a company has (a company's most valuable assets are its people) n When a company can make decisions based on timely and accurate information, the company can improve its performance n BI also expedites decision-making, as acting quickly and correctly on information before competing businesses do can often result in competitively superior performance n It can also improve customer experience, allowing for the timely and appropriate response to customer problems and priorities dd. mm. yyyy Software AG

Software AG’s answer to helping with Business Intelligence n This Presentation and Demo session will highlight how the Adabas SQL Gateway (ACE) can help with integrating Adabas Data into Business Intelligence Tools n Presentation will cover product overview, customer references and details on the personnel trial copy of the software n Demo will cover all the options for integrating Adabas Data into your sites client toolsets with both Java and Microsoft IDE’s, Query and Business Intelligence tools etc dd. mm. yyyy Software AG

Adabas Openness & Interoperability Customer Pain and Solutions n CUSTOMER PAIN: Have SQL-based applications that need to access data managed in Adabas u Perception that Adabas systems are closed and proprietary – but daunting cost, risk and time that would be involved in trying to replace these systems u Heterogeneous application and DBMS landscape and integration projects are typically costly and time intensive u Business analysts need access to Adabas using desktop applications u n SOLUTIONS: Adabas SQL Gateway u SQL Gateways for other DBMS u dd. mm. yyyy Software AG

Adabas Openness and Interoperability Core Value Proposition n ADVANTAGE: u Use industry standards u Access by business analysts using desktop applications u Developers do not need to know Adabas u Direct access to Adabas data with minimal coding compared to complex integration strategies n GAIN: u Increased Productivity u Meet business demands more quickly and with lower cost u Increase the return on years of investment in Adabas u Count on the reliability, performance, ease of use and low TCO for Adabas well into the future u Reduces burden on IT dd. mm. yyyy Software AG

Why do we need ACE ? n Provides SQL access to ADABAS u Industry/ANSI standard SQL u No new programming language for programmers to learn n ACE translates SQL calls to ADABAS calls n For example: u Can access ADABAS data directly from Microsoft EXCEL u Use embedded SQL in a COBOL program dd. mm. yyyy Software AG

Adabas SQL Gateway Architecture - ODBC/JDBC Windows, Unix, LINUX Desktop Apps: Crystal Reports, Business Objects and access from ADO. NET and OLE DB environments O D B C Adabas SQL Gateway Client Data Dictionary z/OS, VSE, Unix, LINUX, Win TCP/IP Adabas SQL Gateway Server (Windows) JDBC Server Java Programs with embedded SQL statements J D B C Adabas Gateway Client Data Dictionary TCP/IP (Windows) dd. mm. yyyy Software AG

Adabas SQL Gateway Sample Configuration dd. mm. yyyy Software AG

Adabas SQL Gateway Implementation Options n Direct access to Adabas data from client applications n Use concept of virtual database like Microsoft Access to bring down specific data when needed and use virtual database as source to Business Intelligence n Use together with Event Replicator for Adabas and allow direct access to replicated Adabas data from client applications dd. mm. yyyy Software AG

Success Stories and Solution Scenarios

Adabas SQL Gateway Sales Stories Washington State University n Business Problem: Washington State University needed to enable newer systems written in ASP, JSP, VB, JAVA and C to issue SQL queries against Adabas data n Product: Adabas SQL Gateway n Solution: Implemented the Adabas SQL Gateway campus wide to support the following systems: Student Prospect Tracking System, Housing Reservation, On-line Transcript Order, Registrar's Office n Other Details: u Fully referenceable, happy customer since 1985 u Adabas SQL Gateway dislodged a competitor product which the customer was very unhappy with u What closed the sale? • Lower cost of ownership for SQL access to Adabas • Lower resource utilization, increased performance dd. mm. yyyy Software AG

Adabas SQL Gateway Sales Stories Baur Versand Gmb. H and CO. KG n Business Problem: Bauer had several homemade systems for reporting and Ad-hoc query which were inflexible n Product: Adabas SQL Gateway n Solution: By replacing their in-house system with the Adabas SQL Gateway, Bauer realized the following benefits: u More flexible and faster access to critical business data on Adabas u Standard SQL Access to Adabas via Business Intelligence tools u No more individual programming efforts for reports and ad-hoc analysis u More insight into business data and better analysis results n Other details: u Fully referenceable customer dd. mm. yyyy Software AG

Adabas SQL Gateway Sales Stories BP Marine Ltd. n Business Problem: Customers and agents had to undergo a laborious process to access data, such as oil sample analysis for cargo ships. The process involved IT running queries through Natural and then posting, scanning and fax/email to the intended recipient n Products: Adabas SQL Gateway, Natural Productivity Pack n Solution: u The Adabas SQL Gateway allows reports to be created by end users using Business Objects of 3 rd party SQL apps in near real time u Natural Reporter from NPP provides a means to automatically format and email the standard reports produced from the system n Other details: u BP views the revitalized system as a springboard to providing a wider range of info services to customers dd. mm. yyyy Software AG

Product Roadmap

Adabas SQL Gateway v 651 n General Availability Date – April 13, 2006 n Platforms: u Server on z/OS, z/VSE, HP-UX, Solaris, AIX, Linux Intel u Client on: AIX, HP-UX, Solaris, Linux (Intel) n Internationalization u Processing business data u Support Adabas UES u Unicode support for meta data u Support Arabic (Lam. Alef) n Supports DDL u Create/drop table/column with Adabas 5. 1 for Open Systems dd. mm. yyyy Software AG

Adabas SQL Gateway v 651 n Optimization u Super-Descriptors in MU/PE u End-of-query processing n Adabas SQL Server (ESQ) Migration u Data type Support – LA, MU, subfield u Information Schema u Mainframe support – 1. Step u Embedded SQL • Cobol pre-compiler on mainframe • C pre-compiler on Unix, Linux n Data Types u Long-alpha fields u W-fields dd. mm. yyyy Software AG

Adabas SQL Gateway v 652 n New Platform u Support of Linux on z. Series (64 -bit) • It has the following base components, as per other server platforms supported by the Adabas SQL Gateway: – JDBC Server (32 -bit) – ODBC Client (unix ODBC) – Embedded SQL – ACEINT command line query tool • Customers migrating applications to Adabas on on z/Linux will have easy access to Adabas data through standard SQL based applications dd. mm. yyyy Software AG

Adabas SQL Gateway v 652 n Performance Improvements u Multiple Descriptor searches • Usage of Multilple Descriptors, when descriptor columns are contained in a WHERE clause. The ‘S 1’ command is now used. In previous versions it was an ‘L 3’ command • Benefit: Faster and more efficient processing of SQL statements when the WHERE Clause is invoked u Changes to record update command processing • Improved processing of INSERT and UPDATE statements. • SQL statements that add or update records will run faster u Improved use of Adabas Direct calls dd. mm. yyyy Software AG

Adabas SQL Gateway v 661 n Target Release Date – 4 Q 2006 u u u Final step for ESQ Migration Next step of internationalization Large object support Enhanced metadata support (Predict) BS 2000 native support SQL Optimization dd. mm. yyyy Software AG

Adabas SQL Gateway - Demo Adabas SQL Gateway Demo using: Microsoft Excel, JAVA, Crystal Reports, . NET, Infonaut, Adabas SQL Gateway Dictionary dd. mm. yyyy Software AG

Key Takeaways: Adabas SQL Gateway Openness and interoperability with minimal resource usage n Why is it better? u No knowledge of Adabas required by programmers u Avoid costly and time-intensive integration projects u Traditional ‘mainframe class’ stability and service u Simple installation and configuration u Close integration with Adabas n What’s in it for the customer? u Increased productivity u Keeps costs down u Reduced training requirements u Agility and open access dd. mm. yyyy Software AG

New Developer Copy of the Adabas SQL Gateway

Adabas SQL Gateway Developer’s Edition n Why use the Adabas SQL Gateway Version 6. 5. 1 Developer's Edition? u See for yourself how easy it is to access Adabas Data? u Easy to install with step by step installation and configuration manual n Pick up a copy of the CD as you leave the session Thanks for listening and enjoy the rest of the conference dd. mm. yyyy Software AG

dd. mm. yyyy Software AG