NetSuite Connector administration

• • If field names in the NetSuite record and the related NetSuite search record do not match, the fields cannot be used in filters. This must be configured before NetSuite objects can be used as sources in tasks.
You can associate NetSuite record field names with related NetSuite search record field names when you set up a NetSuite connection in Data Integration. Alternatively, you can configure the RecordToFieldsMap.ini file if the connection uses a Secure Agent group for the runtime environment.
• •Some custom fields in NetSuite custom objects might not appear in Data Integration, particularly transaction body fields and transaction column fields.
To ensure that all custom fields are available in Data Integration, you can configure custom fields when you set up a NetSuite connection in Data Integration. Alternatively, you can configure the NetSuiteCustomFields.ini file if the connection uses a Secure Agent group for the runtime environment.
• •Saved search fields in NetSuite do not appear in Data Integration if they have a null value.
You can specify saved search fields when you configure a NetSuite connection so that the saved search fields appear in Data Integration even when they have a null value. Alternatively, you can add the saved search fields to the NetSuiteSavedSearchFields.ini file if the connection uses a Secure Agent group for the runtime environment.
• •To optimize performance for concurrent threads in synchronization tasks, you might need to adjust heap size.

Mapping NetSuite record field names

• •Data Filters page of the Synchronization Task wizard
• •Query options in a Source transformation in the Mapping Designer
• •Query options in the Sources page of the Mapping Task wizard when the source object is parameterized

Creating a configuration file to map NetSuite fields

1Create a text file named RecordToFieldsMap.ini.
2Use the following guidelines to configure the RecordToFieldsMap.ini file:
• - Create a separate section for each NetSuite record.
• - In each section, list the record field names and related SearchBasic field names, as follows:
[<record 1>]
<record field name>=<SearchBasic field name>
<record field name2>=<SearchBasic field name2>

[<record 2>]
<record field name>=<SearchBasic field name>
<record field name2>=<SearchBasic field name2>
<record field name3>=<SearchBasic field name3>
For example:
[Account]
acctName=name
addr1=address1
• - To read transactional data from NetSuite when memorized transaction is enabled in the NetSuite account, add the record field names and related SearchBasic field name in the following format:
[<record 1>]
<record field name>=<SearchBasic field name>
For example:
If you want to enable memorized transaction for JournalEntry object, add the following value in the RecordToFieldsMap.ini file:
[JournalEntry]
reversalEntry=memorized
3Copy the RecordToFieldsMap.ini file to the following directory:
<Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\reserved\userfiles\netsuite
4Update the file as required.

Configuring the NetSuiteCustomFields.ini file

1Make a copy of the NetSuiteCustomFields.ini file, located in the following directory:
<Secure Agent installation directory>\downloads\packageNetsuiteConnector.<version>\package\rdtm\javalib
2Use the following guidelines to change the file to include custom NetSuite fields:
• - Create a separate section for each NetSuite record for which you want to add custom fields.
• - Add the custom fields using the following format, where the value of scriptId is the ID field in the NetSuite user interface for each custom field:
[<Object Name>]
scriptIds = <custom field name1>,<custom field name2>,<custom field name3>
For example:
[Sales]
scriptIds = discountPrice,salesDescription,salesEvent

• - Add the custom fields for NetSuite advanced search using the following format, where the value of scriptId is the ID field in the NetSuite user interface for each custom field:
[<Object Name>]
scriptIds = <custom field name1>,<custom field name2>,<custom field name3>
For example:
[EmployeeSearchAdvanced]
scriptIds = custentity74,custentity66

