Every object and field
Reads every standard NetSuite OpenAir object across projects, time, billing, and resourcing, plus any custom field you have added.
NetSuite OpenAir
Polytomic syncs data out of NetSuite OpenAir into your data warehouse, databases, and other systems with reliable ETL. Pull projects, time entries, invoices, and resource records out of NetSuite OpenAir and into the systems your team already runs on, without writing code.
Sync only what changed
Every object syncs incrementally on an updated-time filter, so each run only pulls what changed since the last sync.
API budget respected
Set the daily and per-minute request limits for your account and Polytomic paces its calls to stay under them.
Example workflows
Sync project financials into your data warehouse for margin reporting
What you can sync
Sync data out of NetSuite OpenAir into your data warehouse, databases, and other systems with full control over object and field mapping.
From NetSuite OpenAir
Projects, phases, milestones, and tasks
Time entries, expense reports, and receipts
Customers, contacts, and users
Invoices, customer POs, and billing rules
Resource bookings, requests, and utilization targets
Custom fields on every synced object
How it works
Connect NetSuite OpenAir with an API client from your account, then choose which objects and fields to sync into your data warehouse, databases, or other systems. Polytomic handles the extract and load, with no pipelines to maintain.
Almost every object syncs incrementally on its updated timestamp, and custom fields you have added in NetSuite OpenAir are discovered automatically alongside the standard fields. Retries and API throttling are handled for you, paced to the daily and per-minute limits you set.
- Connect with a NetSuite OpenAir API client and OAuth
- Custom fields discovered automatically alongside every standard field
- Sync incrementally using each object's updated timestamp on every run
- Respect the daily and per-minute API limits you set
- Handle retries and rate limiting automatically during every sync
- Monitor sync health and execution from one interface
How to set up
NetSuite OpenAir authenticates with an API client you create in your account, combined with an OAuth authorization in Polytomic. You will need a company ID, client ID and secret, API namespace, and API key, plus the request limits you want Polytomic to stay under.
How to get connected
- 1In NetSuite OpenAir, create an API client and note its company ID, client ID and secret, API namespace, and API key
- 2In Polytomic, go to Connections, click Add connection, select NetSuite OpenAir, and enter those values along with your daily and per-minute rate limits
- 3Click Connect to NetSuite OpenAir, complete the OAuth flow, and click Save
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with NetSuite OpenAir in minutes
No credit card required. Free trial available.