Using Oracle BI Publisher to Create JD Edwards EnterpriseOne Reports Day, Date, 2004 timeDecember p.m. ET 18, Thursday, 2008 1:00 PM MDT Teleconference Access: North America: xxxx International: xxxx
Teleconference Access: Password: Advisor Toll Free – (888) 259-4812
Upcoming live webcasts and recent recordings: December 16, 2008: Preparing for Canadian T4 & Releve Reporting: Year-End Processes December 17, 2008: JD Edwards EnterpriseOne Human Capital Management 9.0 December 18, 2008: Using Oracle BI Publisher to Create JD Edwards EnterpriseOne Reports January 8, 2009: JD Edwards EnterpriseOne integration to Oracle CRM On Demand January 13, 2009: Oracle ST: Moving from Transparent Gateway for DB2400 to Database Gateway for DRDA
Toll – (706) 679-4880
January 15, 2009: JD Edwards World: A91 Enhancements to the Inventory Management System
Conf. ID – 71889760
January 20, 2009: Oracle Rdb Proactive Debugging Option January 20, 2009: JD Edwards World: Using the Job Status Inquiry Screen January 21, 2009: Communication Apps: Introduction to Re-Rating January 27, 2009: Communication Apps: Performing Network Processor Upgrades on IPSA January 27, 2009: PeopleSoft Enterprise Campus Solutions 2009-2010 Financial Aid US Regulatory 2 January 29, 2009: Communication Apps: Mapping PSR Service Orders to an ASR Service Request
Agenda • •
Presentation and Demo – approximately 45 minutes Q&A Session – approximately 15 minutes •
Please hold all questions to the end of the session.
•
To ask a question, move your cursor to the top of the screen and select the ‘bubble’ icon next to the moderator’s name.
•
A dialog box will open. Enter your question and select “Send.”
•
During the Q&A session your question will be read and an answer will follow.
ATTENTION – AUDIO INFORMATION
If you encounter any audio issues, please call InterCall (Audio Conferencing) and mute your phone. 1-888-259-4812 +1-706-679-4880 Passcode: 71889760 We would like to encourage attendees with sufficient Internet bandwidth to listen through VoiceStreaming to continue to use this audio source. Thank you.
Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
BI Publisher for JD Edwards EnterpriseOne Jeff Erickson Principal Product Manager JD Edwards EnterpriseOne
Agenda • Embedded BI Publisher • JDBC Driver Overview • Architecture • Configuration
• Usage with BI Publisher Enterprise • Q&A
Embedded BI Publisher – 8.97 Combine existing UBEs with powerful Publish & Distribute capabilities of BI Publisher Extract
Transform
Publish
Distribute
PDF RTF
BI Publisher
HTML Excel
UBE XSL
Report Definition
XML EDI EFT
XML Repository
Email
Printer
Report Definition - Setup
Report Definition - Setup
Report Definition - Setup
This report will burst on address
- A full set will be sent to Max - A full set will be sent to Curtis - An individual section will be sent to each email found
JDBC Driver Overview
JDBC Driver Capabilities • Read Only • Enforces JD Edwards Security • Applies JD Edward EnterpriseOne Data Formats • Date fields • Math Numeric fields
JD Edwards EnterpriseOne Data Access Server Java Applications Oracle SOA Suite BPEL PM
B 2 B
B A M
Third Party
Other read only JDBC compliant app
Oracle BI Publisher
Enterprise Service Bus (ESB)
Browser
Thin JDE E1 JDBC interface
HTML / javascript
HTML Server
Web Services
JMS
Business Services
Business Events
Tools 8.98
JDBC
Data Access Server New in
J2EE
Tools 8.98
Business Functions
Database Batch Enterprise Server
JDE E1
14
Security Server
Non JDE E1 Component Industry Standard JDE E1 Component
Data Access Server - DAS • Separate download from MetaLink 3 • Managed via Server Manager • Installed • Configured • JDBJ • Managed Server • Start • Stop
DAS via Server Manager - Install
DAS via Server Manager - JDBJ
JDBC Driver with BI Publisher
Interactive BI Publisher Empower users to create their own reports Extract
Transform
Publish
Distribute
Via JDBC
PDF RTF
JDE EnterpriseOne
Email
HTML Excel
Printer
XML EDI EFT
Fax
BI Publisher Enterprise Edition
BI Publisher – Interactive Reports
BI Publisher – Interactive Reports
BI Publisher – Interactive Reports
BI Publisher – Interactive Reports
BI Publisher – Interactive Reports
Single Solution with BI Publisher Transform
Extract JDE EnterpriseOne
Publish
Distribute
BI Publisher
PDF RTF
Email
HTML Excel
Printer
XML EDI EFT
UBE XSL
Report Definition
Fax
BI Publisher High-Fidelity Reporting One Solution for All Document Needs 9Purchase Orders 9Labels / Bar Codes 9Collateral 9Employee Forms 9Government Forms 9Order Forms 9Invoices 9Operational Reports 9Correspondence 9Financial Statements 9Checks
When to use Embedded or Interactive Reports?? EMBEDDED • An event in JDE E1 triggers the report. • Need to update data in the database. • Data manipulation. • No user action.
INTERACTIVE • An event outside of JDE E1 triggers the report. • Read only data. • Minimal data manipulation. • Ad-hoc or on-demand.
Other Consideration • An ESU is required for embedded solution • 8.11 SP1 and above
• JDBC Driver/BI Publisher is 8.11 SP1 and above • Need to conduct performance testing • Impact to DB
Additional information • JDBC Driver Use Cases • Integrations • Third party products
• Documentation • Install and configuration of JDBC Driver • JD EnterpriseOne BI Publisher Guide • JD EnterpriseOne Server Manager Guide • Redpaper • How to create BI Publisher Reports • Oracle BI Publisher guides • Customer Connection Page
Questions •
To ask a question, move your cursor to the top of the screen and select the ‘bubble’ icon next to the moderator’s name.
•
A dialog box will open. Enter your question and select “Send.”
THANK YOU