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

前へ次へ

SalesforceソースとPostgreSQLターゲット

次の表は、SalesforceソースとPostgreSQLターゲットを使用した

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

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