アプリケーション取り込みとレプリケーション

前へ次へ

SalesforceソースとMicrosoft Azure Synapse Analyticsターゲット

次の表は、SalesforceソースとMicrosoft Azure Synapse Analyticsターゲットを使用した

設定のデフォルトデータ型マッピングを示しています。

Salesforceソースデータ型	Microsoft Azure Synapse Analyticsターゲットデータ型
anytype(`precision`), 1 <= p <= 255	varchar(`size`), 1 <= size <= 255
base64 精度は、選択したbase64ボディサイズによって異なります。	nchar(`size`), 1 <= size <= 255
boolean	bit
combobox(`precision`), 1 <= p <= 255	varchar(`size`), 1 <= size <= 255
currency(p,s), 1 <= p <= 18, 0 <= s <= 17	decimal(p,s), 1 <= p <= 18, 1 <= s <= 17
date	date
datetime	datetime2(3)
double(p,s), 1 <= p <= 18, 0 <= s <= 17	decimal(p,s), 1 <= p <= 18, 1 <= s <= 17
email(`precision`), 1 <= p <= 80	varchar(`size`), 1 <= size <= 80
encryptedstring(`precision`), 1 <= p <= 175	varchar(`size`), 1 <= size <= 175
id(`precision`), 1 <= p <= 18	varchar(`size`), 1 <= size <= 18
int	int
long	bigint
multipicklist(`precision`), 1 <= p <= 4099	varchar(`size`), 1 <= size <= 4099
percent(p,s), 1 <= p <= 18, 0 <= s <= 17	decimal(p,s), 1 <= p <= 18, 1 <= s <= 17
phone(`precision`), 1 <= p <= 40	varchar(`size`), 1 <= size <= 40
picklist(`precision`), 1 <= p <= 255	varchar(`size`), 1 <= size <= 255
reference(`precision`), 1 <= p <= 18	varchar(`size`), 1 <= size <= 18
string(`precision`), 1 <= p <= 100	varchar(`size`), 1 <= size <= 100
textarea(`precision`), 1 <= p <= 131072	varchar(`size`), 1 <= size <= max
time	time(3)
url(`precision`), 1 <= p <= 255	varchar(`size`), 1 <= size <= 255