Oracle Hospitality OPERA Report Scheduling and SFTP Delivery to d2o PMI
Guide to configuring, validating, monitoring, and troubleshooting OPERA report exports delivered to PMI through SFTP.
System integration
Explore · Connect · Set up
System integration
The connections behind PMI. Find out how your systems supply the data that supports planning, forecasting and daily decisions.
Start here
What do you need to do?
Choose a starting point. You don’t need to know the technical terms.
Browse by system
Which system are you connecting?
Start with the kind of system you use, then find its setup guides and data requirements.
Property management (PMS)Rooms, occupancy, arrivals and departures.
Point of sale (POS)Restaurant, bar and outlet sales.
TimekeepingWorked hours and labor data.
AccountingFinancial and accounting data.
Revenue managementRevenue forecasts and hotel market data.
F&B reservationsRestaurant reservations and food cost data.
Sales & cateringMeetings, events and catering data.
All system integration articles
Browse the complete collection of setup guides and reference material.
Report 4 (manual export): Reservation History & Forecast (history_forecast)
This article explains how to export both past and upcoming arrivals and departures data from Opera PMS. Use it to feed PMI with detailed guest flow…
System integration
Report 3 (manual export): Trial Balance (trial_balance)
This guide explains how to export daily revenue and ledger data from Opera PMS — one file per historical date — so your PMI system can…
System integration
Report 2 (manual export): Reservation Forecast, (res_forecast)
This guide covers how to export future projections of room nights, guest nights, and room revenue from Opera PMS. Use this report to populate forward-looking data…
System integration
Report 1 (manual export): Reservation Statistics 1 (res_statistics1)
In this article, you'll learn how to manually export reservation data from Opera PMS—covering metrics like room nights and guest stays. Use this report to generate…
System integration
Manual Export PMS Opera
This guide outlines how to manually export historical reports from Opera PMS to support the initial setup of PMI and ensure a complete import of historical…
System integration
Opera Scheduler setup – SFTP transfer guide
In this article, you'll learn how to configure secure file transfers between Opera (or your systems) and PMI using SFTP. We walk you through creating the…
System integration
Opera Scheduler setup – Daily Forecast Report
In this article, you'll learn how to configure and schedule a daily forecast report in Opera to export future M&E (meetings & events) revenue data to…
System integration
Opera Scheduler setup – Reservation History & Forecast (history_forecast)
This article shows you how to export arrivals and departures data (past and upcoming) from Opera PMS, helping you keep PMI updated with detailed guest flow…
System integration
Opera Scheduler setup – Reservation Forecast, (res_forecast)
In this article, you'll learn how to schedule and export future projections of room revenue, room nights, and guest nights from Opera PMS—providing your PMI system…
System integration