NetSuite Batch Source
- Prateek Duble
Owned by Prateek Duble
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
| User Facing Name | Type | Description | Constraints | Valid Values |
|---|---|---|---|---|
| Account ID | string | NetSuite account ID | ||
| Role ID | string | NetSuite role ID for the specified account | ||
| Server Name | string | SuiteAnalytics connect server host name | ||
| User | string | User email address to log in to NetSuite | ||
| Password | string | Password to log in to NetSuite | ||
| Port Number | Integer | TCP/IP port on which SuiteAnalytics Connect server is listening | ||
| Server Data Source | string | SuiteAnalytics Connect server data source | NetSuite.com or NetSuite2.com | |
| Domain to replicate* | drop-down | Group of related NetSuite tables to copy over |
| |
| Encrypted | bool | Enable the use of SSL encryption for data transfer | Optional | 0 and 1, Default: 0 |
| Trust Store | string | Optional | ||
| Validate Server Certificate | bool | Enable driver to validate the certificate sent by the SuiteAnalytics Connect server | Optional | true and false, Default: true (if property is used) |
* 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.