Asset types and mapping

• Base connectivity
  The default asset types supported for Microsoft SQL server are:

  Host, Database, Schema, Table, Table Column, View, View Column, Index

• Advanced connectivity bundle

  The asset types supported for Microsoft 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^{* Limited Availability}

  The asset types supported for Microsoft 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 

  Limited Availability: This feature is currently available only in select workspaces and might be subject to change before general availability.

Mapping

• Default mapping

  The tables lists the mapping from datatype to catalog datatype, making data management simpler and more organized.

  Table 1.

  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	double
  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

• Advanced connectivity bundle mapping

  The tables lists the mapping from datatype to catalog datatype using advance connectivity bundle, making data management simpler and more organized. For configuration details, refer Advanced connectivity 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