SevenRooms
SevenRooms is a hospitality platform that helps restaurants, hotels, and other venues manage reservations, guest profiles, and customer engagement. With Weld, you can sync reservation, client, and venue data from SevenRooms into your data warehouse for reporting and analysis.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Column level |
| Blocking | True | Column level |
| Incremental | True | |
| Custom data | False | |
| History | False | |
| ReSync | True | Table level |
| Templates | False |
Data Schema
Setup Guide - ELT
Prerequisites
To connect SevenRooms to Weld, you need API credentials provisioned by SevenRooms. Contact your SevenRooms representative to request access.
Step 1 - Gather your API credentials
Before setting up the connector in Weld, collect the following from SevenRooms:
- Client ID — your API client identifier
- Client Secret — the secret associated with your API client
- Venue Group ID — the identifier for your venue group
These credentials are scoped to your venue group and are required to authenticate with the SevenRooms API.
Step 2 - Select your environment
Choose the environment that matches where your venue is configured. Demo credentials will not work against production endpoints, and vice versa.
| Environment | Base URL |
|---|---|
| Demo | https://demo.sevenrooms.com/api-ext/2_4/ |
| US Production | https://api.sevenrooms.com/2_4/ |
| EU Production | https://api.eu.sevenrooms.com/2_4/ |
- Use Demo if your venue is configured in the SevenRooms demo environment.
- Use EU Production if your venue is hosted on SevenRooms' European servers.
- Use US Production for all other production venues.
Step 3 - Connect to Weld
- In the connector setup form, enter the destination schema name of your choice. This name will be used to identify the connection in future syncs.
- Enter your Client ID, Client Secret, and Venue Group ID.
- Select the Environment that matches your venue configuration from Step 2.
- Click Connect to validate the credentials and establish the connection.
Step 4 - Data To Sync
- Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.
Step 5 - Configure sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your SevenRooms account.