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.
2356

set Extract Type to "UTF16 to UTF8 Conversion"

2368

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

日本語
English
Translated by AI