NetSuite Data Services

NetSuite Archiving & Historical Data Preservation

Extract every table from NetSuite, preserve the full File Cabinet, and hand off a permanent, queryable archive — with Power BI views on top of the key financial areas.

Get a Scoping Call Book a Consultation

Why Archiving Isn't a One-Click Export

Three structural constraints force a multi-track approach. Miss any of them and the archive fails silently.

Volume & Throughput

Years of transactions, custom records, and segments can't be pulled in a single query. Session timeouts, row limits, and table-level permissions all gate a clean full extract.

File Cabinet Fragility

Native File Cabinet exports fail on folders over ~4 GB, and debugging which file broke the download is painful. A bundle-script strategy is required to preserve folder hierarchy at scale.

Lost Relationships

A flat dump of CSVs is useless without the joins. Transactions must stay linked to entities, files to transactions, and segments must remain queryable long after NetSuite is gone.

Two Parallel Tracks, One Reconciled Archive

We split structured data and binary files into independent pipelines so neither blocks the other — then reconnect them at the warehouse.

Track A

Structured Data

ODBC (preferred) or SuiteQL-over-REST pulls every table: transactions, lines, accounting lines, entities, items, custom records, segments — in batched, auditable runs.

Track B

File Cabinet

SuiteScript bundle strategy exports files in controlled chunks, preserving the original folder tree and avoiding the >4 GB failure mode.

Reconciliation

BI Layer

SQL views and Power BI models rejoin files to transactions — so years from now, anyone can drill from an invoice straight to its attached PDF.

NetSuite Source          ──┬──  ODBC Extract (all tables)     ──┐
   (legacy)                │                                     │
                           └──  SuiteScript Bundle Extract   ──┤
                                                                │
                                    Staging (CSV / Binary)  ────┤
                                                                │
                              Target Warehouse + File Store  ───┤
                                                                │
                                Power BI Views & Handoff    ────┘

Same Foundation. Different Finish.

Every tier archives 100% of NetSuite tables and 100% of the File Cabinet. Tier selection determines how much reconciliation, linking, and reporting sits on top.

TIER 1 · LEAN

Essential

$28,125

$125/hr·225 hrs·4–5 weeks

All core tables + custom records
Full File Cabinet with folder hierarchy
Row-count reconciliation
Runbook & field mapping docs

Best fit: Small to mid-size instances, limited history, reference use only.

Recommended

TIER 2 · BALANCED

Full Archive

$35,000

$125/hr·280 hrs·6 weeks

Everything in Essential, plus:
File ⇄ Transaction linking views
Power BI starter views (AR/AP/GL)
Full checksum reconciliation

Best fit: Mid-size instances, 3–5 yrs history, drill-through reporting needs.

TIER 3 · COMPREHENSIVE

Archive + Reporting

$62,500

$125/hr·500 hrs·9–10 weeks

Everything in Full Archive, plus:
Full Power BI suite (P&L, BS, CF, TB)
Multi-subsidiary & multi-currency
FX conversion + row-level security

Best fit: Large / multi-entity instances, 5+ yrs, permanent BI platform.

Out-of-scope work billed at $145/hr (T&M). Approved in writing before hours are consumed.

Six Tracks. Clear Owners. Defined Hours.

WS 0120–35 hrs

Discovery & Access

·Inventory tables, record types, custom segments
·Measure File Cabinet size & folder depth
·Configure ODBC credentials & view-only role
·Confirm target environment with client

WS 0280–140 hrs

Structured Data Extraction

·All transactions, lines, accounting lines
·Masters: customers, vendors, items, COA
·Custom records, segments, classifications
·Batch, retry, log, checksum

WS 0350–90 hrs

File Cabinet Migration

·SuiteScript bundle for folder-preserving export
·Handle large folders & deep nesting
·Capture metadata (folder, owner, created, size)
·Land in Azure Blob / SharePoint / OneDrive

WS 0430–60 hrs

Target Warehouse & Schema

·Provision target DB (client-chosen platform)
·Staging / raw / curated schema layers
·Load scripts with type mapping
·ERD documentation for long-term ownership

WS 050–45 hrs

File ⇄ Transaction Linking

·Map internalId / file metadata to transactions
·Build SQL views with hyperlink-ready URLs
·Reconcile coverage and report gaps
·Enable Power BI drill-through to documents

WS 0625–90 hrs

Power BI, Docs & Handoff

·Power BI views / full reporting suite
·Reconciliation reports (counts & checksums)
·Runbook: re-run, re-extract, audit procedures
·Knowledge-transfer sessions

A Six-Week Sprint, Parallelized

Shown for the recommended Full Archive tier. Timeline shortens for Essential, extends for Enterprise.

Week 1

Kickoff · Discovery · Access

ODBC credentials, view-only role, table inventory, File Cabinet size assessment, target environment decision locked in.

Week 2

Extraction Scripts + Warehouse Provisioning

Build and test ODBC scripts against sample tables. Provision target warehouse. Launch SuiteScript bundles for File Cabinet.

Weeks 3–4

Full Extraction (Parallel Tracks)

Full table extraction batch-by-batch via ODBC. File Cabinet bundle runs. Daily reconciliation on row counts and file counts.

Week 5

Load · Link · Validate

Load into target schema. Build file-to-transaction mapping views. Run reconciliation reports. Fix any gaps surfaced during validation.

Week 6

Power BI Views · Handoff · Documentation

Power BI starter views (AR / AP / GL). Runbook, ERD, two knowledge-transfer sessions with client IT / BI team.

Eleven Concrete Deliverables

Every artifact is designed to be re-runnable, audit-ready, and owned by your internal team after handoff.

ODBC extraction scripts (Python, modular)

code

Full table CSV extracts (every NetSuite table)

data

File Cabinet archive with folder tree

files

Target DB schema: staging & curated layers

NetSuite → SQL field mapping documentation

doc

File ⇄ Transaction lookup views

sql

Reconciliation reports (counts, checksums)

ERD & architecture diagram

doc

Power BI starter views (AR / AP / GL)

Operational runbook & troubleshooting guide

doc

Two knowledge-transfer sessions + recordings

handoff

Ready to Preserve Your NetSuite Data?

Pick a tier, confirm access, and we start Week 1 with ODBC credentials, target-environment decision, and File Cabinet size assessment — then full extraction launches Week 2.

Package rate: $125/hr · T&M: $145/hr

Get a Scoping Call Book a Consultation