ODTUG 2006 Overview Lucas Jellema Business Intelligence SOA

ODTUG 2006 – Overview Lucas Jellema Business Intelligence SOA, BPEL Integration Java/J 2 EE ODTUG 2006 - Overview 1

ODTUG 2006 - Overview 2

Zondag: 13. 30 – 16. 30 Pretty Java Server Faces Lucas Jellema AMIS, The Netherlands ODTUG 2006 - Overview 3

Dinsdag: 8. 30 - 9. 30 Oracle Quiz on SQL and PL/SQL The Water is Still Burning Alex Nuijten & Lucas Jellema AMIS, The Netherlands ODTUG 2006 - Overview 4

Dinsdag 11. 00 – 12. 00 Migrating Oracle Forms to ADF and JSF using JHeadstart Lucas Jellema AMIS, The Netherlands (on behalf of Steven Davelaar) ODTUG 2006 - Overview 5

ODTUG 2006 - Overview 6

Introducing JHeadstart compared to Oracle Designer JHeadstart JDeveloper plugin Application Definition § Layout, lookup, master/detail, domains, regions, CRUD Generate ADF Faces application JDeveloper Manual Page Refinement § CRUD, layout, prompt, boilerplate text Oracle Designer Repository Object Navigator & Design Editor Module Components § Templates Generate! Actions Manual Page Refinement using Editors, Wizards and Property Palettes § Layout, Item Groups, CRUD Application Logic Domains Generate Oracle Forms application Forms Builder Manual Page Refinement ODTUG 2006 - Overview Actions Meta-data for Module Definition 7

Generating with JHeadstart Stand-Alone or Migrate Oracle Designer & Forms JHeadstart Actions Meta-data for Module Definition Templates JHeadstart Designer Generator JDeveloper Forms Builder ODTUG 2006 - Overview Actions Manual Page Refinement Oracle Designer Design Capture Generate! Oracle Designer 8

The ODTUG Conference Manager ODTUG 2006 - Overview 9

ODTUG 2006 - Overview 10

ODTUG 2006 - Overview 11

Migration Result http: //technology. amis. nl/blog/wp-content/images/jhsmig 4. jpg ODTUG 2006 - Overview 12

Woensdag: 9. 45 – 10. 45 PL/SQL Design Patterns Pre-Inventing The Wheel ODTUG 2006 Lucas Jellema AMIS, The Netherlands ODTUG 2006 - Overview 13

Suggesties achteraf van Steven Feuerstein… Congratulations again on a fine presentation. Before too much time passes, I will give you some feedback. As I said, I hope you continue to give this presentation. . . it is an important one in our space. . . * Intro: you mention that design patterns don't even originally come from software. I assume you were talking about Christopher Alexander? But you never said. You might want to close that loop. I find it fascinating. * I think I am a fairly typical PL/SQL developer in that I don't have an indepth IT background/education. Highly abstract ideas tend to confuse me and make it hard for me to engage with the material. This is part of the problem I have with Fowler's refactoring and G of 4 design patterns. Lots of fancy talk and big words for what are often very common-sensical ideas. Your talk attempts to bring the DP world to PL/SQL developers by carrying over that fairly high level of abstraction, and I believe that for many it makes it harder to grasp. * I would first of all start by stating a problem. Then show the specific problem is reflective of a more general class. Show a PL/SQL solution, then reframe it as an example of a particular design pattern. That is, you get people to think more abstractly by moving them from specific to general, not by presenting a highly general pattern as the starting point. Example: Dependency injection = "Avoid hard-coding values" Here are your options, typical approach perhaps not so great, what about THIS idea? Ah and it is a common pattern. . * I think you should say somewhere, maybe at the end, that these design patterns often seem like a fancy name for something obvious or common. Then explain the benefit of thinking about it in more general terms, as a pattern. * slide 11: you might want to distinguish that OO patterns may not fit procedural PL/SQL, but surely if you are using OTs they can fit pretty well! And again, rather than point out where all those OO patterns may not apply, START with PL/SQL / database programming patterns that clearly DO apply! * I suggest that at the end of each individual pattern presentation, you ask for questions before moving on the next. This can be a challenge on time, but worth it to engage the audience more, esp with something this abstract. Also, if you START with a PL/SQL example/pattern, you can involve the audience by asking them to see if they can identify a pattern within the code. . . have them think "up" to a pattern WITH you. * The observer pattern: again, so abstract, but really not uncommon in the Oracle world: DBMS_ALERT (which few use, but many are aware of). . . make those linkages to help people understand more easily. * You mention 40 as milliseconds but it is hundredths of seconds, correct? * Cover LESS in your talk. Do a WHOLE separate talk on AOP in PL/SQL, but don't do it in this talk. If you take the above approach of starting with a common PL/SQL problem and generalizing to a pattern, you will not be able to cover so much. . * With AOP, I suggest that you provide an example that shows an app registering several services/aspects, much like you would want to do in a "real" app: register logger; register exception handler; register. . . Well, I hope you find this helpful. You are a fine presenter and I am glad you are joining me to push the limits of how people use and think about PL/SQL! ODTUG 2006 - Overview 14

Oracle Business Intelligence Strategie Oracle Warehouse Builder 10 g. R 2 is productie § Core ETL is nu onderdeel van database (licentie) § Drie extra opties – bovenop Enterprise Edition ODTUG 2006 - Overview 15

