Connect securely
Basic auth or Fusion SSO with JWT. Credentials live in the Windows credential vault — never in plaintext, never in SQLite.
Data Collage gives Fusion admins, consultants, and analysts a real desktop SQL experience — without exposing the database. Connect once, write read-only SQL with full Monaco tooling, and ship the answer.
Fusion SaaS doesn't expose direct database connectivity, so analysts end up running BI Publisher reports by hand. Data Collage replaces that loop with a real workbench — same boundary, dramatically better ergonomics.
Basic auth or Fusion SSO with JWT. Credentials live in the Windows credential vault — never in plaintext, never in SQLite.
Monaco-powered editor with syntax highlighting, snippets, a curated Oracle function catalog, bind parameters, find & replace, and one-key formatting.
Every query is parsed and validated before leaving your machine.
Only SELECT / WITH statements run — DML
and DDL are rejected at the boundary.
Fast AG Grid view of every result set. Sort, filter, hide, format columns (incl. multi-currency), add formula columns that reference each other, copy any column as an IN clause, and export to CSV or XLSX without ever leaving the app.
Right-click a cell → pick the entity (AP invoice, GL journal, PO, project, and more) → drill straight into the record in your browser. Linkify a column once and every row in it becomes clickable.
Save SQL + formulas + formats + binds as a single portable
.dcanalysis file. Every run is logged to local history,
and your snippets follow the install.
Pin the presentation to the query itself with
--@title, --@hide, --@show,
--@column_order, and --@format. Oracle sees
plain comments; Data Collage sees the recipe. They version-control
and share like any other SQL.
Generate SQL from natural language using a metadata-grounded model. Bring your own OpenAI / Anthropic / Gemini key, or run locally with Ollama.
Data Collage ships its own read-only BI Publisher data model into your Fusion environment on first connect, then routes queries through it as gzipped SOAP payloads. Your DBAs see normal BIP traffic. You see a workbench.
/~username/NCDataCanvas/. No
DBA tickets, no infrastructure.
.dcanalysis filesv1 is in early access for testing teams. Tell us about your Fusion environment and we'll get you set up.