StarRez Lite
StarRez is a student property management platform.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | BOOKING_TYPE , CUSTOM_FIELD_USAGE_TYPE_ENUM , ENTRY_STATUS_ENUM , ENROLLMENT_TYPE_ENUM , FIELD_DATA_TYPE_ENUM , GENDER_ENUM , GENDER_TYPE_ENUM , GL_POSTING_TYPE_ENUM , GROUP_STATUS_ENUM , NATIONALITY , RECORD_TYPE_ENUM , ROOM_RATE_DURATION_ENUM , ROOM_SPACE_TYPE_ENUM , and TRANSACTION_TYPE_ENUM tables. |
History mode | ||
Custom data | check | BOOKING , CHARGE_GROUP , CHARGE_ITEM , ENTRY , ENTRY_APPLICATION , ENTRY_DETAIL , ENTRY_ENROLLMENT , GROUPS , ROOMBASE , ROOM_LOCATION , ROOM_SPACE_CLOSED , ROOM_SPACE_DETAIL , ROOM_SPACE_MAINTENANCE , ROOM_TYPE , TERM_SESSION , and TRANSACTION tables. |
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | check | BOOKING_TYPE , CUSTOM_FIELD_USAGE_TYPE_ENUM , ENROLLMENT_TYPE_ENUM , ENTRY_STATUS_ENUM , FIELD_DATA_TYPE_ENUM , GENDER_ENUM , GL_POSTING_TYPE_ENUM , GROUP_STATUS_ENUM , NATIONALITY , ROOM_RATE_DURATION_ENUM , ROOM_SPACE_TYPE_ENUM , ROOMSPACE_CLOSED_REASON , and TRANSACTION_TYPE_ENUM tables. |
Fivetran data models | ||
Private networking | ||
Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
NOTE: You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step StarRez setup guide to connect StarRez with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
APPLICATION_STATUS
BOOKING
BOOKING_CUSTOM_FIELD
CATEGORY
CHARGE_GROUP
CHARGE_ITEM
CUSTOM_FIELD_DEFINITION
DELETED_TRANSACTION
ENTRY
ENTRY_ADDRESS
ENTRY_APPLICATION
ENTRY_APPLICATION_CUSTOM_FIELD
ENTRY_CUSTOM_FIELD
ENTRY_DETAIL
ENTRY_ENROLLMENT
GENERIC_TABLE_DATA
GENERIC_TABLE_DATA_FIELD
GENERIC_TABLE_DEFINITION
GENERIC_TABLE_DEFINITION_FIELD
GL_POSTING
GROUPS
LOG_ACTIVITY_DELETE
PROMO_CODE
PROMO_CODE_RECORD
PROMO_CODE_USAGE
ROOMBASE
ROOMSPACE
ROOM_CONFIGURATION
ROOM_CONFIGURATION_TERM_TYPE
ROOM_LOCATION
ROOM_LOCATION_FLOOR_SUITE
ROOM_LOCATION_SECTION
ROOM_RATE
ROOM_RATE_ROOM_TYPE_LOCATION
ROOM_RATE_SESSION
ROOM_SPACE_CLOSED
ROOM_SPACE_DETAIL
ROOM_SPACE_MAINTENANCE
ROOM_SPACE_MAINTENANCE_CATEGORY
ROOM_SPACE_MAINTENANCE_ITEM
ROOM_TYPE
SECURITY_USER
TERM
TERM_SESSION
TERM_TYPE
TRANSACTION
To capture updates and deletes, we also re-import the remaining tables and their child tables during every sync.
Schema information
After you set up the connection, you can view the schema in the Schema tab of the connection details page.