# NetSuite
## **Prerequisites**
* A NetSuite administrative account
* The [SuiteAnalytics Connect Service](https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSALC/NSALC.pdf) enabled
* A NetSuite login email
* A NetSuite password
* A list of permissions required for the NetSuite tables you want to sync
## **Setup Instructions**
### **Task 1: Create a Role**
1. On the menu bar at the top of your NetSuite dashboard, select **Setup** -> **Users/Roles** -> **Manage Roles** -> **New** to create a new role for Daton.
2\. Enter a memorable name in the **Name** input field for the role. (We recommend "Daton.")
### Task 2: Set system-wide permissions for the role
1. In your NetSuite dashboard, after you have named the role, scroll down to the bottom of the page to set permissions for the role. You must first set system-wide permissions.
2. Select **Permissions** -> **Setup** near the bottom of the page and expand the drop-down menu to set system-wide permissions.
3\. To add the required system-level permissions, select each of the following permissions from the drop-down menu and click Add:
a. Custom Body Fields\
b. Custom Column Fields\
c. Custom Entity Fields\
d. Custom Event Fields\
e. Custom Item Fields\
f. Custom Record Types\
g. Deleted Records\
h. SOAP Web Services\
i. SuiteAnalytics Connect
### Task 3: Set table permissions
1. 1\. In your NetSuite dashboard, select Setup -> Users/Roles -> Manage Roles, and then click Edit beside the relevant role's name on the Manage Roles page displayed.
2\. Select the permissions for the tables you wish to add. You will find these permissions under either the **Transactions**, **Lists**, **Setup** or **Custom Record** subcategories, depending on the types of tables.
3\. Select the required permissions and click **Add**. By default, table permissions should have the **View** permission level, that is, be read-only.
4\. After you have added the permissions, click Save.
### Task 4: Get the Role ID
*NOTE: The **Internal ID** column may be not displayed in the role list table. In this case, you need to customize the table view by clicking **Edit View** and adding the **Internal ID** field to the displayed field set*
### Task 5: Connect the role to the user
1\. Decide which NetSuite user you want to connect to Daton. It is best to create a dedicated user for the Daton role because only one connection at a time is allowed by a given user. A connection conflict will cause your Daton sync to fail.
2\. On the menu bar at the top of the NetSuite dashboard, select **Setup** -> **Users/Roles** -> **Manage Users**.
3\. Select the user you would like Daton to use.
4\. Click Edit
5\. Scroll-down slightly and select the **Access** tab.
6\. Make sure the **Give Access** box is checked.
7\. Expand the **Role** drop-down list on the **Roles** tab and select the **Daton** role. Then click **Add** and **Save**.
### Task 6: Find your service host, port, and account ID
1. From the homepage of your NetSuite account, find the **Settings** module and select **Set Up SuiteAnalytics Connect**.
2.
2\. Click on **Your Configuration**, and your service host, port and account ID information will appear.
3\. Make a note of your host, port, and account ID. You will need them to configure Daton.
### Task 7: Create Other Authentication Credentials
1. [Client Credentials (Consumer Key and Consumer Secret)](#client-credentials)
2. [User Access Tokens](#user-access-tokens)
#### Client Credentials
1. In NetSuite, navigate to **Setup** and click **Integration**. Now under **Manage Integrations**, click **New**. (*Setup > Integration > Manage Integrations > New)*
2. On the Integration page, perform the following:
1. Enter a Name for the integration record.
2. On the **Authentication** tab:
* Enable Token-Based Authentication by checking the corresponding box.
* Enable TBA: Authorization Flow by checking its box.
3. Setup the rest as per requirements.
3. Click **Save** to complete the setup.\
On the **Confirmation Page**, you will find the Client Credentials, including the **Consumer Key** and **Consumer Secret**.
Please note that the system displays the client ID and client secret only the first time you save the integration record. Ensure that you securely record and store these values as you will need them for subsequent steps in the integration process to maintain the security and functionality of your Daton integration with NetSuite.
#### User Access Tokens
1. Log in with a role that has the User Access Token permission.
2. Navigate to **Settings**, locate, and click **Manage Access Tokens**.
3. The My Access Tokens page will appear, where all the tokens associated with the current user and role are listed.
4. Click on **New My Access Token** to create a new token.
5. The **Access Token** page will appear. On the Access Token page, perform the following and click **Save**.
* Choose the desired **Application Name**.
* By default, the **Token Name** is auto-populated with a combination of the Application Name, User, and Role. Optionally, you can provide a custom name for this token.
Please note that the "Token ID" and "Token Secret" values are only visible on this confirmation page. Once you navigate away from this page, you will not be able to retrieve these credentials from the system. If you lose or forget these credentials, you will need to create a new token to obtain new values.
### Task 8: Finish Daton configuration
1. [Log in](https://daton.sarasanalytics.com/login) to your existing Daton account and search for NetSuite in the list of Connectors, then click **Configure**.
2. Enter the following details and click **Authenticate**:
* Integration Name
* Replication Frequency
* Replication Start Date
**Note** that the Integration Name will be used to create the integration tables and cannot be modified later.
3. Provide the following Authentication credentials and click **Next**.
* Service Host
* Service Port
* Service Datasource Name
* Account ID
* Role ID
* Email
* Password\
To know where to find these details, see [Find your service host, port, and account ID](#task-6-find-your-service-host-port-and-account-id).
Optionally, you can click on the Token from the Authentication Type dropdown to enable Token-based Authentication. In that case, provide the following additional details:
* Client ID
* Client Secret
* Token ID
* Token Secret\
To know where to find these details, see [Create Other Authentication Credentials](#task-7-create-other-authentication-credentials).
4. Post Database Authentication, you will be prompted to choose schemas from the list. **Select** the desired Schemas and click **Next.**
5. **Select** all the Tables as per requirement and **Configure** the schema that you wish to create in the destination before clicking the **Next** button.
Note:
* You will have to check at least one Table from each of the previously selected Schemas to proceed further.
* You can also customize the replication frequency and replication start date of each desired table separately. You may find this functionality under the advanced settings of every selected table.
6. Select all the Columns you require for each table and **Submit** the integration.
It's recommended to select a replication field for each of the tables. Selecting **'None'** will lead to full table replication. Learn more about [Replication Fields](https://daton-sarasanalytics.gitbook.io/daton/platform/features/data/data-replication-in-daton/replication-fields) here.
**Note** that you will be prompted to select the destination for your Database.
7. Select the destination for your source and click **Confirm**. An integration successful message will be displayed.
## Important Note
* Integrations would begin in the Pending state and change to the Active state once the first job successfully loaded data into the configured warehouse.
* Users can check job status and process logs from the integration details page by clicking on the integration name in the active list.
* Users can Re-Authenticate, Edit, Clone, Pause, or Delete the integration at any moment by clicking on settings. You can also adjust the frequency and history of the integration.
* On the Sources page, click Integration to access each table in your integration. The page also shows the state of each table, the last replicated time, and the Reload access buttons.
