IBM System Builder IBM SB for Uni Data

IBM Software Group | Information Management software Trademarks and Acknowledgements The following are trademarks or registered trademarks of the IBM Corporation: AIX®, DB 2 Universal Database™, Dynamic Connect™, Red. Back®, System. Builder™, U 2™, Uni. Data®, Uni. Verse®, w. Integrate®. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Intel, Intel logo, Intel Inside logo, Intel Centrino logo, Celeron, Intel Xeon, Intel Speed. Step, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. UNIX is a registered trademark of The Open Group in the United States and other countries. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. Other company, product, or service names may be trademarks or service marks of others. © 2007 IBM Corporation 2

IBM Software Group | Information Management software System. Builder Overview IBM System. Builder™ enables rapid application development with flexible deployment options for the IBM Uni. Verse® and IBM Uni. Data® (U 2™) Multi. Value data servers. System. Builder includes both IBM U 2 SB+ for Uni. Data and Uni. Verse (SB+), a powerful rapid application development environment for host-based and client/server development, and IBM U 2 SBClient for Uni. Data and Uni. Verse (SBClient), a presentation layer. § Enables development of mission-critical business solutions optimized for Multi. Value data servers § Promotes application maintainability and portability § Enables rapid, flexible development and deployment § Simplifies application management with reusable processes © 2007 IBM Corporation 3

IBM Software Group | Information Management software System. Builder Value § Sophisticated 4 GL native to Multi. Value databases – Definition Based User Interface • Enables flexible presentation choices – Definition Based Business Logic • Enables non-programmers to build programs by defining business rules • Allows complex business applications to be built quickly without a single line of code § Easily and quickly revamp existing mature, functional applications § Used in 20% of all U 2 partners § Leveraged for development across all industries and geographies © 2007 IBM Corporation 4

IBM Software Group | Information Management software System. Builder Industry Leverage § Cross Industry § Distribution § Energy § Finance § Healthcare § Insurance § Manufacturing § Not for profit § Retail § Systems Integration http: //www-306. ibm. com/software/data/u 2/solutions/find. html © 2007 IBM Corporation 5

IBM Software Group | Information Management software System. Builder Use Case § Membership Solution; 93 sites; 2400 seats § Example Wins – Single site – 300 users U 2, U 2 Web DE, STDBY • Membership system in UK • Win over Oracle • IBM Solution including BI, CM, IM – Single site – 30 user Uni. Data, U 2 Web DE • Case study presented at 2006 IOD Conference § Example Losses – Small site – 30 users – Small site – 50 users • Both due to “aged look of cosmetics” • Inquired about screen shots, beta program to help stem loss © 2007 IBM Corporation 6

IBM Software Group | Information Management software System. Builder Components U 2 Data Server SBClient § Data store § Presentation layer SB+ Screen Designer § Application server § Design SB+ screens, logic © 2007 IBM Corporation 7

IBM Software Group | Information Management software SB+ Overview § 4 GL Multiplatform Multi. Value Rapid Application Development Environment § Character & graphical development of Client/Server applications with automatic generation of source code and documentation § The most respected and proven 4 GL in the Multi. Value marketplace for on-line transaction processing applications © 2007 IBM Corporation 9

IBM Software Group | Information Management software SB+ Developer Value § SB+ shields developers and users from operating system commands and data server commands – Developers do not need to know commands and syntax for every platform – Not limited to the SB+ Application Development Environment – Still can execute OS commands and native OS functions, and procedural languages – Develop applications based on business rules and logic § SB+ provides open systems connectivity, GUI presentation, platform independent coding, and Windows application linking © 2007 IBM Corporation 10

IBM Software Group | Information Management software SB+ Value Proposition § Complete and proven application development suite of tools for enterprise-wide development of host based, client/server and stand alone business applications § Provides incremental migration to latest technologies and leverage on existing development § Increased productivity: Most productive toolset in the marketplace – Requires a significant less number of programmers to develop and maintain software applications § Intuitive: Complementary suite of tools to cater technical and non-technical individuals § Scalable: Allows development of single and multi-user applications in standalone or multiple client/server configurations – Supporting CRTs and Desktop PCs in one environment – Coexistance strategy for U 2 Web DE and the Web § Cost-effective: SB+ automates the most tedious tasks of the software development cycle, including revision control and documentation, and multilanguage support § Low cost of ownership: Application maintenance and GUI/Active X deployment is as easy as it gets © 2007 IBM Corporation 11

IBM Software Group | Information Management software Office Security Administration Runtime Tools SB+ Applications

IBM Software Group | Information Management software SB+ Tools § Field Definition § Screen Painter § Report Writer § Processes: – Building Blocks of SB+ – Global or Local Processes – Used to build the Application – Processes can call other Processes – Many ‘hooks’ from many Processes types © 2007 IBM Corporation 13

IBM Software Group | Information Management software SB+ Tools § Automatic User and Technical Documentation § Revision Control § Language Translation § Active. X, OLE and DDE Support § Many other application development features © 2007 IBM Corporation 14

IBM Software Group | Information Management software SB+ Expressions § Used to derive values for – field assignments – defaults – validations – updates – selections § Standard syntax throughout SB+ § Supports Dictionary names and Equates © 2007 IBM Corporation 15

