Data type mapping
The following table lists the mapping of JDBC data types to Java data types used in ARIS Process Mining.
Integer values from a JDBC database that are less than values of Long type are always imported as Long. That means that ARIS Process Mining does not support values of unsigned Long type.
If you select that a column of type DECIMAL or NUMERIC without decimal places should be converted to type LONG, make sure that this column contains only values greater than -263 and less than 263 (1 see below).
Some database vendors may use the JDBC data types in a way that does not comply with the JDBC standard, for example, if a database returns the JDBC data type BIGINT but contains values that are less than -263 or greater than 263 (1 see below). This may lead to errors during data extraction. In such a case, use VIEWS and convert such a column to a JDBC data type that corresponds to the JDBC standard used by this database.
Data type mapping
JDBC data type | Usable as foreign key | Data type in ARIS Process Mining | Remarks |
BIGINT | Yes | Long | |
BIT | Yes | Long | |
CHAR | Yes | Text | |
DATE | No | Date | Milliseconds since 01.01.1970 00:00:00 is interpreted as UTC. |
DECIMAL (with decimal digits) | No | Double | |
DECIMAL (without decimal digits) | Yes (1 see below) | Long, Double or Text | Conversion can be configured. |
DOUBLE | No | Double | |
FLOAT | No | Double | |
INT/INTEGER | Yes | Long | |
LONGNVARCHAR | Yes | Text | |
LONGVARCHAR | Yes | Text | Cannot be used as foreign key in Oracle. |
NCHAR | Yes | Text | |
NCLOB | Yes | Text | |
NUMERIC (with decimal digits) | No | Double | |
NUMERIC (without decimal digits) | Yes (1 see below) | Long, Double or Text | Conversion can be configured. |
NVARCHAR | Yes | Text | |
REAL | No | Double | |
SMALLINT | Yes | Long | |
STRING | Yes | String | |
TIME | No | Long | Milliseconds since 01.01.1970 00:00:00 is interpreted as UTC. |
TIMESTAMP | No | Date | Milliseconds since 01.01.1970 00:00:00 is interpreted as UTC. |
TINYINT | Yes | Long | |
VARCHAR | Yes | Text |
1 This JDBC data type can only be used as relation if the Long or Text data type is selected in ARIS Process Mining.