Skip to main content

Micros Oracle BI API

Updated

API Setup for Micros Oracle BI API

We need to ensure that you grant us the correct accesses within your system and we need 7 pieces of data from you for authentication purposes.

Data Access Permissions needed within your Oracle system:

  • Sales and Operations
  • Point of Sale Definitions
  • Personal Identifier Information

For Authentication purposes, we also require the following:

  • Authentication Server URL : This is found in the API account password reset confirmation email.
  • Application Server URL: In the browser, after logging into Reporting and Analytics.
  • User Name and Password
  • Client ID – Autogenerated by Oracle.
  • Enterprise Short Name: This is found in the API account password reset confirmation email.
  • Location Reference

All of this information can be located using this guide from Oracle: Oracle (9).png

 

If Oracle doesn't provide you with your Location Reference, discover it by following these instructions. 

These instructions may vary based on which version of Simphony R&A is in use at your property. 

Discover your Location Reference

  1. Open EMC
  2.  Select Enterprise / Organization level
  3. Enterprise Parameters module > Reporting & Analytics tab
  4. Location Reference (photo below)

 

Related articles