NetSuite Objects in Mappings
When you create a mapping, you can configure a Source, Target, or Lookup transformation to represent a NetSuite object.
NetSuite Sources in Mappings
In a mapping, you can configure a Source transformation to represent a single NetSuite source or multiple NetSuite sources.
You can use multiple related NetSuite standard objects as a source. You can select a standard object as the primary source, then you add one or more sibling objects or a single child object. When you select a list/record type object, its related object appears in the sibling list. NetSuite does not support the use of child and sibling objects at the same time.
The following table describes the NetSuite source properties that you can configure in a Source transformation:
Property | Description |
|---|
Connection | Name of the source connection. |
Source type | Select Single Object or Multiple Objects. |
Object | For a single source. Select the source object. |
Add Source Object | For multiple sources. Select the primary object. |
Add Child Object | For multiple sources. Select the desired child object. |
Add Sibling Objects | For multiple sources. Select the desired sibling objects. |
The following table describes the NetSuite source advanced properties that you can configure in a Source transformation:
Advanced Property | Description |
|---|
Start Date | Start date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ. To perform a full read, do not use the Start Date and End Date properties. |
End Date | End date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ. To perform a full read, do not use the Start Date and End Date properties. |
Page Size | Page size used to get data from a source. Default is 100 rows. |
Get Deleted | Includes records that were deleted between the start date and end date for changed data capture. |
Maximum Number of Records to Be Read | Maximum number of records read from the source. For example, a value of 100 means that the agent reads 100 records from the source. The default value is 0, which means the agent reads all records. |
Adding Multiple Source Objects
To use multiple source objects in a Source transformation, you select the primary source object and the child or sibling objects on the Source tab of the Properties panel.
1. In the Objects and Relationships section, click the arrow to open the Action menu and then select Add Source Object.
2. Select the primary object.
3. Click the arrow in the primary object's row and from the Related Object Actions menu, select either Add Child Object or Add Sibling Objects.
4. Select the desired child object or one or more sibling objects.
After you select the source objects, the Objects and Relationships section displays the source objects and the relationship between the objects, as shown in the following image:
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. If you use multiple NetSuite target objects, you must map at least one field in the parent target object and one field in the child target object. Also, the parent target object's External ID is mandatory. 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 Informatica Cloud writes in a batch to the target. When batch size is 0, Informatica Cloud writes data to the target one row at a time. When batch size is greater than 0, Informatica Cloud writes data to the target in batches of the specified size. |
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. |
Success File Directory | Directory for the success rows file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Informatica Cloud writes the success rows file to the following directory: <Secure Agent installation directory>/main/rdtmDir/success. |
Error File Directory | Directory for the error rows file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Informatica Cloud writes the error rows file to the following directory: <Secure Agent installation directory>/main/rdtmDir/error. |
NetSuite Lookups in Mappings
In a mapping, you can configure a Lookup transformation to represent a NetSuite object. You can use Netsuite standard objects and custom objects as lookups.
When you use a NetSuite object as a lookup, you do not need to configure specific NetSuite properties. You can use a custom field in a lookup condition if the field is filterable.
