NetSuite
Connect NetSuite to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.
Connect NetSuite
- Open the catalogue. In the console, go to Data · Connections and press New connection.
- Choose NetSuite. It is listed under finance and payments; you can also search for it by name.
- Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
- Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
- Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.
Configuration fields
What the connection form asks for. Required fields are marked; the rest are optional.
| Field | Type | Required | Description |
|---|---|---|---|
| Realm (Account Id) | string, secret | Yes | Netsuite realm e.g. 2344535, as for production or 2344535_SB1, as for the sandbox. |
| Consumer Key | string, secret | Yes | Consumer key associated with your integration. |
| Consumer Secret | string, secret | Yes | Consumer secret associated with your integration. |
| Token Key (Token Id) | string, secret | Yes | Access token key. |
| Token Secret | string, secret | Yes | Access token secret. |
| Object Types | array | No | The API names of the Netsuite objects you want to sync. Setting this speeds up the connection setup process by limiting the number of schemas that need to be retrieved from Netsuite. |
| Start Date | string | Yes | Starting point for your data replication, in format of "YYYY-MM-DDTHH:mm:ssZ" |
| Window in Days | integer | No | The amount of days used to query the data with date chunks. Set smaller value, if you have lots of data. Default 30. |
Related
Something unclear or out of date? Tell us, and we will fix the page.