This documentation applies to the 8.1 version of BMC Atrium Core, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

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.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments