NetSuite Batch Source
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
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.
Pipeline #1
Pipeline #2
References
Created in 2020 by Google Inc.