Guide: Oracle Simphony - API
How do core concepts map to Tenzo?
Key: ✅ Supported 🚸 Work in Progress ❌ Not supported
 |
|
|---|---|
| Location | ✅ Location IDs |
| Order Type | ✅ Order Type |
| Revenue Center | ✅ Revenue Centers |
| Product Item | ✅ Menu Item |
| Product Category | ✅ Family Group |
| Product Division | ✅ Major Group |
| Tender Type | ✅ Tender Type |
| Employee | ✅ Employee |
| Customer | ❌ Not supported |
| Discount | ✅ Discount |
| TicketItemDiscounts | ❌ Not supported |
| TicketDiscounts | ✅ Discount |
| TicketItemModifiers | ✅ Modifiers |
| Guest Count | ✅ Guest Count |
| Transaction length | ✅ Closing Date - Creation Date |
| Delivery Timings | ❌ Not supported |
| KDS Bump Time | ❌ Not supported |
| Ticket Voids | ✅ Canceled |
| Ticket Item Voids | ❌ Not supported |
| Table | ✅ Table |
| Service Charge | ✅ Service Charge |
| Tips | ✅ Tips |
| Price | ✅ Price from sales items |
Data Ingestion
| Real-time optionally available? | ✅ |
| Default polling frequency | Every 20 minutes |
| Data retrieved on each poll | Today and yesterday |
| Historical data | All data since you started using your POS |
| Data received per day or continuous | Per Day |
Requirements
Tenzo uses Oracle Reporting and Analytics' Business Intelligence API. Therefore the requirements for the Oracle Simphony - API integration are:
- Oracle Reporting and Analytics version 20.1 or higher.
The version number can be found at the bottom left of your Reporting & Analytics WebApp:
How do I connect this data to Tenzo?
Simphony can be connected directly inside of the Tenzo app.
If you have an Enterprise Account, you can talk to your Customer Success Manager, who will connect this for you.
How do I compare Simphony data to data in Tenzo?
In Simphony we match to the Net Sales report.
Once logged in, navigate to Library and search for Net Sales.
Once here, the 'Edit Parameters' button can be used to choose the date and locations.
In Tenzo, all settings must be unchecked. These can be found by clicking on the settings icon:
The Simphony numbers will then match the numbers in the Sales → Location module within Tenzo:
Exceptions
- Simphony front-end may show modifiers as items. In Tenzo these modifiers have been attributed to their relevant items. This may cause a mismatch between Tenzo and Simphony for Items, Categories (Sales and Quantity) and Division (Quantity only).
- 'Charged Tips' appear on the 'Service Charge' report in Simphony, therefore they appear as a service charge in Tenzo. This means that the 'Tips' card on the Employee Dashboard will not contain this data.
- Tenzo displays data on the day the transaction is opened. Occasionally there may be transactions which are closed a few days later so there could be a mismatch in this instance, although this is rare.
- Simphony Guest Checks report will show the total payment amount of the Check if a Check is split between guests. This can lead to Tenzo and Simphony mismatching if comparing payments to Guests Checks.