endorsedOngoing

Opera to AvaTax Integration and Hotel Portal

Services Covered:

Custom Software Development • API Development • Application Integration

Industry

Financial Services

3 months

Budget

50K - 199K

Start Date

1 June 2020

Team Size

6-10

Engagement Model

Offshore

Project Capability Score (PCS)

75/100

Good

Project Capability Score (PCS) estimates how capable Sciant is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Avalara

Seattle, United States of America

Project Summary

An automated tax compliance provider engaged Sciant to build a custom export from Opera PMS and a middleware web application to map and post guest invoice data to the AvaTax API. Sciant delivered the Opera export, SFTP-based processing, a hotel portal for credential management, and the AvaTax integration, meeting or exceeding timelines and expectations. The client praised Sciant's industry expertise and collaborative approach, describing the team as a strong business partner.

Key Challenges

Build a tool to extract data from Opera into the client's software platform
Find a business partner with domain expertise in the hotel and lodging industry

Project Deliverables

Custom Opera export to extract guest invoice data
Middleware web application to convert Opera export format to AvaTax API format and post invoices
Hotel portal for SFTP credential management and tax detail viewing
Setup of Opera Export and SFTP on the integration application
Authentication integration with the AvaTax API and ongoing consumption/cleanup of Opera export files
Data QA, support notifications, and download/display of tax rates from AvaTax API

Project Solution

Sciant designed and developed a custom export from Opera PMS and a middleware web application that receives Opera guest invoice data, converts the export format to the AvaTax API format, and posts invoices to the AvaTax API. They provided a portal for hotels to manage SFTP credentials and view tax details, set up Opera export and SFTP on the integration application, implemented authentication to AvaTax API, ensured ongoing consumption and cleanup of Opera exports, and handled data QA, support notifications, and tax rate retrieval and display.

Project Outcome

Project completed and met or exceeded all deliverable dates and expectations
Strong collaborative engagement and industry expertise established a foundation for partnership

Platforms

API/Integration Platform
Web

Tech Stack

REST API

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The company was satisfied with the results of the project upon launch. The team was able to meet all of their deliverables on time and on budget, exceeding expectations. The team was full of experts that used a collaborative approach and added their input to make the project better.”
Andrew Kim
Director of Business Development
Date: 09/14/2020