Connecting to Data · Legacy self-service product
Oracle BI
Import Oracle BI reports into Scoop for AI-powered analysis
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.
- Run your report in Oracle BI
- Export as HTML format
- Upload to Scoop or forward via email
See Importing HTML Reports for detailed steps.
Method 2: CSV/Excel Export
For simpler data:
- Export your Oracle BI report as CSV or Excel
- Upload directly to Scoop
Method 3: Email Automation
Set up scheduled Oracle BI reports to email automatically:
- Configure Oracle BI to email reports on a schedule
- Forward emails to your Scoop ingest address
- Scoop processes attachments automatically
See Email Automated Imports for setup.
What You Can Analyze
| Data Type | Recommended Export | Notes |
|---|---|---|
| Financial Reports | HTML or Excel | Preserves formatting |
| Operational Dashboards | CSV | Clean tabular data |
| Banded/Grouped Reports | HTML or Excel | Scoop auto-detects subtotals |
| Ad-hoc Queries | CSV | Direct data export |
Best Practices
- Use HTML for complex reports - Tables, grouping, and formatting preserved
- Use CSV for simple data - Fastest processing
- Include headers - Helps Scoop identify columns
- 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.