Maintain for Action-Oriented BI Mark Derwin and Mark

Maintain An Introduction § What is Maintain? § Maintain is a way to easily

Maintain An Introduction § What is Maintain? § English-like syntax and language wizards used to create § § robust commands for database retrieval and update. Our code is very simple and short. Java requires many more lines of code, as compared with maintain, for doing a specific task like interfacing with databases. The Maintain language and development environment can be learned in a short amount of time. Copyright 2007, Information Builders. Slide 3

Maintain An Introduction § What is Maintain? § Graphical User Interface for designing and deploying multi§ form applications. Pixel perfect positioning of objects on your forms including, List Boxes, Combo Boxes, HTMLTables, Buttons and Radio Groups Seamlessly integrate Java. Script, VB Script and HTML code into your forms. Copyright 2007, Information Builders. Slide 4

Maintain An Introduction § What is Maintain? § Easily retrieve, display and manipulate large sets of data § § from up to 15 separate databases. Databases can be on different servers across your enterprise. Databases can be dissimilar. With the IWAY adapters, your application can switch to any database engine. § If your outgrow your database vendor or you think your database vendor is not treating you well, the switch is almost effortless. Copyright 2007, Information Builders. Slide 5

Maintain An Introduction § What is Maintain? Modular code allows for Team Development, Cross Enterprise deployment and reusable procedures. Integrate existing Table and Graph procedures for both database retrieval and display. Closed-Loop Business Intelligence Ties Maintain to Table Update Assist for Rapid Application Development Copyright 2007, Information Builders. Slide 6

Maintain Who uses Maintain? More than 300 client sites around the world are using Maintain. Manufacturers GM, Pratt & Whitney, Lockheed Martin, Siemens Westinghouse Schools and Universities, Brown, Omaha Public Schools, Harvard, Henry Ford, Seton Hall Government and City Agencies US Army Corps of Engineers, US Navy, NASA, US Dept of Justice, Florida Dept of Transportation, City of Philadelphia Insurance and Healthcare Nationwide, Harleysville, Allstate, Blue Shield, Tri. Health, UCLA Healthcare, Virginia Mason, CIGNA Banks Citizens Bank, Bank of Montreal, Comerica, Northern Trust Other Boston Globe, Qwest, Bell Canada, Burlington Northern Copyright 2007, Information Builders. Slide 7

Maintain: New Enhancements Copyright 2007, Information Builders. Slide 8

Maintain: New Enhancements Browser Compatibility § A push has been made to allow Maintain to perform on all browsers. § Compatible with Opera, Safari and Firefox Browsers § Issues § Active-X object Grid § VBScript Triggers – Phase out. Copyright 2007, Information Builders. Slide 9

Maintain: New Enhancements Browser Compatibility Copyright 2007, Information Builders. Slide 10

Maintain: New Enhancements Mobile Maintain § Design applications to run on Portable devices § Access data sources as if in office § Opera and Safari browsers completely supported § Create VERY small screens for update § Use Java. Script techniques to avoid screen refresh § Visible vs Invisible § Validation on browser instead of server § Allow for selection to reduce amount of entry needed. Copyright 2007, Information Builders. Slide 11

Maintain: New Enhancements Mobile Maintain Copyright 2007, Information Builders. Slide 12

Maintain: New Enhancements Mobile Maintain - Black. Berry § Black. Berry devices with track balls supported § Currently stylesheets are not supported § Objects display in tab order § Objects without tab orders, text, pictures, etc… display on top of other objects § No line break for all objects § Use Radio groups and check boxes formatting Copyright 2007, Information Builders. Slide 13

Maintain: New Enhancements Mobile Maintain - Black. Berry §Drop down Combo Boxes select Parish and Shelter §HTMLTable with Combo Boxes and Enterable fields get values §Save to the Database and run live reports Copyright 2007, Information Builders. Slide 14

