Reports9i

1
(No Transcript)
2
Everbody Needs PublishingOracle Reports is what
you need!
Session id 40157

• Philipp WeckerlePrincipal Product Manager
• Oracle Corporation

3
Publishing Through the Ages
4
Fast-forwarding a little !
5
Challenge - Data Sources
Oracle
OLAP
JDBC
Text Files
Web Services
6
Challenge - Output Formats
7
Challenge - Output Destinations
8
A broader view of the Business Intelligence
Market

• Protracted and complex implementation
• Escalating maintenance costs
• Poor and incomplete BI solution

9
Oracle Business IntelligenceSingle Vendor
e-Business Intelligence
10
Oracle9i Reports What is it?

• A powerful enterprise reporting
• RAD tool that allows developers
• to publishany data, in any format, anywhere

11
Oracle Reportsany data l any format l anywhere
12
Publishing ALL the RIGHT data

• Out-of-the-box
• Oracle Database
• PL/SQL Ref-Cursor
• JDBC
• XML
• Oracle Express
• Oracle OLAP
• Text Files

• Open Java-API to add new data sources
• Parameter support for queries
• Unlimited queries
• Link queries

13
Pluggable Data Sources - Design time
14
Pluggable Data Sources - Runtime
XML
SQL
15
Any Data

• Unlimited queries
• Multiple concurrent connections
• Join data from different sources
• Re-entrant wizards
• Bind- and lexical parameters

16
Oracle Reportsany data l any format l anywhere
17
Paper vs Web Publishing
X
Y
18
Paper vs Web Publishing
19
Single Definition
Publish to Paper
Publish to Web
20
FlexibleFormatting
Excel
RTF
Web
PDF Printer
XML
21
Any Format

• Unlimited formatting full control over layout
  formats
• Exception formatting, Personalization via XML
• Multi-byte character support for PDF, HTML, RTF

22
PDF 1.4 Support

• Compression
• Multi-byte fonts
• Font Embedding Subsetting
• Accessibility
• PDF Taxonomy

23
Java Importer

• PL/SQL wrappers generated for Middle Tier Java
• Interface between Reports and Java
• Use Java as an integration layer
• Web Services
• SOAP
• CORBA

24
Any Format

• Specialized technologies for paper and web
  publishing
• Various output-formats
• High-fidelity graphing
• Access for middle-tier Java

25
Oracle Reportsany data l any format l anywhere
26
Anywhere

• Standards-based deployment JSP and Servlet
• Open Java-API to add your own destinations and
  notifications

• Out-of-the-box Printer, File, Browser, E-Mail,
  Oracle9iAS Portal, WebDAV, FTP
• OTN OracleAS Wireless

27
Report Bursting

• Different Layouts
• Different Destinations
• Email
• Different Recipients
• Printer
• File
• Different Output Formats
• HTML, HTMLCSS, PDF,Text, RTF, XML, delimited,
  PostScript, PCL

28
Destination Email

• From Sys Admin ltreports_at_oracle.comgt
• To Random, Joe ltjoe.random_at_oracle.comgt
• CC Accounts ltaccounts_at_oracle.comgt
• Bcc ceo_account ltceo_at_oracle.comgt
• Subject August Monthly Sales Figures
• Reply-to ltaccounts_at_oracle.comgt
• Importance High
• Return Receipt No
• Internet standard SMTP
• Static or dynamic values for ALL settings
• specify report as body or attachment

29
Anywhere

• Open Java-API for creating your own destination
• Powerful distribution facilities
• Bursting of Report Sections to different
  destinations
• Enhanced email support

30
Oracle Reports at a glance

• Declarative RAD environment for creating Web and
  paper reports in Oracle9i Developer Suite

DEVELOPMENT Oracle Reports Developer

• High-Fidelity Enterprise Publishing for the Web
  and paper in Oracle9i Application Server

DEVELOPMENT Oracle Application Server Reports
Services
31
Management Security
e-Business Integration
Portals
J2EE Internet Apps
Wireless
BusinessIntelligence
Caching
32
Rapid Development with Wizards

• Data modeling, paper and web layouts, graphs

33
Standards Based

• JSPs used as the underlying technology
• Separate out dynamic and static parts of a web
  page
• Compiled for fast execution
• Java and any markup language (typically HTML)

Your hostname lt request.getRemoteHost()
gt. ltLIgtltBgtDeclaration (plus expression).lt/BgtltBRgt
lt! private int accessCount 0 gt Accesses to
page since server reboot lt accessCount gt
34
Architecture A Closer Look
Oracle Application Server
Destinations, Notifications
Data Sources
Report Definition
User Access
Oracle Developer Suite
35
How to access the Server
Oracle9iAS Reports Services
36
Reducing complexityOut-of-the-box Integration

• Oracle9i JDeveloper
• Oracle Application Server Portal
• Oracle BI beans
• Oracle Forms Developer
• Oracle Application Server Discoverer
• Oracle Enterprise Manager Application Server
  Console
• Oracle Application Server Single Signon
• Oracle Applciation Server Containers for J2EE
• Oracle SCM

37
Out-of-the-box IntegrationOracleAS Discoverer
Enterprise Reporting
Adhoc Query Analysis
38
Migration fromOracleAS Portal Report Component
39
Oracle Reports Portlets
40
Oracle OLAP Data Source

• Unleash the power of the Oracle9i Database with
  built-in OLAP
• Wizard-based interface to pick Business Areas,
  Dimensions, and Measures

41
Oracle JDeveloper Integration

• Create, Run, Debug JSPs
• Create new Destinations
• Registered JSP Tag Library

42
Oracle Workflow Integration

• Reports available as Workflow Activity

43
Single Sign-On

• Application Security
• Secure report resources
• Data Security
• Secure data source access
• User logs on ONCE and canSECURELY run a report
  against any numberof data sources

44
Open Infrastructure
Oracle9iReports
Security Service
Destinations
Plug-In Interface
Engines
Notifications
Cache Manager
45
OracleAS Reports ServicesScheduling

• Any job can be scheduled for
• Delayed execution
• schedulelast_weekday_before_15_from_1553_Oct_23,
  _2001_retry_after_1_hour
• Repeated execution
• scheduleevery_first_fri_of_month_from_1553_Oct_2
  3,_2001_retry_3_after_1_hour

46
Pluggable Notifications

• Open Java API
• Create your own notification mechanisms

47
Enterprise Manager Integration

• Start/Stop/Restart
• Performance metrics
• Queue Information
• Trace Information
• Modify Configuration

48
D E M O N S T R A T I O N
49
Summary

• Access the data that is important to you
• Create output in any Format
• Securely Publish Anywhere
• Tightly Integrated Component of Oracle
  Application Server and Oracle Developer Suite

50
Next Steps.

• Recommended sessions
• Integrated Business Intelligence
• Recommended demos and/or hands-on labs
• Integrated Business Intelligence Hands-On lab
• Oracle Reports on the DEMOgrounds
• See Your Business in Our Software
• Visit the DEMOgrounds for more information.
• Relevant web sites to visit for more information
• http//otn.oracle.com/products/reports

51
A
52
Reminder please complete the OracleWorld
online session surveyThank you.
53
(No Transcript)