Atrium Integrator supported data types

If a BMC CMDB attribute of the currency data type is mapped to an integer field in the external data store, the default allowable currency type (USD) in BMC CMDB is populated along with the integer field. However, if a BMC CMDB attribute of the currency data type is mapped to a varchar field in the external data store, Atrium Integrator sets the currency type based on the value that you have specified in the varchar field. For example, if the varchar field value is 2134 EUR, Atrium Integrator sets the currency type as EUR.

Related Topics

Creating a data store connection for the data transfer

Each value that is defined for a BMC CMDB attribute of the enum data type has an associated ID. A varchar field in the external data store can be mapped to the selection value that is defined for the attribute of the enum data type. An integer field in the external data store can be mapped to the associated ID that is defined for the attribute of the enum data type.

The following table lists the data types supported for each external database.

BMC CMDB attribute data types and corresponding supported data types in external data stores

	Data store type
	BMC CMDB attribute data type	Oracle	SQL	DB2	Sybase	XML and CSV	MySQL
Requires specific connection parameters	Yes	Yes	Yes	Yes		No	Yes
	character	number char varchar float date	varchar int float char date/time decimal real	int varchar decimal char date time real	varchar int float char date/time numeric time real	string int number	int Varchar float char date/time integer time Real date decimal timestamp
	currency	number varchar	number varchar	number varchar	number varchar	string int number	int varchar float char integer real decimal
	date	date	date/time real	date time	date/time time	date	date/time time date timestamp
	date/time	char varchar	date/time	date time	varchar char	date	varchar char
	decimal	Not applicable	int float decimal real	int decimal real	int float numeric real	int	varchar float integer time real date decimal
	diary	number char varchar float date	varchar int float char date/time decimal real	int varchar decimal char date time real	varchar int float char date/time numeric time real	string int number	int varchar float char date/time integer time real date decimal timestamp
	integer	number float	int float decimal real	int decimal real	int float numeric real	number int	int float integer real decimal
	real	number float	int float decimal real	int decimal real	int float numeric real	number int	int float integer real decimal
	selection	char varchar number	int decimal number varchar	int varchar decimal char number	varchar int float char numeric real	string int strings	int varchar char integer
	time	char varchar	varchar char	varchar char	varchar char	date	varchar char

Atrium Integrator supported data types

Comments