Atrium Integrator supported data types

The following table shows the supported external data store types and indicates whether you must define specific connection parameters when using that type. The following table lists the data types supported for each external database.

Supported data store types

Type	Requires specific connection parameters
BMC Atrium CMDB	Yes
Comma separated value (CSV) flat file	No
XML	No
Databases IBM DB2 Microsoft SQL Server MySQL Oracle Sybase	Yes

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

BMC Atrium CMDB attribute data type	Oracle	SQL	DB2	Sybase	XML and CSV	MySQL
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

Note

If a BMC Atrium 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 Atrium CMDB is populated along with the integer field. However, if a BMC Atrium 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.

Note

Each value that is defined for a BMC Atrium 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.

Atrium Integrator supported data types

Comments