NetSuite SuiteAnalytics

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 連接器分類.
Depending on your use case, you might need to install Data Movement gateway to move data from SaaS applications. For more information, see 何時需要 Data Movement gateway？.

The System Notes table in NetSuite is not supported.

Feature/Functionality	Support details
Supported Qlik Talend Data Integration projects	Data pipeline projects and Replication projects.
目標更新方法	Landing tasks: Change data capture (CDC) using Change Tables Reload and compare Replication tasks: Full load Change data capture (CDC) using Change Tables Change data capture (CDC). Using this method, changes are directly applied to the target. Landing data in a data lake tasks: Change data capture (CDC) using Change Tables Reload
管理中繼資料	Manual metadata generation is required.
結構描述演進	Not supported
Replication of LOB columns (NCLOB, CLOB, and BLOB)	Determined by the task type: Landing tasks: Supports limited LOB size only Replication tasks: Supports unlimited LOB
Scheduled CDC	Only required when accessing data sources without Data Movement gateway.
Notifications	Fully supported 設定變更進行時的通知
Monitoring	Fully supported 監控個別資料任務
Automatic denesting of JSON column payloads	Fully supported

Preparing for authentication

To access your 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

如需詳細資訊，請參閱連線到 SaaS 應用程式。

填寫所需的連線屬性。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。
按一下建立。

Connection settings
Setting	Description
Data gateway	如您的使用情況有需要，選取 Data Movement gateway。資訊備註此欄位無法用於 Qlik Talend Cloud 啟動器訂閱，因為不支援 Data Movement gateway。若您有另一個訂閱層級且不想使用 Data Movement gateway，選取無。如需關於 Data Movement gateway 福利的資訊以及需要此項的使用案例，請參閱 Qlik Data Gateway - Data Movement。
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.

此頁面是否對您有幫助？

若您發現此頁面或其內容有任何問題——錯字、遺漏步驟或技術錯誤——請告知我們！

在此留下意見回饋