Question 1

Do financial amounts stay exact?

Accepted Answer

Yes, and it is the reason to care about type mapping on an ERP source. Where SuiteAnalytics reports a valid precision and scale, values become DECIMAL, and anything arriving without declared precision becomes DECIMAL(65,30). Ledger totals therefore reconcile rather than drifting the way repeated floating point addition does.

Question 2

Which of the two NetSuite connectors belongs here?

Accepted Answer

SuiteAnalytics, if you are licensed for the Connect module. It is purpose built as a source and exposes the broad analytical table catalogue, custom columns included. The regular NetSuite connector is the right choice when SuiteAnalytics is unavailable or when you need to write back into NetSuite, and its source catalogue is narrower and limited to four concurrent objects.

Question 3

What has to be in place in NetSuite first?

Accepted Answer

Quite a lot, and this is the longest setup of any source that lands in MySQL. The SuiteAnalytics Connect module, OAuth 2.0 enabled, a machine to machine integration carrying the SuiteAnalytics Connect scope, a web services role with that permission, a dedicated user assigned to the role, and an RSA certificate pair whose public half you upload to NetSuite. Polytomic then needs the account ID, role ID, client ID, certificate ID and private key. IP allowlisting may also be required.

Question 4

Which objects can resume from a checkpoint?

Accepted Answer

The first ETL run does. After that it works object by object: anything SuiteAnalytics exposes with both a last modified field and a unique identifier reads incrementally from a checkpoint, and anything without falls back to a full read every time. Transaction line and inventory assignment tables get their own parent based incremental handling.

Question 5

Do custom columns come across?

Accepted Answer

Yes, and without special handling. SuiteAnalytics presents them as ordinary columns, so they arrive carrying the datatype it reports rather than being bundled into a JSON blob for you to unpack later. That is the main practical reason to prefer this connector when the destination is a reporting database.

Sync NetSuite SuiteAnalytics to MySQL

Sync NetSuite SuiteAnalytics to MySQL with Polytomic

Ledger amounts stay exact

The analytical surface

Certificate based auth

Trusted by businesses worldwide

Step-by-step integration guide

Connect NetSuite SuiteAnalytics in Polytomic

Connect MySQL in Polytomic

Create a sync between NetSuite SuiteAnalytics and MySQL

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect NetSuite SuiteAnalytics with MySQL?