XML Publisher

1
Welcome To NCAOUG 2007
2
XML PublisherTechnology
Presented by Kiran Kumar Akkiraju
3
Agenda Item 1 Document Management Requirements
4
Agenda Item 2 Issues with Classic Report Tools
5
Agenda Item 3 WHY XML Publisher???
6
Agenda Item 4 XML Publisher Concepts
7
Agenda Item 5 Demonstrate the Possibilities
8
Document Management Requirements
9
Document Management Requirements

• Rich Formatted Reports
• Partner Reports
• Financial Statements
• Government Forms
• Marketing Materials
• Contracts
• Checks
• Labels
• XML / EFT / EDI
• Multiple Destinations

10
No One System Can Do That
Check Print Server
Invoice Server
Label Manager
Report Formatter
Payment Server
Delivery Server

• 3rd party solutions are
• required to satisfy
• business requirements

11
Maintenance Cost More
Check Print Server
Invoice Server
Label Manager
Report Formatter

• Costly
• Time consuming
• Complex systems
• Expensive Maintenance
• Labor intensive

Payment Server
Delivery Server
12
Issues with Classic Reporting Tools
13
Classic Reporting Tools Issue

• Reports must be in same geometry, font, margin,
  size etc.,

14
Classic Reporting Tools Issue

• More resources

15
Classic Reporting Tools Issue

• Maintenance forever ..

16
Classic Reporting Tools Issues

• 1 data set 10 layouts 30 languages gtgt 300
  reports
• Requires highly-skilled engineers for
  customization

17
Classic Reporting Tools Issues
Data logic
Layout
Report file
Translation

• Less flexibility
• High development cost
• High customization cost
• Difficult upgrade

18
Why XML Publisher
19
Why XML Publisher?
Remove Complexity Reduce Total Cost
20
Integrated Document Management

• Oracle XML Publisher
• Authoring
• Managing
• Delivering
• Your Business Documents

• Meet Business Requirements
• Remove Complexity
• Reduce Maintenance Cost
• Reduce Total Cost

21
XML Publisher Concept

• Separate data / layout / UI translation

Data Logic
Layout
XML Publisher
Reportoutput
Translation

• More flexibility
• Reduced maintenance

22
XML Publisher Modules
PDF
Word
Excel
More
Template Manager
Template
Delivery Server
SQL
XSL
XML
XML
DataHandler
Data
ServiceBeans
WebServices
XML
XLIFF
EFT
Translation Handler
TranslationCatalogs
23
XML Publisher Customization

• Business consultants use familiar
• desktop tools for layout customization
• Support for Multiple Data Sources

24
CONCEPTS
25
From Data to Delivery
26
Extract Once Publish Multiple Times
27
XML Publisher Technology

• Adobe Acrobat MS Word
• MS Excel XSL Editors

X L S
P D F
R T F
X S L
28
Templates PDF Forms

• Government forms
• Tax Forms
• W-2

Utilize the latest Forms from the Gov. web site
PDF
XML Publisher
Data
Report Output
29
Templates PDF Forms

• Invoices
• Purchase Orders
• Check printing

Acrobat
Template Matches Printing Requirements
PDF
XML Publisher
Data
Report Output
30
Templates - RTF

• Marketing materials
• Contracts / Quoting
• Financials reports

MS Word
Authoring by marketing personnel
RTF
XSLFO
XML Publisher
Data
Report Output
31
Templates - Excel

• Financials reports
• Business reports

MS Excel
Authoring by Business Consultants
Excel
XSLFO
XML Publisher
Data
Report Output
32
Templates eText

• Electronic Payments (EFT / EDI)
• Bills Receivable
• Bank statement

MS Word
Authoring by IT / Business Consultant
RTF
XSL
XML Publisher
EFT
EDI
Data
Report Output
33
Demonstration
RTF Template
PDF Template
34
Steps Involved
1) Define Data Logic (Report definition)
2) Register Data Logic in Oracle Applications Env.
3) Define Layout
4) Register Data Logic as Data Definition in XML
Publisher
5) Register Layout as a Template in XML Publisher
6) Submit Registered Data Logic Program
35
Define Data Logic
36
Register Data Logic
Physical Report File Name
Concurrent Program name
Output Format XML
37
Define Layout
M S W O R D F O R M F i e l d s
Header
MS-Word Fields
38
TRX_NUMBER
lt?TRX_NUMBER?gt
39
Register Data Logic as a Data Definition in XML
Publisher
Concurrent Program Short name
40
Register Layout as a Template in XML Publisher
Data Definition
Template File
41
Submit Registered Data Logic Program
Concurrent Program Name
Template Name
42
Concurrent Program XML Output
XML Tags
43
Concurrent Program Output
44
Concurrent Program Output
45
Security

• PDF Security levels for
• Read only / Editable
• Copy Text
• Printable
• Password Protection

46
Language Support

• XML Publisher ships with full set of Unicode
  Fonts
• Scalable Unicode font embedding
• Support for font mapping and font linking
• XML Publisher is alone in supporting
• CJK
• BiDi
• Unicode
• MLS

47
Language Support

• Communicate with partners around the world in
  their languages
• 160 languages and 200 Territories (ISO Standards)
• Translate each template into 160 languages
• No dependency on the DB char set
• Utilize RTF or XLIFF for translation

48
XML PublisherBetter InformationFasterCheaper
49
Best in Class XML Publisher Provider Come to our
Booth for LIVE DEMOS and Chances to Win Fantastic
Prizes