Salesforce Marketing Cloud (sFTP integration)
Salesforce Marketing Cloudと双方向のデータ連携が可能です。連携には、SFTP接続機能を利用します。
以下ではファイルを仲介したバッチ連携に関して説明しています。
APIを利用したイベントごとのJourney 発火などに関してはこちらを参照してください。
Patterns of data collaboration
- The following cooperation is possible
- Import directly from Datahub (SMC → KARTE)
- Export directly from Datahub (KARTE → SMC)
[SMC→KARTE] SMC上での設定
Using the automation settings, data can be transferred to KARTE in the sequence of “①Data extraction” → “②Data extraction (file encoding conversion)” → “③Data transfer”.
For details on how to create automation, extract data, and transfer data, please check with Salesforce.
The following are points to note when transferring data to KARTE.
「①データ抽出」アクティビティでの設定
- Has Column Headers: Please check it.
- Uses line feed: Check here.
「②データ抽出(ファイルエンコード変換)」アクティビティでの設定
- In DataHub, The import file only supports UTF-8 encoding . SMC defaults to UTF-16 output only, so the conversion function must be enabled. Please contact SMC's !! Support !! for activation. When enabled, you can select UTF-8 replacement in Extract Type.

set Extract Type to "UTF16 to UTF8 Conversion"

Uncheck "Use BOM"
「③データ転送」
- File !! Action !!: Move files from "Safehouse"
- Destination: ExactTarget Enhanced FTP
- Transfer settings: Do not check the file encryption.
[KARTE→SMC] SMC上での設定
SMC can import data using a CSV file on an FTP server.
Use "File Import" from the automation settings to update data extensions and contacts.
[KARTE⇆SMC] KARTE上でのDatahubジョブ設定
Data cooperation is done via the SFTP server on the Marketing Cloud side. For the setting method, Documentation of SFTP connection function please look at.
Caveats
- Depending on the setting and plan of the cooperative service side, there is a possibility that cooperation can not be performed as intended
- Be sure to conduct cooperation verification in advance
Updated over 1 year ago