Skip to main content

Overview

The OneSignal + SingleStore integration enables syncing of custom events from your SingleStore database to OneSignal to trigger automated messaging campaigns and Journeys based on user behavior. SingleStore is a distributed SQL database designed for real-time analytics and high-performance applications.

What data syncs

Data moves one way, from SingleStore into OneSignal. The SingleStore integration does not create users or subscriptions, set Tags, or import audiences. OneSignal does not send message events to SingleStore. To send message events to a system you control, use Event Streams. See what data each integration syncs to compare integrations.

Requirements

OneSignal

  • A paid OneSignal plan. This integration isn’t available on the Free plan. See plans.

SingleStore

  • SingleStoreDB Cloud or SingleStoreDB v7.1+
  • Database user with appropriate permissions
  • Event tables containing structured behavioral data
  • Network connectivity from OneSignal to your SingleStore cluster

Setup

1

Create dedicated user for OneSignal

Create a dedicated user account with a strong, unique password:
2

Grant permissions to event data

Provide read-only access to schemas containing your event data:
If you have multiple schemas containing event data, repeat the GRANT SELECT statement for each schema.
3

Connect to OneSignal

In OneSignal, go to Data > Integrations and click Add Integration.Select SingleStore and provide the following connection details:
  • Host: Your SingleStore cluster endpoint
  • Port: 3306 (default)
  • Database: Your database name
  • Username: CENSUS
  • Password: The password from Step 1

Event data mapping

Map your SingleStore event data to OneSignal’s custom events format:
The Sync Key is the column you designate as the unique identifier for each row during sync. OneSignal uses it to detect whether a row has already been processed, so re-syncing your data doesn’t create duplicate events. Choose a column with a unique text value per row. Don’t use a boolean or a value that repeats across rows.

Example Event Table Schema

SQL Query Mode

Write custom SQL queries to transform your event data:

Advanced Network Configuration

OneSignal can successfully connect to SingleStore instances that are using advanced networking controls including region constraints and IP address allow lists. For more information about configuring network access, contact your SingleStore administrator or OneSignal support.

Limitations

  • Real-time analytics queries may impact cluster performance during high-traffic periods
  • JSON operations should be optimized for distributed execution

FAQ

Can I connect to multiple SingleStore schemas?

Yes, you can grant the CENSUS user access to multiple schemas by running the GRANT SELECT statement for each schema containing event data.

Does OneSignal support SingleStore Cloud?

Yes, OneSignal supports both SingleStoreDB Cloud and on-premises SingleStoreDB v7.1+ installations.