Columns
In the 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.