Oracle Applications

Introduction to BI Publisher Enterprise
Demonstration

• Connecting to a database
• Extracting data as XML
• Creating a Layout Template
• Setting up Delivery Channels
• Delivering Documents
• Bursting Documents

Starbucks and BI Publisher Enterprise
Introduction to BIP Enterprise


BIP is the new standard for reporting from Oracle Part of Fusion Middleware Integrated into EBS, PeopleSoft, JDE, OBIEE, Siebel

Enterprise = Standalone
Completely Standalone Application
Use for all your business reporting regardless of data source
Integrates into existing OAS architecture
Integrates into existing J2EE Application Server

Separates Data Model from Report Formatting

2 fundamental components create output:

1. XML Data
2. Layout
3. 

Generating the Data
Navigate to Admin->Data Sources->JDBC Connection->Add Data Source


Generating the XML Data
Create XML using standard data extraction methods
Data can be extracted via

• SQL Queries
• Web Services
• XML Feeds
• Data Templates
• BI Answers

Data Template (Oracle Recommended)
-->Create a query and map results to XML Elements