Welcome

Welcome to Data Collage — a Data workbench for Oracle Fusion SaaS. We’re glad you’re here.

What is Data Collage?

Data Collage is a desktop application that lets you write SELECT queries, run them against your Oracle Fusion instance, work with the results in a fast spreadsheet-style grid, and export the data to CSV, HDL, Excel, or JSON. It’s built for the day-to-day reality of Fusion reporting work: many small ad-hoc questions, a handful of saved analyses you re-run regularly, and the occasional larger extract for a downstream system.

Who is it for?

Data Collage is built for the people who already work with Fusion data day to day:

• Fusion consultants running ad-hoc queries during implementations and support
• Functional analysts validating data, troubleshooting issues, or pulling extracts for users
• BI Publisher report developers prototyping SQL before wrapping it in a report
• Anyone else comfortable enough with SQL to read Fusion’s data dictionary

You don’t need to be a SQL expert — but you should be comfortable writing SELECT statements and joining a few tables.

Why we built it

Running an ad-hoc query against Fusion today usually means logging into BI Publisher, fighting with a browser-based editor that wasn’t designed for serious SQL work, waiting for results in a paginated HTML view with no grid features, and having no good way to save your work or share it with a colleague.

Data Collage is the tool we wanted ourselves. A real desktop editor with syntax highlighting, autocomplete, and formatting. A real results grid with filtering, sorting, duplicate detection, and column-level formatting. Bind variables that actually work. Saved analyses that include the SQL and the layout and the formula columns and the formats — so you can pick up exactly where you left off, or hand the whole package to a colleague.

A note from the Newarc team

Data Collage is built by Newarc Consulting — a small, passionate team that specializes in Fusion Reporting. We’ve spent years living the pain points this app addresses, and we’re building it for ourselves as much as for you. Small team, big care: every feature in here exists because someone on our team or one of our customers asked for it.

What Data Collage isn’t (yet)

A few honest limitations worth knowing upfront:

• It’s read-only by design. Data Collage refuses anything other than SELECT and WITH statements. You cannot INSERT, UPDATE, DELETE, or run DDL through this app — even if you tried, the validator would block it before the query ever left your machine. This is a deliberate safety guarantee, not an oversight.
• Windows only in V1. macOS and Linux builds are on the roadmap; for now, Data Collage runs on Windows 10/11.
• AI Features. We have not incuded any AI features in this realease. We have plans to add AI features as part a future release, including a mcp server.

About this guide and your feedback

This guide is organized in three parts:

• Part I — Getting Started is a linear walkthrough: install, prereqs, and a 5-minute tour that ends with you exporting your first result set.
• Part II — Feature Reference is for dipping in by topic once you’re up and running. Read it in order, skip around — both work.
• Part III — Help covers common pitfalls, keyboard shortcuts, and a glossary.

In a hurry? Jump straight to §4 — Your First Query. You can always come back for the rest.

You’re using Data Collage V1.0 — the first release. If something doesn’t work, feels awkward, or is missing entirely, please write to us at datacollage@newarcinc.com. We read every message, and a lot of what’s already in this app got built because someone like you sent us a note.

Welcome aboard.