Oracle Business Intelligence Strategie Siebel Analytics Server nu Oracle BI Server Siebel heeft substantieel marktaandeel in BI, vooral voor zeer grote ondernemingen § Lufthansa, Cisco Systems, Etos, Xerox, Microsoft, IBM Pre-packaged ETL processen en OLAP kubussen voor SAP, Siebel, Oracle Applications en JDEdwards XML Publisher wordt BI Publisher ODTUG 2006 - Overview 16

Oracle BI Server C++ applicatie § ODBC en SOAP interface, that enables virtually any ODBC-capable report writer or query tool to query the Oracle Business Intelligence Analytics Server as if it were a database Verzamelt data uit allerlei bronsystemen zoals RBDMS, Microsoft Analysis Services cubes en SAP BW § Geen voorkeur voor Oracle database, geen profijt van specifieke Oracle functionaliteit Draait op UNIX en Windows – nog niet op LINUX ODTUG 2006 - Overview 17

Oracle BI Suite Standard Edition ‘Traditionele’ Oracle BI Tools § § Discoverer – Plus en OLAP Spreadsheet OLAP Plugin (voor Excel) BI Beans Oracle Reports $400 per named user ODTUG 2006 - Overview 18

Oracle BI Suite Standard Edition Discoverer: § Geen gedwongen migratie § 20. 000 Discoverer klanten § Geen ingrijpende nieuwe functionaliteit, wel nieuwe releases (10. 1. 2. 2, 11 g) OLAP Spreadsheet Addin § Write back to database, share with other users § Floating editor, integrated Excel taskbar § Connectie met Discoverer Catalog BI Beans § Verbeterd met de look & feel van Siebel web componenten § Thick Client beans gaan verdwijnen § Basis voor Discoverer en Enterprise Planning & Budgetting ODTUG 2006 - Overview 19

Oracle Forms Oracle Apps 12 op Forms 10. 1. 2 § Release eind 2006? ? ? Oracle 10 g. AS 10. 1. 3 krijgt geen Forms Server Forms 11 g § Java. Script API § Betere Application Server integration (SSO/LDAP, EM Grid Control) § Call out from Forms to BPEL Processes, to Java Middle Tier and External Web. Services § Trigger Forms events with external events from AQ § Tuning Wizard § Support for Database Proxy Users § Release begin 2008? ? ? ODTUG 2006 - Overview 20

Oracle Designer Certificatie voor 10 g. R 2, 11 g en verder § Ontwikkelaars kunnen eigen uitbreidingen op Designer via een extensie-programma aan het core product laten toevoegen • ROB Insert, Update, Delete ODTUG 2006 - Overview 21

Oracle BPEL PM Weinig presentaties specifiek over BPEL PM Wel veel referenties naar BPEL PM § Alle producten willen zich graag daarmee associeren • • • Forms in a SOA world ADF Faces front end for BPEL Processes BI for BAM for BPEL Processes How PL/SQL can participate in a SOA APEX and BPEL SQL Developer meets BPEL PM …. Clemens ‘machine gun’ Utschig deed twee presentaties § Advanced BPEL – 45 man, 2 BPEL PM “gebruikers” ODTUG 2006 - Overview 22

Java/J 2 EE JSF – Java Server Faces § (bijna) Geen Struts en ‘plain’ JSP te bekennen Weinig (niets? ) over EJB 3. 0 Persistence ADF Faces Rich Client Components ADF: § Recipes § Security § Het boek van Duncan Mills en Peter Koletzke ODTUG 2006 - Overview 23

Tutti Frutti General Session: § 50% Designer en/of Forms, 20% JDeveloper, tussen 10 en 20% SQL Developer, Warehouse Builder en APEX (voorheen HTML DB) Database 11 g § Specificaties bevroren § Beta rond OOW (najaar 2006? ), Productie voorjaar 2007 (Linux) en najaar (Windows)? § Feature: Versioning Data Mining § Gebruik DBMS_PREDICTIVE_ANALYTICS om relevante kolommen te vinden én waarden te voorspellen (10 g. R 2) ODTUG 2006 - Overview 24

Dé onderwerpen om in de gaten te houden… Oracle BPEL PM ADF Faces (+ ADF BC en ADF Binding) § Rich Client Components Oracle BI Suite (EE) Oracle Warehouse Builder 10 g. R 2 Core ETL Forms, PL/SQL en SQL ODTUG 2006 - Overview 25

IJking AMIS Crossroads Bevestigd: § § § ADF Faces Forms BPEL PM Oracle Warehouse Builder Oracle Portal, XML Publisher (Her)overweging: § § APEX (Application Express vh HTML DB) Oracle BI Suite EE BI Beans, Oracle OLAP Oracle Reports ODTUG 2006 - Overview 26

Resultaten ODTUG 2006 voor AMIS Naamsbekendheid, Zichtbaarheid en Image Contacten § Oracle Product Managers – ADF, BI & OWB, SQL Developer, Designer, Forms, § Toppers in BI, DBA, PL/SQL … Commerciele aanknopingspunten Persoonlijke ontwikkeling Kennis en inzichten, verificatie AMIS Crossroads Stof tot nadenken, discussieren, bloggen etc. Organisatie ODTUG-Europa in 2007? ? ODTUG 2006 - Overview 27