//Info: NTPL- 445
We can preview NetSuite data and transfer it to a third-party database using the ODBC Driver.
We need to verify some cases before proceeding with this process.
1. We’re assuming you planned on collecting the posting transactions. Do you intend to retrieve any additional types? (These types of records are typically accessible as Tables.)
2. Clarify whether You simply want to download the information for a finite period. If so, what format would you prefer, such as a CSV file?
3. Do you intend to migrate these data to the third-party database rather than downloading them, and if so, which platform will you use?
4. In the case of a migration, we may need a license or access to the system, which may add time to the mapping process. Also, please confirm whether this transfer is one-time only or will need to be repeated on a regular basis, and make any necessary updates based on the changes in the NetSuite.
Note:
We used Microsoft Visual Studio Community as an intermediary to set the source as NetSuite and the destination as Asure SQL server ( Database).
This is a one-time process, and no data in the database will be changed, even if Netsuite Records are updated.
We should investigate an alternative method for the continuous update process.