• - If you want to read or write custom segment data, use the following format to add the custom segment fields:
[<Object Name>]
custSegScriptIds=custseg1:select,custseg2:multiselect,custseg3:select....
where the value of scriptId is the ID field in the NetSuite user interface for each custom segment field.
For example:
[Employee]
custSegScriptIds=custbody18:select,custbody19:multiselect,custbody20:select....
If you want to read data from or write data to child record custom segments, use the following format to add the child custom segment fields:
[<Object Name>]
custSegScriptIds=custseg1:select,custseg2:multiselect,custseg3:select....
For example:
▪ [JournalEntry] custSegScriptIds=custbody_cseg1:select,custbody_cseg2:select,custbody_cseg3:select
▪ [JournalEntryLineList] custSegScriptIds=custcol_cseg1:select,custcol_cseg2:select,custcol_cseg3:select
3Save the NetSuiteCustomFields.ini in the following location:
<Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\reserved\userfiles\netsuite
Note: The custom segment fields, which you add either in NetSuiteCustomFields.ini or connection properties, are not validated. For example, the metadata and duplicate field names.

Configuring the NetSuiteSavedSearchFields.ini file

1Make a copy of the NetSuiteSavedSearchFields.ini file, located in the following directory:
<Secure Agent installation directory>\downloads\packageNetsuiteConnector.<version>\package\rdtm\javalib
2Use the following guidelines to change the file to include all of the saved search fields:
• - Create a separate section for each NetSuite saved search record for which you want to add a saved search field, identified by a unique scriptId.
• - Add the search fields using the following format:
[SavedSearchScriptIdToFieldsMap<version>]
<savedSearchId1>=<savedSearchDeclaredField1Name>,<savedSearchDeclaredField2Name>,
<savedSearchCustomFieldScriptId1>,<savedSearchCustomFieldScriptId2>,<StandardJoin>|<FieldName1>,
customSearchJoin|<scriptID1>

The savedSearchId1 is ID field in the NetSuite user interface that specify the saved search record. The savedSearchDeclaredField1Name and savedSearchDeclaredField2Name are standard field names in the NetSuite user interface. The savedSearchCustomFieldScriptId1 and savedSearchCustomFieldScriptId2 are ID fields in the NetSuite user interface for custom fields. The StandardJoin|FieldName1 is the standard join field and customSearchJoin|scriptID1 is the custom join field.
For example:
[SavedSearchScriptIdToFieldsMap1]
1000=phone,email,custentity78,custentity65,userJoin|email,customSearchJoin|custrecord1424

In the example, 1000 is the saved Search ID, phone and email are standard field names, custentity78 and custentity65 are the script IDs of a custom field. userJoin|email is the standard join field and customSearchJoin|custrecord1424 is the custom join field script ID.
Note: When you use custom join, script ID appears in the Data Integration user interface.
• - If you want to read custom segment data, use the following format to add the search custom segment fields:
[SavedSearchScriptIdToCustSegFieldsMap]
savedSearchId1 = custseg1:select,custseg2:multiselect,custseg3:select....
where custom segment field scriptId is appended to field type (select or multiselect) with ":" delimiter.
For example:
[SavedSearchScriptIdToCustSegFieldsMap]
741=custseg1:select,custentity_cseg1:select,custentity_csegcs_multsel:multiselect
3Save the NetSuiteSavedSearchFields.ini in the following location:
<Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\reserved\userfiles\netsuite

Fetching field name for saved search with standard join

1Go to https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2015_1/script/record/transaction.html.
2Under Schema Browser, select the object.
3Under Related Searches, select the search object.
4Under Fields, select the type for the standard join.
You will find the name of the standard join field.
The syntax for saved search INI file with standard join is as follows,
[SavedSearchScriptIdToFieldsMap]<savedSearchId1>= <StandardJoin>|<FieldName1>, <StandardJoin>|<FieldName2>
For example,
[SavedSearchScriptIdToFieldsMap1]
290= userjoin|accountNumber, contactJoin|address

Fetching script ID for saved search with custom join

