Asset types and mapping

Data Integrity Suite
Product
Spatial_Analytics
Data_Integration
Data_Enrichment
Data_Governance
Precisely_Data_Integrity_Suite
geo_addressing_1
Data_Observability
Data_Quality
dis_core_foundation
Services
Spatial Analytics
Data Integration
Data Enrichment
Data Governance
Geo Addressing
Data Observability
Data Quality
Core Foundation
ft:title
Data Integrity Suite
ft:locale
en-US
PublicationType
pt_product_guide
copyrightfirst
2000
copyrightlast
2025

Explore the different asset types and datatype to catalog datatype mappings available for the datasource.

  • Advanced connectivity bundle

    The asset types supported for Azure SQL server using advanced connectivity bundle are:

    DB Association, DB Attribute, DB Calculated Attribute, DB Calculated Measure, DB Calculation View, DB Check Constraint, DB Condition, DB Filter, DB Foreign Key, DB Function, DB Index, DB Index Member, DB Input Parameter, DB Operation, DB Output Column, DB Parameter, DB Partition Column, DB Primary Key, DB Result Attribute, DB Sequence, DB Stage, DB Stored Procedure, DB Stream, DB Task, DB Temporary Table, DB Trigger, DB Type, DB Unique Constraint
    • Analyze connectors

      The asset types supported for Azure SQL server using Analyze connectors are:

      SQL Server Host, SQL Server Database, SQL Server Schema, SQL Server Function, SQL Server Function Column, SQL Server Procedure, SQL Server Procedure Column, SQL Server Trigger, SQL Server Table, SQL Server Table Column, SQL Server View, SQL Server View Column

Mapping

Advanced connectivity bundle mapping

The tables lists the mapping from datatype to catalog datatype using advance connector bundle, making data management simpler and more organized. For configuration details, refer Advanced connector bundle.

Datatype Catalog datatype
bigint integer
bigint identity integer
binary blob
bit boolean
char string
date date
datetime datetime
datetime2 datetime
datetimeoffset datetime
decimal decimal
decimal() identity decimal
float decimal
image blob
int integer
int identity integer
money decimal
nchar string
ntext string
numeric decimal
numeric() identity decimal
nvarchar string
nvarchar(max) string
real decimal
smalldatetime datetime
smallint integer
smallint identity integer
smallmoney decimal
sql_variant string
sysname string
text string
time time
timestamp blob
tinyint integer
tinyint identity integer
uniqueidentifier string
varbinary blob
varbinary(max) blob
varchar string
varchar(max) string
xml string
geography GEOGRAPHY
geometry GEOMETRY
hierarcyid string
character varying string
char_varying string
dec decimal
rowversion datetime
NATIONAL CHAR string
NATIONAL CHAR VARYING string
NATIONAL CHARACTER string
NATIONAL CHARACTER VARYING string
NATIONAL TEXT string
double precision decimal