Türkiye Bilişim Derneği İstanbul Bilişim Kongresi Oracle Yazılım Araçları Mayıs 2009
Kıvanç Güler 6 Years of Oracle Development Experience As Had – Java Developer&DBA As Was – Oracle Technical Consultant. As Is – International Project Team Leader – Contractual Lecturer@ITICU http: //www. kivancg. com http: //kivancg. blogspot. com kivancg@kivancg. com
You are here; you must be. . . • • Forms Developer Reports Developer Plsql Developer JDeveloper 10 g What is new for you? • • Forms Developer Learn ADF or APEX Reports Developer Learn BI Publisher And Apex Plsql Developer Learn APEX JDeveloper 10 g Upgrade to 11 g and Learn ADF
Oracle Application Express APEX 3. 1
You’re a good candidate for HTML DB if you fit the following profile • You are, or have developers who are, skilled in SQL and PL/SQL • Your application is database-centric • Your application can be developed using a hosted service • You are comfortable with a declarative/4 GL programming model • • You want to migrate an Access / Excel application to Oracle
Apex Positioning Enterprise Java PL/SQL Departmental PHP, Perl, Python APEX Mid Tier Data Tier
Apex Benefits Simplify Application Development on Oracle • Development – Easy point-and-click – Reduces Time, Complexity and Expense – No Client Software – Leverages existing SQL Skills – Integrated SQL Workshop • Architecture – Integrated into Database – Multi Tenant Hosting • No extra cost (feature of the database) • PL/SQL Developers • Non-professional developers • Power users Departments Small enterprises
Browser Based • Browser Based Application Development • No Client Software to Develop, Deploy, or Run Applications • Full Service: Application Building, SQL Workshop, Utilities
Application Express – Declarative • No code is generated • You write some SQL and optionally PL/SQL snippets • Declarative development yields fewer differences between developers • Less risk for developer introduced security issues • Meta data driven
Consolidation with HTML DB Spreadsheets Desktop Databases File Servers HTML DB Any Browser
Architecture Overview With the Embedded PL/SQL Gateway (XE and 11 g) With Apache and mod_plsql
BI Publisher • Declarative PDF Reporting Services • Create Professional looking Reports • Range of Document Formats
Declarative PDF Reporting Services • Select Report Document Formats
Flash Charts • 18 New Chart Types • Migrate existing SVG Charts
Improved Web Services • Extended Support – Web Services created using JDeveloper – Oracle BPEL synchronous Web services • Interact with Web services over SSL (HTTPS) – Including services requiring basic authentication • Manually create Web service references
Drag & Drop Item Creation • Quickly create and Delete items • Reorder and place items • Change selected item attributes
Review of Oracle Application Express 2. 2 New Features • Packaged Application – Wizard based install of a complete “Application” • Access Control Wizard – Include an “Admin” Page for added Application security • Dictionary Views – View Application Metadata • New Item Finder Search Tool – Quickly search for Application & Database objects • Copy pages – Within the Application or to another Application • Component-level Export • Read about other 2. 2 Specific “New Features”
Conclusion • • • Improved Reporting and Charting Access Migration – Consolidation Additional Item Types Better ability to incorporate Web Services Enhancements for Developers Improved Administration • More information and downloads • Oracle APEX 2 -Day Developer tutorial • Download pre-built applications – Packaged Applications – APEX Studio (apex. oracle. com/studio) http: //apex. oracle. com http: //otn. oracle. com/apex
Integration with CERN Single Sign-on Various user profiles and access rights Linked with CERN’s Electronic Document Handling system
Context Tooltips CERN official holidays Custom Calendar (HTP. P)
Integration with picture database Javascript driven buttons Vertical reporting
Standard SVG graph widgets
JEE Comparison Effort n n n Very small “entry cost” Very convenient for “simple” applications Doesn’t scale too well with app complexity JEE Oracle APEX convenience zone ? Results
Oracle Business Intelligence Publisher • http: //www. oracle. com/technology/obe_bi/bipub/index. html
BI Publisher Architecture Design Data Models, Administer server View & Schedule Reports, Office Integration, Build Report Layouts Web Services Interface DHTML - AJAX Interface Data Sources Oracle DB, Oracle BI EE, SQL Server, DB 2, …JDBC Company Portal, SAP, MSFT CRM Oracle EBS-PSFT-JDE-CRM BI Publisher Enterprise Server Report Processing Data Extraction Web Services, XML, HTTP, Custom Applications Output Formats Scheduling & Delivery Excel, EFT, EDI, XML Rendering Security PDF, HTML, RTF, Delivery Report Repository J 2 EE Container; Oracle, Web. Sphere, BEA, Tomcat. . Printer, FAX, Email, Web DAV, FTP, B 2 B Security SSO, OID, LDAP, Oracle BI, EBS, JNDI Interface Report Repository Oracle DB or File System Scheduling & Archiving Any DB; Oracle, DB 2, SQL Server, …
Web Based Administration Create / Secure Data sources Secure System Resources Multiple Delivery Options
Manage Catalog, Windows Explorer Style Search for reports Manage Catalog like Windows Explorer Hierarchical Folders
Web based Development Multiple SQL Queries Query Builder Generate SQL Parse SQL Multiple Parameters Cascading Lo. Vs Multiple Layouts
DHTML Query Builder Self-Join from Manager_Id to Employee Drag & Drop Join Building Generated SQL Supports Oracle, MS SQL, DB 2, Sybase, My. SQL. .
Report Parameters Supports: - Tables, Views - Synonyms Large number of tables supported (EBS schema) Use Report Parameters
List of Values Use SQL queries or static Lo. Vs Query Builder available Parameters are mapped to Lo. Vs Link queries for cascading Lo. Vs
Development – Layout Templates
Define Report Bursting Data is fetched by a single query then split into different reports Bursting Query defines for each document: - Layout - Locale - Channel: Email, Print… - Destination
BI Publisher – Dashboard Integration Dashboard prompts are passed as report parameters. Highly formatted BI Publisher reports can bebe embedded added browsed and in the BI EE Dashboard. to a BI dashboard.
BI EE Answer Request Data Sources User The user has direct access create adhoc queries easily to BI Answer. And published to the request data sources in MSreport server or the Word. using BI dashboard. Answers Sophisticated formats are easily created in Microsoft Word or EXCEL
Building Reports Enhance the Layout in Microsoft Word Preview the document Create multiple groupings on flat table data … Publish it to the BI Publisher Server Table Wizard Select the Date Model from the BI Publisher Server … And run the report from the server. Sort the data Select Fields
… Advanced Reports, Use the Chart Wizard… Use the Crosstab Wizard And finish the formatting in Microsoft Word.
… Business Documents, Report finished in minutes Insert the Data Fields Load an existing Word Document – e. g. a Microsoft Word Template
BI Publisher Report Catalog Search for reports “Google” style search results page Search folders and reports – perform actions from the search results page. End user responsibilities can be limited to viewing and/or running reports
Report Viewer Cascading Parameters Select one of multiple layouts Output options: PDF, HTML, RTF and EXCEL Multiple charts with 3 D and Gradient effects
Online Analyzer – Pivoting Drag & Drop Data selection Analyze Data Drill in place functionality
Excel Analyzer Refresh Data Refresh and change parameters Change Report Parameters Pivot Table based on report data Users can access relational DB data from within Excel with application security. No need to copy data from Oracle DB to MS Access any more. Upload and schedule spreadsheets EXCEL spreadsheets updated even on a LINUX server!
Schedule Reports Many customers would need RAC option to store scheduled report output and snapshot data Flexible Scheduling Options Multiple Destinations including Oracle Files
Schedule and History The Schedule is available per report or per user. User can show private The data from long and/or public schedule queries running can be stored and reformatted. The runtime and delivery status are available for simple and burst jobs Private and Public Reports. Public scheduled reports are visible to Output and/or data of users with report access rights. batch jobs can be viewed here.
One Solution for all Reporting Requirements 45 Oracle Confidential
BI Publisher Features • • • Built on Standards Platform Independent High performance reporting engine High volume / advanced printing support Advanced support for multiple languages Communicate in multiple formats: PDF, XML, EDI Report from multiple Databases (Oracle, DB 2, etc) Familiar report design interface Multiple delivery options
Oracle Application Development Framework via Oracle Jdeveloper 11 G Official Site; • • http: //www. oracle. com/technology/products/jdev/index. html http: //www. oracle. com/technology/obe 11 jdev/11/dvt/gant_chart_pivot_table. htm Blogs; • • • http: //technology. amis. nl/blog/category/oracle/adf-jheadstart http: //blogs. oracle. com/Didier/2006/03/adf_sample_applications. html http: //andrejusb-samples. blogspot. com/search/label/ADF? max-results=20
What is a Framework? • Prebuilt architecture for solving a particular problem – Provides a key service • For example, Struts framework provides control of page flow in a web application – Code library, development method, tools – An extension of good reusable code strategies • Solve a problem once, use the code again in multiple projects • Like an API – Allows extensions • To replace or supplement functionality
Benefits of a Framework • Promises increased productivity through code reuse – Prebuilt code supplies functionality you would have to build yourself • For example, connection layer to the database through JDBC – You write less 3 GL code • Simplifies complexity of a high-level architecture – Complexity is hidden in the prebuilt code – Handles infrastructure and communication between layers – You just hook into it • Provides structure to the myriad number of technology combinations – The path to a particular goal is predefined
Oracle Application Development Framework (ADF) • Attempt to meet the J 2 EE challenges – Lots of technology choices – No integrated tool – Database connectivity is difficult (JDBC) • Available starting in JDeveloper 10 g • A wrapper for other frameworks • An architecture with code libraries – Implies a method and a tool • Based on Model-View-Controller J 2 EE design pattern
View Application Client Swing model Swing event handlers Web Client Swing visual aspect JSP ADF UIX ADF JClient JSF Controller Struts JSF Model ADF Bindings ADF Data Controls Business Services EJB Session Beans Web Services ADF Business Components Java Classes
Model ADF Bindings ADF Data Controls • The main innovation of ADF! • Connects Business Services to the View layer – Java local clients (heavy client) • Delivers data from Business Services to the View layer – Web clients (light client) • Receives instructions from the Controller layer as requests for data retrieval and updates • ADF Data Controls – Interface components pre-bound to Model layer • ADF Bindings – The method for accessing Model objects
Controller Struts JSF • For web clients only • Determines what happens when user submits page – Prepare next page to display – Can apply conditional logic – Can interact with data (Model) • Struts - JDev 10 g 9. 0. 5 and 10. 1. 2 – Jakarta Project open source effort • Java. Server Faces – JDev 10. 1. 3 – Replaces Struts in JDev
Application Client Swing model Swing event handlers ADF JClient Swing visual aspect View Web Client ADF UIX JSP JSF • User interface technologies – Application client • Java runtime on the client • Part of J 2 SE (standard edition) • Uses JClient framework to communicate with Model layer – Web client • Java. Server Pages (JSP) technology • Java. Server Faces (JSF) – J 2 EE standard, light-client, tag-based – Java interface community • ADF UIX effort – J 2 EE 1. 5 – Oracle-specific, XML-based interface used by E-Business Suite applications
ADF Faces • Oracle tag libraries – Released to My. Faces open source project in Jan. – Available in JDeveloper 10. 1. 3 • Implements components available in UIX – UIX (User-Interface XML) is used in Oracle Applications • Adds even more functionality to JSF • Supports multiple platforms through “render kits” – JSP document or page – Telnet – Wireless
ADF Faces Features • Lots of Prebuilt stuff – UI components • Master-detail – Form-table, table-form, form-form • Data navigation controls • Color picker • Button and link • Tab menu bar • Progress meter • Editable, tree – Layout objects – page, form, header – No need to manage images
Some ADF Data Input Components Text input LOV item Read-only item Button Tip item Date input with date picker Pulldown item • Items include prompts • Bound to data model object
Some ADF Components Tab menu bar with subtabs Shuttle Tree
ADF Data Controls Using ADF Faces Editable Search form
Benefits of ADF Faces • “Smart” controls – partial page submit – AJAX • Asynchronous Java. Script and XML • A. k. a. , Partial Page Rendering – Java. Script effects without Java. Script coding • Support in JDeveloper – Drag and drop automatic binding – Property settings – Expression builders Ajax provides a cleaner user interface!
Development Method 1. 2. 3. 4. • Create application workspace Create Business Services and Model project Create View and Controller project Test and debug Use the same tools for development regardless of technology choices Demo
Can ADF Faces Help You? • It can help shops that have J 2 EE experts – J 2 EE experts will be more productive – They need to learn the ADF process • It can also help shops who have “traditional” non-J 2 EE Oracle developers – Forms and PL/SQL developers will be productive with the declarative tools • With training, they can write Java extensions • Much of the complexity is hidden – They need a J 2 EE expert to guide them and code the internal, complex stuff
Summary • Frameworks help development – Forms is a framework – Usually, not so easy for J 2 EE applications • ADF is a framework and it also helps • ADF Faces comes close to Forms – Nearly-equal productivity – Extremely rich component set – Support for declarative and visual programming – Requires a bit of ramp up time – It’s J 2 EE-compliant and you still need a J 2 EE architect
Q & A
Скачать презентацию Türkiye Bilişim Derneği İstanbul Bilişim Kongresi Oracle Yazılım
aac8e177b9fd0a38a2e28402d83e64ce.ppt