Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Add date modified to native NetSuite fields for ODBC export to FiveTran
Our company is using a data extraction tool/provider called FiveTran and it appears they way FiveTran bills is based off of "MAR's" (Monthly Active Records) and have consistently seen 33% of our usage occur during the last day of the month. Per FiveTran, this is due to the following two NetSuite tables do not have a date column. This data column is needed for a delta load, as without it, the full table is load every month to ensure completeness.
bomrevisioncomponentmember
itemgroupmember
Here is the feedback from FiveTran (the data extraction tool/companay)
We have investigated the issue and found that these tables from NetSuite do not include any date column. Consequently, it is not possible to load these tables incrementally. We classify such tables as "reimport tables," meaning that every time(In every sync job), we need to reimport all the records in the table to ensure data consistency, unlike other tables. Without a date column, there is no way to extract data from the point where the previous import ended. Therefore, we charge for the full set of records in the table once a month, irrespective of importing these tables in every