Data Sources

Data sources are central to defining user cohorts for targeted notifications in Siren. They allow you to manage and organize user data effectively, ensuring precise targeting for your campaigns.

Accessing Data Sources

  1. In the left navigation panel, click on Settings
  2. Select Data Sources from the dropdown menu

Data Source Tabs

The Data Sources page contains two main tabs:
  • Database: For connecting to your databases
  • Integrations: For connecting to external platforms like Mixpanel

Managing Database Connections

Adding a New Database

1

In the Database tab, click Add Database
2

In the modal that appears, fill in the following details:
  • Select Database Type: Choose from the dropdown
    • PostgreSQL
    • Redshift
    • BigQuery
    • Snowflake
    • MySQL
  • Name: Give your data source a descriptive name
  • Host: Enter the database host address (e.g., localhost or 127.0.0.1)
  • Port: Enter the database port number (e.g., 5432 for PostgreSQL)
  • Username: Database username
  • Password: Database password
  • Database Name: Name of the specific database to connect to
3

Click Save to create the connection

Managing Existing Databases

In the Database tab, you can:
  • View all configured database connections.
  • Click Edit from three dots (⋮) to modify connection details.
  • Click Delete from three dots (⋮) to remove a database connection.

Managing Integrations

Adding Mixpanel Integration

1

Go to the Integrations tab and click Add Integration
2

In the modal that appears:
  • Select Integration: Choose “Mixpanel” from the dropdown
  • Name: Give your integration a descriptive name
  • Project ID: Enter your Mixpanel Project ID
  • Username: Enter your Mixpanel service account username
  • Secret: Enter your Mixpanel service account secret key
3

Click Save to complete the setup

Managing Existing Integrations

In the Integrations tab, you can:
  • View all configured integrations.
  • Click Edit from three dots (⋮) to modify integration settings.
  • Click Delete from three dots (⋮) to remove an integration.