How To Set Up Opera Cloud Integration

If you'd like to integrate your Opera Cloud account with TablePath, please complete the following steps:

Set up the User Defined Link for Reservations

Go to the Opera Cloud page. It should be in the format https://<instance>.oraclehospitality.<region>.ocs.oraclecloud.com/OPERA9/opera/operacloud
Make sure you are viewing Opera Cloud for a specific location rather than at the hub level. You can ensure this by clicking on your profile in the top right, selecting 'Change Location' and selecting the location you want to add TablePath for.
Click on the menu icon (top left of screen)
Click on 'Settings'
Under Customization, click 'Hub/Property Level' and then click 'Save'. You should see a warning section at the top of your page that says 'Customizing for <CHAIN CODE>'.
On the main menu, click 'Bookings > Reservations > Manage Reservation'.
Search for a reservation and open any of them by clicking on the link for the Confirmation Number.
Click on the settings icon (the cog wheel) on the right side of the booking.
Click 'Add Field > Flex Field > Add Link'. This should open a new window for adding a link to your reservations page.
In the new window, enter 'Manage TablePath Bookings' for the Text field.
Under the Destination section, click on the code button (it's the </> button) to bring up the page to enter the URL. The URL to enter is https://manage.tablepath.com/admin/reservations/opera-cloud?id=#{bindings.ConfirmationNo.inputValue}&arrival=#{bindings.TruncArrival.inputValue}&departure=#{bindings.TruncDeparture.inputValue}&phone=#{bindings.PhoneNumber.inputValue}&email=#{bindings.EmailAddress.inputValue}&room=#{bindings.Room.inputValue}&ratecode=#{bindings.RateCode.inputValue}&adults=#{bindings.Adults.inputValue}&children=#{bindings.Children.inputValue}
Click 'Evaluate' and then click 'Apply'.
Make sure the 'Displayed' option is set to 'Yes'
Under Launch URL mode, select 'Launch URL in Popup Window'.
Click 'Save' and then click 'Close Customize'. You should now see a new link added to your reservations page called 'Manage TablePath Bookings' that opens the TablePath page for that particular booking.

Set up the User Defined Link for Blocks

Go to the Opera Cloud page. If should be in the format https://<instance>.oraclehospitality.<region>.ocs.oraclecloud.com/OPERA9/opera/operacloud
Make sure you are viewing Opera Cloud for a specific location rather than at the hub level. You can ensure this by clicking on your profile in the top right, selecting 'Change Location' and selecting the location you want to add TablePath for.
On the main menu, click 'Bookings > Blocks > Manage Block'.
Search for a block and open any of them by clicking on the link for the Block ID.
Click on the settings icon (the cog wheel) on the right side of the booking.
Click 'Add Field > Flex Field > Add Link'. This should open a new window for adding a link to your reservations page.
In the new window, enter 'Manage TablePath Bookings' for the Text field.
Under the Destination section, click on the code button (it's the </> button) to bring up the page to enter the URL. The URL to enter is https://manage.tablepath.com/admin/reservations/opera-cloud?id=#{bindings.BlockId.inputValue}&arrival=#{bindings.StartDate.inputValue}&departure=#{bindings.EndDate.inputValue}&ratecode=#{bindings.RateCode.inputValue}&block=true
Click 'Evaluate' and then click 'Apply'.
Make sure the 'Displayed' option is set to 'Yes'.
Under Launch URL mode, select 'Launch URL in Popup Window'.
Click 'Save' and then click 'Close Customize'. You should now see a new link added to your blocks page called 'Manage TablePath Bookings' that opens the TablePath page for that particular block.

Disable Customise Mode

After setting up the 2 user defined links for reservations and blocks, you'll need to disable the customizing mode. Please do the following:
Click on the menu icon (top left of screen)
Click on 'Settings'
Under Customization, click 'Off' and then click 'Save'.

You should no longer see the Customizing warning section at the top of your page.

Create a new External System

Make sure you are signed in to the Hub, not the location. If you are not signed into the Hub, the external system will not be configured correctly.
Click on the Menu button and select 'Administration'.
Select 'Interfaces > Business Events > External Systems'.
Click on the 'New' button on the right.
Enter 'TABLEPATH_<CHAIN_CODE>' for the External System Code field. Please replace <CHAIN_CODE> with the chain code for your account.
Enter 'TablePath external system for OHIP Integration' in the Description field.
Set the Sequence to 1.
Check the box for 'Auto Configure External Databases'.
Click on the search icon beside 'Property' and select the relevant properties.
Click Save.

Enable Scheduled Activities

Click on the Menu button and select 'Administration'.
Select 'Enterprise > OPERA Controls'.
Make sure you are viewing the Opera controls for the specific property.
On the left navigation select 'Profile'.
Scroll down to the 'Scheduled Activities' section and make sure that it is enabled.

PLEASE NOTE: After completing the steps above, please contact TablePath support (support@tablepath.com) with the following details:

Your hotel code
Your chain code
Your Enterprise ID

These details will be used to request access to your Opera Cloud APIs. Your Opera Cloud user will require access to the developer portal, in order to accept our connection request.