Oracle BI

Overview

Oracle BI (including Oracle BI Publisher, Oracle Analytics, and Oracle Reports) can export data that Scoop imports directly. While there's no native API connector, Scoop's file import capabilities make it easy to analyze Oracle BI data.

Connection Methods

Method 1: HTML Export (Recommended)

Oracle BI can export reports as HTML, which Scoop imports with full table structure preserved.

1. Run your report in Oracle BI
2. Export as HTML format
3. Upload to Scoop or forward via email

See Importing HTML Reports for detailed steps.

Method 2: CSV/Excel Export

For simpler data:

1. Export your Oracle BI report as CSV or Excel
2. Upload directly to Scoop

Method 3: Email Automation

Set up scheduled Oracle BI reports to email automatically:

1. Configure Oracle BI to email reports on a schedule
2. Forward emails to your Scoop ingest address
3. Scoop processes attachments automatically

See Email Automated Imports for setup.

What You Can Analyze

Best Practices

1. Use HTML for complex reports - Tables, grouping, and formatting preserved
2. Use CSV for simple data - Fastest processing
3. Include headers - Helps Scoop identify columns
4. Set up email automation - For recurring reports

Handling Grouped Reports

Oracle Reports often include subtotals and group breaks. Scoop automatically:

• Detects grouping levels
• Removes subtotal rows
• Preserves data for analysis

See Grouped Reports for details.

Related Resources

• Importing HTML Reports
• Email Automated Imports
• Grouped Reports