Supported data types

The supported database systems include numerous data types that are not contained in all database systems or that have other names or different semantics there. 

To avoid undesired behavior, the list below indicates data types that have been tested successfully with PPM Process Extractor JDBC-2-PPM.

Database system

Data types

Note

Oracle

CHAR, VARCHAR2, NCHAR, NVARCHAR2, NUMBER, LONG, DATE, TIMESTAMP

The CLOB, NCLOB, BINARY_FLOAT, and BINARY_DOUBLE data types are not supported.

IBM DB2

VARCHAR, CHAR, BIGINT, REAL, DOUBLE, FLOAT, DATE, TIME, TIMESTAMP

The LONG VARCHAR and CLOB data types are not supported.

Microsoft SQL Server

CHAR, VARCHAR, NCHAR, NVARCHAR, INT, TINYINT, SMALLINT, BIGINT, REAL, FLOAT, DECIMAL, DATETIME, SMALLDATETIME

The LONG VARCHAR and CLOB data types are not supported.