NetSuite
NetSuite SuiteAnalytics is the built-in reporting and analysis tool for NetSuite. You can use NetSuite SuiteAnalytics as a data source when landing or replicating data.
-
For more information about connecting to SaaS applications, see 连接到 SaaS 应用程序.
-
For more information about Lite connectors, see SaaS 应用程序连接器的分类.
-
Depending on your use case, you might need to install 数据移动网关 to move data from SaaS applications. For more information, see 什么时候需要 数据移动网关？.
Supported update methods
For more information, see 目标更新方法概览.
Landing tasks:
-
Change data capture (CDC)
-
Reload and compare
Replication tasks:
-
Change data capture (CDC) using Change Tables
-
Full load
Landing data in a data lake tasks:
-
Change data capture (CDC)
-
Reload
Preparing for authentication
To access your NetSuite data, you need the following:
-
A NetSuite account with the Data Warehouse Integrator role.
-
Make sure that you have installed and configured NetSuite SuiteAnalytics Connect Service.
You need to authenticate the connection with your account credentials.
To find your NetSuite service host, port, and account ID:
-
Log in to your NetSuite account.
-
In the homepage of your NetSuite account, find the Settings module and select Set Up SuiteAnalytics Connect.
-
Click Your Configuration.
Your service host, port, and account ID information are displayed.
Creating the connection
For more information, see 连接到 SaaS 应用程序.
- Fill in the required connection properties.
-
Provide a name for the connection in Connection name.
-
Select Open connection metadata to define metadata for the connection when it has been created.
-
Click Create.
| Setting | Description |
|---|---|
| Data gateway |
如果您的用例需要，请选择一个 数据移动网关。 信息注释
此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动。 |
| Service Host | Service host. |
| Account ID |
Account ID. This is the first part of the NetSuite URL. For example, if the URL is https://1234567.app.netsuite.com/, your account ID is 1234567. |
| Role ID |
Role ID. |
| Consumer Key | Consumer key. |
| Consumer Secret | Consumer secret. |
| Token | Token. |
| Token Secret | Token secret. |
| Start Date | Start date for reporting endpoints in the format YYYY-MM-DD. |
| Customer Fields |
Comma-separated list of fields to fetch for the Customer table. Set to * to fetch all fields. 信息注释This table contains a large number of columns that may take a long time to load. It is recommended to only select the columns you require here.
|
| Transaction Fields |
Comma-separated list of fields to fetch for the Transaction table. Set to * to fetch all fields. 信息注释This table contains a large number of columns that may take a long time to load. It is recommended to only select the columns you require here.
|
| Transactionline Fields |
Comma-separated list of fields to fetch for the Transactionline table. Set to * to fetch all fields. 信息注释This table contains a large number of columns that may take a long time to load. It is recommended to only select the columns you require here.
|