Intacct 

Intacct is a cloud-based financial management and accounting solution.

Intacct integration relies on Intacct’s Data Delivery Service (DDS) for Amazon S3. Intacct DDS exports reports in CSV format to Amazon S3.

This integration does not use the Intacct API.

功能快照

進一步查看此連接器，包括實用的連結和支援的功能。

功能	支援詳細資訊
支援的 Qlik Talend Data Integration 專案	僅複寫專案。不支援資料管道專案。
目標更新方法	複寫任務： 套用變更 儲存變更 在資料湖中登陸資料任務： 變更資料擷取 (CDC)
管理中繼資料	不需要手動產生中繼資料。
結構描述演進	僅支援變更欄資料類型操作。
LOB 欄 (NCLOB、CLOB 和 BLOB) 複寫	不支援。
已排程 CDC	必填。此為目標與來源的變更保持同步的方式。 對於複寫任務，請參閱 排程任務 對於湖登陸任務，請參閱 排程湖登陸任務的 CDC
通知	部分支援 設定變更進行時的通知
監控	僅限 CDC，因為此連接器與完整載入無關。 監控個別資料任務
自動解除 JSON 欄裝載的巢狀結構	不支援。來源資料集中的 JSON 欄裝載不會在目標上自動解除巢狀結構。

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

To set up the connection, ensure you have the following:

• An active subscription to Intacct’s Data Delivery Service (DDS). Integration with Intacct does not interact with the Intacct REST API; instead, it relies on DDS to publish CSV data to an AWS S3 bucket, from which the data is then consumed. For more information, see Data Delivery Service.
• Sufficient permissions in AWS Identity and Access Management (IAM) to create policies, roles, and attach policies to roles. These permissions are required to authorize Qlik Talend Cloud to access your S3 bucket and to read and extract data published to the bucket.

To configure your Amazon S3 access:

1. Log into your Amazon Web Services account.
2. Navigate to the Amazon S3 bucket you want to use as the Cloud Storage Target for Intacct.
3. Enable Intacct to access the AWS S3 buckets by following Intacct's documentation.

To configure your Automatic Data Delivery Service:

1. In your Intacct account, navigate to Company > Data Delivery Service > Automatic.
2. Click Add.
3. In the File attributes section, define the settings as follows:
   • Delimiter: Commas
   • Text qualifier (delimiter): Double quote (")
   • Encryption: Do not encrypt
4. In the Delivery options section, define the settings as follows:
   • Cloud storage destination: Select the Amazon S3 Cloud Storage Target you created.
   • Frequency: Select the frequency you want to use to trigger a data export in Intacct.
5. In the Objects section, select the objects you want to include in the export.
6. Save the schedule.

To retrieve your company ID:

1. Log into your Intacct account.
2. Navigate to Company > Setup > Company > General Information tab.
3. Find your Company ID under Company Information.
4. Copy and paste your company ID into a secured file.

Creating the connection

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

1. 填寫所需的連線屬性。

2. 在連線名稱中提供連線名稱。

3. 選取開啟連線中繼資料以在建立後定義連線的中繼資料。

4. 按一下建立。