Data Collage
Request access
Release notes

What's new in Data Collage.

Current version: 1.1.1. Data Collage checks for updates when it starts; you can also run Help → Check for updates at any time.

Version 1.1.1 Latest

August 2026

A small follow-up to 1.1.0 focused on updates: installs in Program Files can now update themselves, and IT teams get a switch to turn auto-update off.

Updates

  • If Data Collage was installed into Program Files (for example by running the installer as an administrator), it can now update itself. Previously these installs silently failed to update — you had to download and re-run the installer by hand.
  • When an update needs administrator rights, the update dialog shows a shield icon. Click it and Windows asks for permission once, the update installs, and the app reopens normally.
  • If an update fails because of a permissions problem, you get a Retry as Administrator button instead of a dead end.
  • Declining the Windows permission prompt no longer leaves the app in a strange state — you see a clear message and keep working.

For IT teams

  • New auto-update off switch for managed deployments. Set a single Windows registry value and Data Collage stops checking for updates — both the quiet check at startup and the manual Help → Check for updates. Users see a short “updates are managed by your organization” note instead. Details are in the Install & Launch guide.

Housekeeping

  • Version moved from 1.1.0 to 1.1.1 rather than re-issuing 1.1.0, so that every installed copy picks up the fix through the normal update path.

Version 1.1.0

August 2026

The first feature release after launch: smarter query tools, analyses that remember more of your setup, better dates and numbers, and a big round of polish.

New features

  • Generate SELECT from visible columns — one click in the results toolbar turns a SELECT * into an explicit column list that matches exactly what you see in the grid.
  • Validate SQL — check that a query parses correctly on the server without actually running it. Validation runs don’t appear in your history.
  • “Filter as” per column — when the grid guesses a column’s type wrong, force its filter to text, number, or date straight from the column header.
  • Analyses remember your grid filters and sorts — open a saved analysis and the grid comes back filtered and sorted the way you left it.
  • Analyses remember Top N and Duplicates — those settings are saved with the analysis and restored on open.
  • :xdo_user_name support — queries can now use the same data-security scoping (business unit, inventory org, ledger) that BI Publisher reports get, resolved on the server for the signed-in user.

Fixes

  • Date columns no longer shift by a day depending on your timezone; the “Clear” format shows the raw value as-is.
  • Top N now ranks numbers as numbers (not text), and only considers rows that pass your active filters.
  • Renaming an analysis keeps its saved filters and sorts.
  • Hidden columns stay hidden when you re-run an analysis.
  • Empty dates from BI Publisher now display as blank and are picked up by Hide Empty Columns.
  • Excel export keeps very long numeric IDs (16+ digits) intact instead of rounding them.
  • Toast notifications dismiss on time, and close immediately when you click their action.
  • The grid scrolls back to the first column whenever a new result set arrives.
  • Running a selection that contains more than one statement is now blocked with a clear explanation instead of a confusing error.

Error handling

  • Oracle errors such as ORA-00904 now highlight the offending name directly in the editor, and gateway noise is stripped from the message so you see only what matters.

UI polish

  • Grid right-click menus reorganized with section headers and submenus.
  • Per-column filter clear, and a filter popup that matches the app theme.
  • Instant, themed tooltips throughout.
  • Analyses panel: icon-only actions, right-aligned, with a themed delete confirmation.
  • Query Library and Query History drawers close after you pick something; new Open icon.
  • Results toolbar decluttered — the duplicate row count, timing, and connection labels are gone from the toolbar.
  • Connection project groups start collapsed.
  • Help → Documentation now opens this docs site.

What's coming Roadmap

Not a promise of dates — but this is what we're working on next, roughly in order.

AI Assist

Describe what you need in plain English and get a starting query — grounded in the bundled Fusion metadata so it knows your tables. Opt-in, and never sends your result data anywhere.

macOS build

A native Mac version is in active testing. Email us if you’d like to know the moment it ships.

Richer formula columns

Text operations, date arithmetic, comparisons, and IF / CASE-style conditionals in formula columns — today they are numeric only.

More starter queries and metadata

The Query Library and bundled table descriptions grow with every release. Send us the queries you reach for most.

Have something you'd like to see sooner? Write to datacollage@newarcinc.com.