---
title: "Illumin"
slug: "illumin"
description: "Connect Illumin to Dataddo and sync its data to any dashboard, database, or data warehouse. No coding required."
updated: 2026-07-15T17:29:30Z
published: 2026-07-15T17:29:30Z
canonical: "docs.dataddo.com/illumin"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Illumin

The Illumin connector lets you extract data from Illumin into Dataddo and sync it to any dashboard, database, or data warehouse. It reads the Illumin revenue report, with dimensions, metrics, and time granularity you pick yourself.

Refer to our website for [the list of available metrics and attributes](https://dataddo.com/connector/illumin) you can extract from Illumin.

If you have multiple Illumin accounts and would like to extract the same data from all of them, it's possible through [multi-account extraction](/docs/multi-account-extraction). Contact our Solutions team to enable this feature.

## Authorize Connection to Illumin

Before you can create a data source, connect Dataddo to your Illumin account.

1. In Dataddo, go to **Authorizers** and click **Authorize New Service**.
2. Select **Illumin**.
3. Fill in the connection details:

| Field | Details |
| --- | --- |
| Username | The email address you use to sign in to Illumin. |
| Password | Your Illumin password. |

4. Click **Save**.

## Data Coverage

The connector offers one dataset, the **Revenue Report**. Its columns are not fixed. Dataddo loads the available dimension and metric columns live from your Illumin account, so the list always matches what your account offers.

You shape the report with these settings:

| Setting | Details |
| --- | --- |
| Dimensions | The attribute columns to include, loaded from your account. At least one dimension or metric is required. |
| Metrics | The numeric columns to include, loaded from your account. |
| Granularity | The time grain of the report: Overall, Hourly, Daily, Weekly, or Monthly. Default: Daily. |
| Group by dimensions | When on, results are aggregated by the selected dimensions. When off, raw-level data is returned, which can be very large. Default: on. |
| Date range | The reporting period. See below. |

| Dataset | Description | Example fields | Date range |
| --- | --- | --- | --- |
| Revenue Report | Illumin revenue report with configurable dimensions, metrics, and time granularity. | dynamic (from your account) | Yes |

## How Data Extraction Works

The Revenue Report uses a relative date range, for example "last 7 days". Every run re-reads that window against the current date, so the window slides forward over time. A run today with a "1 day ago" range pulls yesterday's data. The same source pulls the new yesterday tomorrow.

Each run replaces the window's data, it does not accumulate older history. To load data from before the window, run a full data re-sync with a wider range. See [Data Backfilling](/docs/data-backfilling).

## Metadata Columns

You can add optional Dataddo metadata columns to the report:

- `dataddo_hash` is a fingerprint of each record's key fields. It works as a natural key and is ideal for upserts.
- `dataddo_extraction_timestamp` is the time the record was extracted. Use it to track slowly changing dimensions.
- `dataddo_date_start` and `dataddo_date_stop` mark the start and end of the time period the run covered.

## How to Create an Illumin Data Source

1. In Dataddo, go to **Sources** and click **Create Source**.
2. Search for **Illumin** and select it.
3. Choose your Illumin authorizer.
4. Select the dimensions and metrics to include. Pick at least one column.
5. Choose the granularity and keep or turn off **Group by dimensions**.
6. Set the date range.
7. Click **Test Data** to preview the data.
8. Click **Save**.

## Troubleshooting

### No Data Preview

If **Test Data** shows no preview:

- Make sure at least one dimension or metric column is selected.
- Try a smaller or different date range. The selected period may have no data.
- Check that your Illumin username and password are still valid.

## Related Articles
Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage.

**Sending Data to Dashboarding Apps**
* [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards)
* [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps)

**Sending Data to Data Storages**
* [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
* [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)

**Other Resources**
* [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting)
* [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs)
* [Data Duplication](https://docs.dataddo.com/docs/data-duplication)