This app extracts data (e.g. inventory, reservations, folio) from apaleo (via API calls and webhooks) and synchronises it with the Snowflake data warehouse (cloud data plattform).
The aim of the project is to make the data obtained in apaleo accessible to a business intelligence software (e.g. Microsoft Power BI) and to evaluate it with regard to KPI and data-driven insights.
Please find the demo in the demo.mp4 here.
This app is a proof of concept. There is no authentication in this app.
This app is written with the next.js React Framwork.
In order for the apaleo webhooks and UI integration to work, it must be accessible (even in development) via an SSL encrypted public endpoint on port 443.
You can use ngrok to get an SSL encrypted public URL and tunnel to your development system.
Create a connected app in apaleo with at least the following scopes: reservations.read integration:ui-integrations.manage folios.read reports.read. Note client id and secret.
Rename .env.local.example to .env.local and enter the apaleo and snowflake credentials.
npm install # first time
npm run dev
ngrok http 3000 # optional if you use ngrokOpen https://[PUBLICURL]/setup. If you see "Setup completed!" everything works fine and webhooks are activated.
Open apaleo > account context > app menu > Snowflake. Click on "Sync with Snowflake" button. Your data will now be initially transferred to Snowflake.
The easiest way to deploy this app is with Vercel or the Digitalocean App Platform. The Azure App Service is also possible with a little extra effort. Other deployment options (Node Server or Docker) are described here.
If you want to experiment with some apaleo data and Power BI, you can use the hackathon.pbix in the repository. The data, measures, KPIs and reports shown are stored there for offline usage.