Microsoft SQL Server

Export Xoxoday engagement data
into SQL Server for enterprise reporting

Land Empuls recognition, Plum reward, and Loyalife transaction data in SQL Server. Power BI dashboards and SSRS reports built directly on Xoxoday data.

Book a demo

Get a personalised walkthrough. We respond within one business day.

What you can do

Four things you can do once Xoxoday data is in SQL Server

SQL Server is your enterprise reporting foundation. Xoxoday adds the reward and engagement layer so Power BI and SSRS see the complete picture.

Xoxoday data in your SQL Server reporting environment

Empuls, Plum, and Loyalife data in SQL Server tables
Empuls recognition events, Plum reward sends and redemptions, and Loyalife point transactions land in SQL Server tables for use in your existing enterprise reporting stack.
No changes to your existing reporting infrastructure
Xoxoday data arrives in SQL Server tables. Your SSRS reports, Power BI models, and custom SQL queries work against the same reporting database they always have.

Join reward data with existing enterprise datasets

Overlay Xoxoday data with HR, payroll, and ERP data
Join Xoxoday tables with HR, payroll, and ERP data already in SQL Server. See recognition frequency alongside headcount, reward spend alongside payroll, and loyalty activity alongside customer revenue.
Standard T-SQL joins - no new query language
Analysts and report authors use the same T-SQL they already know. Xoxoday tables behave like any other SQL Server table - joinable, filterable, and indexable.

Power BI and SSRS dashboards on Xoxoday metrics

Add engagement KPIs to existing Power BI models
Point your existing Power BI datasets or DirectQuery models at Xoxoday tables in SQL Server. Add recognition frequency, reward redemption rates, and loyalty points to dashboards that already show HR and finance metrics.
SSRS reports on reward and recognition activity
SSRS report authors can add Xoxoday tables to existing enterprise reports. Reward program data appears alongside the payroll, headcount, and operational data already in the report.

Scheduled exports for always-fresh reporting

Daily, weekly, or on-demand sync cadence
Configure the sync frequency that fits your reporting cadence in your ETL tool. Daily batch loads for morning reports, weekly loads for board packs, or on-demand for ad-hoc analysis.
No manual exports from the rewards team
Once the pipeline is configured, Xoxoday data flows into SQL Server automatically. Report authors always query fresh data without waiting for a manual CSV export.

Use cases

Who runs it, and what for

Three ways analytics, people, and finance teams use Xoxoday data in SQL Server.

Data & Analytics

Enterprise reporting on reward and recognition metrics

Analytics teams add Xoxoday recognition and reward tables to existing SQL Server reporting databases. SSRS and Power BI reports gain engagement KPIs alongside the operational metrics already there.

People Analytics

Join HR data with recognition and reward activity

People analytics teams join Xoxoday Empuls tables with HRIS and payroll data in SQL Server. Analyse recognition frequency by department, cost center, and manager to identify high-engagement teams.

Finance

Power BI dashboards on reward program spend and ROI

Finance teams build Power BI dashboards on Xoxoday Plum reward spend data alongside revenue and headcount. Track cost per reward send, redemption rates, and total program cost in one report.

How it works

From Xoxoday API to SQL Server tables

Step 1

Configure Xoxoday API credentials

Generate an API key in the Xoxoday admin panel. This credential authorises the ETL tool or custom pipeline to pull data from Xoxoday.

Step 2

Set up SQL Server destination tables via ETL tool

Configure your ETL tool - Fivetran, Airbyte, SSIS, or a custom pipeline - to pull from the Xoxoday API and load into your SQL Server database. Define the destination schema and table structure.

Step 3

Schedule the sync

Set the load frequency in your ETL tool to match your reporting cadence - daily, weekly, or on-demand. SQL Server tables update automatically on the schedule.

Step 4

Run Power BI or SSRS reports against Xoxoday tables

Connect your Power BI dataset or SSRS report to the Xoxoday tables in SQL Server. Add engagement KPIs to existing dashboards and reports without changing your reporting infrastructure.

Setup

API integration. ETL tool or SSIS pipeline.

Pull from the Xoxoday API using Fivetran, Airbyte, or SSIS. Load into SQL Server on your reporting schedule. Power BI and SSRS connect directly after that.

Integration type

API / custom integration - requires an ETL tool (Fivetran, Airbyte, SSIS, or custom pipeline).

Authentication

Xoxoday API key + SQL Server credentials.

Data sync

Xoxoday → SQL Server, scheduled export.

Products

Available with Empuls, Plum, and Loyalife.

Common Questions

Frequently asked questions

Common questions from data engineering, people analytics, and finance teams evaluating the SQL Server integration.

Still have a question? Talk to us
Available tables include Empuls recognition events, Plum reward sends and redemption events, and Loyalife point transaction logs. Contact your Xoxoday account team for full schema documentation and field definitions.
Fivetran and Airbyte both support SQL Server as a destination and can pull from REST APIs like Xoxoday. Microsoft SSIS is also a common option for organisations already using the Microsoft data stack.
The refresh cadence is configured in your ETL pipeline. Common options are daily batch loads for morning reports and weekly loads for board packs. On-demand loads for ad-hoc analysis are also possible.
Yes. Once Xoxoday data is in SQL Server tables, you can use either Import or DirectQuery mode in Power BI. DirectQuery gives you near-real-time data at the cost of query performance; Import mode is faster for complex reports.
Yes. Xoxoday provides table schema documentation for all exported datasets. Contact your Xoxoday account team or implementation partner for the current schema reference.

See it in your own SQL Server setup

A 30-minute call. We'll walk through the API schema, the ETL options for the Microsoft stack, and how Power BI connects to Xoxoday data in SQL Server.

Book a demo