Columns

In the Column Selector you can add columns to be extracted from the source database and configure column properties. All columns available in selected object are listed in the Available list on the left side. With the object drop-down you can change the view from the current object to different objects in the model.

The selected list shows the columns from all the objects by default. When you select Show columns from selected object check box, you can change the view to the selected object.

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

This table shows the Microsoft SQL Server data types:

ION data types Microsoft SQL Server data types
Integer bigint, int, smallint, tinyint
Decimal float, real, decimal, numeric, money, smallmoney
DateTime datetime, smalldatetime, timestamp
Time time
Date date
Boolean bit
String char, nchar, nvarchar, varchar, text, ntext, binary, varbinary, image
String (Binary) binary, varbinary, image, timestamp, rowversion

This table shows the Oracle data types:

ION data types Oracle data types
Integer number(p, s<=0), number(p) → number(p,0)
Decimal number(p, s>0), number(s>0), number, float, real, binary_float, binary_double
DateTime timestamp, timestamp with time zone, timestamp with local time zone
Time
Date date
Boolean
String char, nchar, nvarchar, varchar2, clob, nclob
String (Binary) blob, bfile, raw, longraw

This table shows the DB LUW data types:

ION data types DB2 LUW data types
Integer bigint, integer, smallint
Decimal real, decimal, double, float, decfloat
DateTime timestamp
Time time
Date date
Boolean boolean
String char, varchar, long varcharclob, dbclob, graphic, long vargraphic, vargraphic, xml
String (Binary) blob, binary, varbinary

This table shows the DB2/400 data types:

ION data types DB2/400 data types
Integer smallinit, integer, bigint
Decimal decimal, numeric, decfloat, real, double
DateTime timestamp
Time time
Date date
Boolean
String char, varchar, clob, graphic, vargraphic, dbclob, xml
String (Binary) blob, varbinary, blob

This table shows the PostgreSQL data types:

ION data types PostgreSQL data types
Integer integer, smallint, bigint, serial, bigserial, smallserial
Decimal float, real, float8, numeric, decimal, double precision, money
DateTime timestamp, timestamp with time zone
Time time, time with time zone
Date date
Boolean boolean
String char, character, character varying, varchar, bit, bit varying, box, cidr, circle, inet, line, lseg, macaddr, path, point, polygon, text, tsquery, tsvector, xml, json, interval
String (Binary) bytea, jsonb

Adding a column

You can use the Filter field to limit the list of available columns by Column name or Data type.

Click the appropriate line in the Available list to select one or multiple columns. Use drag and drop or the arrow icons to move columns to the selected list.

Click the double arrows to move all available columns from the selected object and back.

Rearranging columns

To change the order to export data, you can drag and drop one or multiple columns to new positions in the Selected list.

Removing columns

You can remove one or multiple columns from the Selected list. To do so, you can use drag and drop or arrow icons and move the selected columns to the Available list.