Configuration Guide

Back Next

Data Types for Columns

The

MDM Hub

has a set of data types for columns. The

MDM Hub

data types map directly to

Oracle

IBM DB2

, and

Microsoft SQL Server

data types. For more information about the database data types, see the product documentation for your database.

To change the data types of the columns, use the

Hub Console

. Do not change data types in the database. If you change data types in the database, the metadata validation process might encounter issues.

The following table shows how the

MDM Hub

data types map to the database data types:

MDM Hub	Oracle	IBM DB2	Microsoft SQL Server
CHAR	CHAR	CHARACTER	NCHAR ¹
VARCHAR	VARCHAR2	VARCHAR	NVARCHAR
NVARCHAR2	NVARCHAR2	VARGRAPHIC	NVARCHAR
NCHAR	NCHAR	GRAPHIC	NCHAR ¹
DATE	DATE	TIMESTAMP	DATETIME2
TIMESTAMP ²	TIMESTAMP	TIMESTAMP	DATETIME2
NUMBER	NUMBER	DECIMAL	NUMERIC
INT	INTEGER	DECIMAL (31,0)	BIGINT