1 Log in to your NetSuite account.
2Select Customization > Record Types.
3Select the custom object to get the script ID for the custom join field.
The syntax for saved search INI file with custom join is as follows:
[SavedSearchScriptIdToFieldsMap]<savedSearchId1>= customSearchJoin|<scriptID1>,customSearchJoin|<scriptID2>
For example,
[SavedSearchScriptIdToFieldsMap1]
290= customSearchJoin|custrecord1423,customSearchJoin|custrecord1421

Reading custom record standard fields with custom join

1Go to Administrator > Runtime Environments.
The Runtime Environments page appears.
2Select the Secure Agent for which you want to set the custom configuration flag.
3Click Edit Secure Agent in Actions.
The Edit Secure Agent page appears.
4Select the Service as Data Integration Server in the Custom Configuration Details section.
5Select the Type as Tomcat in the Custom Configuration Details section.
6Add DumpSavedSearchMetadata in the Name field.
7Specify a file path in the Value field where you want to generate the DumpSavedSearchMetadata file.
For example, C:\\Dump.txt. The path should contain "\\".
The following image shows the Custom Configuration Details section.

Note: If the path contains only the file name, then the Secure Agent generates the DumpSavedSearchMetadata file in the following folder: <Secure Agent installation directory>\apps\Data_Integration_Server\<DIS Version>\ICS\main\tomcat. If the path is not valid, the Secure Agent does not generate the DumpSavedSearchMetadata file.
8Click OK.
9Create a task with saved search object to read custom record standard fields with custom join.
When you save or run the task, the Secure Agent generates the DumpSavedSearchMetadata file and writes the metadata to this file. The Secure Agent fetches the metadata for the custom record standard fields in the following format:
<script Id of custom record>__<standard search column name1>__CSJ,
<script Id of custom record>__<standard search column name2>__CSJ
For example:
custbody_cseg1__internalId__CSJ,custbody_cseg1__name__CSJ
Note: When you specify a field name, ensure that the length of the field name does not exceed 64 characters.
If you want to override the metadata, you can copy the metadata in the NetSuiteSavedSearchFields.ini file and modify the metadata accordingly. Use the following format to add the search custom record standard fields in the NetSuiteSavedSearchFields.ini file:
[SavedSearchScriptIdToFieldsMap<version>]
<savedSearchId1>=CustomSearchJoin|<scriptId of custom record>__<standard field name>
For example:
[SavedSearchScriptIdToFieldsMap1]
356=CustomSearchJoin|uss_custom_code__internalId
Alternatively, you can specify saved search fields in the Saved Search Record Fields connection property when you configure a NetSuite connection.

Internalid and externalid in saved search

Increasing heap size for concurrency in synchronization tasks

Increasing heap size in the Edit Secure Agent page

1Click Administrator > Runtime Environments.
2On the Runtime Environments page, if necessary, expand the Secure Agent groups to see the list of Secure Agents. Click the Secure Agent name from the list.
3Click Edit Secure Agent in Actions.
The Edit Secure Agent page appears.
4In the System Configuration Details section, for Type, select DTM. Modify the JVMOption parameter to specify the heap size.
For example, you might want to adjust the heap size to 512 MB if the concurrency thread setting is 10.
The following example shows the heap size set to 512 MB:
JVMOption6=-Xmx512m
JVMOption5=-XX:+HeapDumpOnOutOfMemoryError
JVMOption4=-Xloggc:jvm_heap_stats_Clou_App.log
JVMOption3=-XX:+PrintGCDetails
JVMOption2=-XX:+PrintGCTimeStamps
JVMOption1=-verbose:gc

Handling parent and child or sibling objects with similar column name

1Go to Administrator > Runtime Environments.
2On the Runtime Environments page, if necessary, expand the Secure Agent groups to see the list of Secure Agents. Click the Secure Agent name from the list.
3Click Edit Secure Agent in Actions.
The Edit Secure Agent page appears.
4In the Custom Configuration Details section, for Type, select DTM.
5Set the UseJumbledDataForFieldsWithSameName parameter to true or false as shown in the following image:

6Restart the Secure Agent.