Test Data Management
- Test Data Management 10.5
- All Products
Data Types
| Data Movement
| Entity Criteria
| Data Masking
| Data Generation
| Profiling
| Comments
|
---|---|---|---|---|---|---|
Bigdatetime
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Bigint
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Bigtime
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Bit
| Yes
| Yes
| Yes
| Yes
| Yes
| You can enter the following entity criteria: Is Null, Is Not Null, Like, and Not Like.
|
Binary (n)
| Yes
| Yes
| Yes
| Yes
| No
| You can perform nullification masking.
|
Char (n)
| Yes
| Yes
| Yes
| Yes
| Yes
| You can enter characters up to 2000.
To run a profile, you must enter the field length less than or equal to 255.
|
Date
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Datetime
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Decimal (P,S)
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot run entity profiles.
You can enter a precision value up to 28.
|
Double Precision
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot run entity profiles.
You can perform data masking for precision values up to 28.
|
Float (P)
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot run entity profiles.
You can perform data masking for precision values up to 28.
|
Image
| Yes
| Yes
| Yes
| Yes
| No
| Use dictionary generation rule to generate date.
You can perform nullification masking.
|
Int
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Longsysname
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Money
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot run entity profiles.
|
Nchar (N)
| Yes
| Yes
| Yes
| Yes
| No
| |
Numeric (P,S)
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot run entity profiles.
You can enter a precision value up to 28.
|
Nvarchar (N)
| Yes
| Yes
| Yes
| Yes
| No
| |
Real
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot run entity profiles.
|
Smalldatetime
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Smallint
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Smallmoney
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot run entity profiles.
|
Sysname
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Text
| Yes
| Yes
| Yes
| Yes
| No
| In a sequence generation rule, you cannot choose to start the sequence from the last output value.
|
Time
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Timestamp
| Yes
| Yes
| Yes
| Yes
| No
| You can perform nullification masking.
Timestamp values are system generated in Sybase database.
You can restrict the data type from Test Data Manager to generate data.
|
Tinyint
| Yes
| Yes
| Yes
| Yes
| Yes
| When you assign a data generation rule, ensure that you provide a range between 0 and 255.
|
Unichar (N)
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Unitext
| Yes
| Yes
| Yes
| Yes
| No
| In a sequence generation rule, you cannot choose to start the sequence from the last output value.
|
Univarchar (N)
| Yes
| Yes
| Yes
| Yes
| Yes
| |
Unsigned bigint
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot provide negative values.
|
Unsigned int
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot provide negative values.
|
Unsigned smallint
| Yes
| Yes
| Yes
| Yes
| Yes
| You cannot provide negative values.
|
Unsigned tinyint
| Yes
| Yes
| Yes
| Yes
| Yes
| When you assign a data generation rule, ensure that you provide a range between 0 and 255.
|
Varbinary (N)
| Yes
| Yes
| Yes
| Yes
| No
| You can perform nullification masking.
|
Varchar (N)
| Yes
| Yes
| Yes
| Yes
| Yes
| To run a profile, you must enter the field length less than or equal to 255.
|