IBM Software Group | Information Management software SB+ Applications § SB+ Code is portable across many platforms § Optimize code with Generated Source § Run same application with GUI and ASCII terminals © 2007 IBM Corporation 16

IBM Software Group | Information Management software Multi-Language Support § Main features and Setup requirements: – Design and implement applications using the base language – Set up language tables in SB for target users – Perform the translation of text used in the application – Add translated text for each language to the application – Enable the application's multi-language flag – Set the default language for the module – Set user's language flag to the appropriate language (each user can use different language provided it was already set) © 2007 IBM Corporation 17

IBM Software Group | Information Management software SBClient Value Proposition § Provides a graphical user interface for PC emulation users § Leverages existing development by providing incremental migration from character via terminal emulation to full event driven Windows GUI § Provides connectivity capabilities (Serial, TCP/IP, IPX) § Delivers Host/PC Windows integration including DDE, file transfers § Contains enhanced reporting query system: Smart Query § Provides integration with third party object components such as VBX and ACTIVEX § Supports standard e-mail application program interface (MAPI) § Enables interoperability with other databases via ODBC § Adds secure connections with SSL © 2007 IBM Corporation 19

IBM Software Group | Information Management software SBClient Functions § Automatic conversion of SB+ character-based applications to Windows GUI § Systematic migration of BASIC applications to Windows GUI § Terminal emulation § Connectivity § Data transfer capabilities § Graphical desktop § PC/host integration © 2007 IBM Corporation 20

IBM Software Group | Information Management software SBClient Main Features § Automatic GUItization of SB+ character based applications § Incremental migration of legacy applications to GUI and Client/Server § Feature rich terminal emulation and file transfer support including FTP, passive FTP, XY Z modem, Samba § Object oriented environment for legacy application enhancement § Windows interoperability § DDE, OLE and VBX support § Host Library (MAPI, WORD, EXCEL) § Data Transfer (NCP, FTP, SBZ, Samba) § Smart Query § Creating Scripts § SB OLE (Call SB+ process from VB Application) © 2007 IBM Corporation 21

IBM Software Group | Information Management software U 2 Web Designer § Feature-rich environment for creating and modifying Web pages § Eclipse-based § Introduced in U 2 Web DE 4. 3 § Automates conversion of existing SB+ input and output processes to Web pages § Enables Web page design – Data driven Web pages – No knowledge of HTML required – No Web programming knowledge required © 2007 IBM Corporation 22

IBM Software Group | Information Management software U 2 Web Designer © 2007 IBM

IBM Software Group | Information Management software Operating Environment § Data servers – IBM Uni. Verse, or – IBM Uni. Data § Supported platforms (SB+) – Microsoft® Windows® – IBM AIX® – Sun™ Solaris™ – HP-UX – Linux® § Supported platforms (SBClient) – Microsoft Windows © 2007 IBM Corporation 24

IBM Software Group | Information Management software System. Builder Configuration § IBM System. Builder includes the following orderable components: – IBM SB+ for Uni. Data and Uni. Verse • Priced per concurrent session • Previously sold as SB+ Runtime and SB+ Developer – IBM SBClient for Uni. Data and Uni. Verse • Priced per concurrent session • Device licensing capable – SB+ Bundles • SB+ U 2 Value Pack bundle includes 1 SB+ license, 1 SBClient license, and 1 database license (either Uni. Verse or Uni. Data). • SB+ Client Value Pack bundle includes 1 SB+ license and 1 SBClient license © 2007 IBM Corporation 25

IBM Software Group | Information Management software System. Builder Futures § Architecture – Separation of UI from business logic – Multiple user interfaces, (e. g. Browser, GUI, mobile) – Interoperability (i. e. SOA. ) § Windows Presentation Foundation (WPF) – Definition based UI, similar to SB+ definition based environment. – Support for Internationalization and accessibility. § Windows Communication Foundation (WCF) – Provides security and recoverability between the clients and middle tier. – Simplify deployment and management of large numbers of users. © 2007 IBM Corporation 26

IBM Software Group | Information Management software SB 6. 0 Architecture Host U 2 Data Server SB+ Runtime SBClient 5. 4 Application 2 -way Communication Middle Tier . NET Framework Proxy Server SB+ Middle Tier Framework SB+ Web Services HTTP, HTTPS, or Sockets Client . NET Framework Browser Mobile Device SBClient 6. 0 GUI SBClient 6. 0 Browser GUI SBClient 6. 0 Mobile Application GUI Client (WPF) Application Browser GUI Client (WPF) Application Mobile Client GUI Browser Mobile Web Services Consumer Web Services IBM statements of direction are not a commitment. IBM plans are subject to change at IBM discretion. © 2007 IBM Corporation 27

IBM Software Group | Information Management software Additional Information § IBM U 2 home page – ibm. com/software/u 2 § Information Management Today Newsletter – ibm. com/software/data/db 2 infonews § U 2 Users Group www. u 2 ug. org § Email U 2 Ask. Us@us. ibm. com Copyright IBM Corp. 2007 All Rights Reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp" © 2007 IBM Corporation 28