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

  • 2 minute(s) read
Prev Next

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 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. 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.
  1. 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.

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

Sending Data to Data Storages

Other Resources