Data Loader columns

You can add incremental keys from the source database and configure column properties. With the object drop-down you can change the view from the current object to different objects in the model.

The data types from the source database, visible in the available list, are converted into the relevant data loader data types. The following tables show the mapping from the source database data types to the data loader data types.

This table shows the Microsoft SQL Server data types:

ION Data Loader data types	Microsoft SQL Server data types
Integer	int, bigint, smallint, tinyint
Decimal	decimal, numeric, float, real
DateTime	datetime, datetime2, smalldatetime, datetimeoffset
Time	time
Date	date
String	char, varchar, nchar, nvarchar, text
String (Binary)	binary, varbinary

This table shows the Oracle data types:

ION Data Loader data types	Oracle
Integer	number
Decimal	float, binary float, binary double
DateTime	timestamp, timestamp with time zone, timestamp with local time zone
Date	date
String	char, varchar2, nchar, nvarchar2

This table shows the DB LUW data types:

ION Data Loader data types	DB2
Integer	integer, bigint, smallint
Decimal	decimal, real
Date	date
String	character, varchar

This table shows the DB2/400 data types:

ION Data Loader data types	DB2/400
Integer	integer, bigint
Decimal	decimal
DateTime	timestamp
Time	time
Date	date
String	character, varchar

This table shows the PostgreSQL data types:

ION Data Loader data types	PostgreSQL
Integer	integer, bigint, smallint
Decimal	decimal (showing as numeric), numeric, real
DateTime	time with time zone, timestamp with timezone
Date	date
String	character, character varying