Table of Contents

Search

  1. Preface
  2. Introduction to NetSuite Connector
  3. Connections for NetSuite
  4. Synchronization tasks with NetSuite
  5. Mappings and mapping tasks with NetSuite
  6. Appendix A: NetSuite data type reference

NetSuite Connector

NetSuite Connector

NetSuite targets in mappings

NetSuite targets in mappings

In a mapping, you can configure a Target transformation to represent a single NetSuite target or multiple NetSuite targets.
When you use multiple NetSuite target objects, select a standard object as the primary target and then add a child object. You must map at least one source field, in addition to the external ID, from the parent object to the target. Also, you must map at least one source field from the child object to the target. The external ID indicates the parent object that relates to a child object.
You can use a custom object as a single target.
The following table describes the NetSuite target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Target Type
Select Single Object or Multiple Objects.
Object
Target object for a single target or primary target object for multiple targets.
Child Object
For multiple targets. Displays child objects related to the selected target object. Select a single child object.
Operation
Target operation.
The following table describes the NetSuite target advanced properties that you can configure in a Target transformation:
Advanced Property
Description
Replace All
Removes existing data from the child object before writing new data to the target.
Batch Size
Number of rows that the Secure Agent writes in a batch to the target. When the batch size is 0, the Secure Agent writes data to the target one row at a time. When the batch size is greater than 0, the Secure Agent writes data to the target in batches of the specified size. The default value is 100.
For insert and delete operations, the maximum value is 200. For upsert and update operations, the maximum value is 100.
Success File
Name of the file that contains rows successfully written to the target.
Error File
Name of the file that contains rows that were not written to the target.
Concurrent Threads
Number of concurrent threads. Specify the number of concurrent threads allowed.
To use concurrent threads for mapping tasks, your NetSuite account must be concurrency-enabled.
To optimize performance results with concurrent threads, your administrator might need to adjust the heap size. For example, a heap size of 512 MB for 10 threads might optimize performance results.
Default value is 1.
You cannot use a saved search as a source object in a mapping task that uses concurrent threads.
Success File Directory
Directory for the success log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the success log files to the following directory:
<Secure Agent installation directory>\apps\Data_Integration_Server\data\success
Error File Directory
Directory for the error log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the error log files to the following directory:
<Secure Agent installation directory>\apps\Data_Integration_Server\data\error
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the agent forwards rejected rows to the next transformation.

0 COMMENTS

We’d like to hear from you!