Introduction

NetSuite is the world's leading provider of cloud-based business management software. NetSuite helps companies manage core business processes with a single, fully integrated system covering ERP/financials, CRM, e-commerce, inventory and more. The plugins will allow users to replicate their NetSuite data into one of the available sinks.

Use case(s)

• Read and replicate user-selected NetSuite's tables. This will allow users to use NetSuite data for reporting purposes.

User Stories

• As a data pipeline developer, I would like to select one of the pre-defined NetSuite domains to replicate the tables into specified sink
• As a data pipeline developer, once I've specified parameters for NetSuite data, Data Fusion should handle and populate schema automatically, so I do not need any manual work.
• As a data pipeline developer, I should be able to pick the NetSuite domain for which I want to get all the associated tables and Data Fusion should automatically identify all the tables associated with the domain

Plugin Type

• Batch Source
• Batch Sink 
• Real-time Source
• Real-time Sink
• Action
• Post-Run Action
• Aggregate
• Join
• Spark Model
• Spark Compute

Configuration

* The available domains are listed under "Connect browser" at https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/odbc/record/account.html

Design / Implementation Tips

• Please review limitations under "Custom Field Limitations" at https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSALC/NSALC.pdf

Design

Approach(s)

Properties

Security

Limitation(s)

Future Work

Test Case(s)

• Test case #1
• Test case #2

Sample Pipeline

Please attach one or more sample pipeline(s) and associated data. 

Pipeline #1

Pipeline #2

References

• ODBC/JDBC Tables: https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2017_2/odbc/record/account_activity.html
• SuiteAnalytics Connect: https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSALC/NSALC.pdf