Maintain: New Enhancements IBIValidate § Let Maintain validate your input field § Three levels of validation: § 0 – No (Default) § 1 – Yes § 2 – Required § If left at 0, no validation occurs § If set to 1, entered data must be in the correct format § If set to 2, data must be entered and in the correct format Copyright 2007, Information Builders. Slide 15

Maintain: New Features IBIValidate Copyright 2007, Information Builders. Slide 16

Maintain: New Features UTF-8 Support Copyright 2007, Information Builders. Slide 17

Maintain: New Features Z-Index § Browsers can change the “weight” of an object, thus placing one object behind another instead of how you create it. § New Z-Index feature to control the placement of objects on the form in release 7. 65: § Currently controlled by either Java. Script or Style. Sheet § Each object has a numeric value. An object with the higher value gets displayed over an object with a lower value. § Option is being added to the properties sheet inside the MDE. Copyright 2007, Information Builders. Slide 18

Maintain: New Features Deployment Enhancements § Retain XML after deploy in release 7. 65. § MNT files deployed to the web strip out the XML to create Winforms files. § The XML is needed to rebuild with forms in the MDE § Forms in deployed MNT files cannot be displayed in the MDE § New deploy option keeps the XML in deployed files for editing. Copyright 2007, Information Builders. Slide 19

Maintain: New Features Development Enhancements § Maintain and Web. Services § Use Maintain as front end to query Web. Services, retrieve data and update databases. § Ability to perform almost any actions from inside a Maintain procedure: § Anything that you can do with Java. Script! § Kicking off e-mail either with or without conformation § Placing appointments on Outlook calendars § Restricting Calendar object to “Select Only” § Mixed case Master File Description Support § Makes entire application case sensitive Copyright 2007, Information Builders. Slide 20

Maintain Applications Copyright 2007, Information Builders. Slide 21

Maintain Applications AC Restaurants and Hotels § AC Restaurants and Hotels are located along the major highways in Belgium and the Netherlands. § They provide great dining and sleeping arrangements as well as full-service event/meeting facilities. § Provided users with a web application for time-registration, including a real-time & batch interface with their HR application. § Executives have vital information available at their fingertips to aid in decision-making. Employees can efficiently obtain employee info directly from the Unit 4 HR application. Data doesn’t have to be manually replicated anymore and is directly available for uploading in the HR Application. Copyright 2007, Information Builders. Slide 22

Maintain Applications AC Restaurants and Hotels Copyright 2007, Information Builders. Slide 23

Maintain Applications AC Restaurants and Hotels Copyright 2007, Information Builders. Slide 24

Maintain Applications State of Wyoming § The Wyoming Department of Corrections Information System (WCIS) § § § is a centralized application designed to track offenders as they move thru the entire Corrections system from the initial arrest, pre-sentence or initial investigation, court sentencing, incarceration, probation and parole and finally termination. It is used by the central DOC office in Cheyenne, the State Penitentiary at Rawlins, the Women's Center at Lusk, the Honor Farm at Riverton, the Conservation Camp at Newcastle, along with the Probation and Parole Offices around the state. Application created in Mainframe Focus and migrated to Web. FOCUS. The application has over 300 users. Copyright 2007, Information Builders. Slide 25

Maintain Applications State of Wyoming Copyright 2007, Information Builders. Slide 26

Maintain Applications State of Wyoming Copyright 2007, Information Builders. Slide 27

Maintain Applications State of Wyoming Copyright 2007, Information Builders. Slide 28

Maintain Applications State of Wyoming Copyright 2007, Information Builders. Slide 29

Maintain Applications Randstad § Consultants are able to enter data about their customer visits into the system. § They log on to a dashboard, via a security layer, and can enter dates for the units they are assigned to. § This enables Business analysts to enter any changes, or new developments concerning reports/dashboard. § It’s an easy way for to keep track of development. § The uploader module lets analysts load up excel files into the MIS system. They simply have to select the file on their system and select the type of upload file. Copyright 2007, Information Builders. Slide 30