Sync custom events from Microsoft SQL Server to OneSignal to trigger automated Journeys and personalized messaging campaigns based on user behavior.
Create dedicated user for OneSignal
Grant read permissions
<your-schema>
with your actual schema name containing event data. Repeat this command for each schema you want OneSignal to access.Configure Advanced Sync Engine (Optional)
Connect to OneSignal
CENSUS
OneSignal Field | Description | Required | |
---|---|---|---|
name | event_name | Event identifier | Yes |
external_id | user_id | User identifier | Yes |
timestamp | event_timestamp | When event occurred | No |
properties | event_data | No |
GRANT SELECT, VIEW DEFINITION ON SCHEMA::<schema>
statement for each schema containing event data.