Preface
Introduction to Microsoft SQL Server Connector
- Microsoft SQL Server Connector assets
Connections for Microsoft SQL Server
- Prepare for authentication
  - Prepare for Kerberos authentication
    - Configuring Kerberos authentication
    - Setting environment variables
- Connect to Microsoft SQL Server
Mappings and mapping tasks with Microsoft SQL Server Connector
Troubleshooting
- Configuring the JDBC and ODBC drivers for Microsoft SQL Server Connector
Data type reference
- Microsoft SQL Server and transformation data types

Microsoft SQL Server Connector

Back Next

Microsoft SQL Server and transformation data types

The following table lists the Microsoft SQL Server data types that

Data Integration

supports and the corresponding transformation data types:

Microsoft SQL Server Data Type	Description	Transformation Data Type	Description
Bigint	-9223372036854775808 to 9223372036854775807	Bigint	-9223372036854775808 to 9223372036854775807 Precision 19, Scale 0
Binary	1 to 8000 characters	Binary	1 to 104857600 bytes Precision 1 to 8000
Bit	0 to 1	Integer	0 to 1 Precision 10, Scale 0
Char	1 to 8000 characters	String	1 to 104857600 characters
Date	0001-01-01 to 9999-12-31	Date/Time	0001-01-01 to 9999-12-31 Precision 29, Scale 9
Datetime	Date range : January 1, 1753 to December 31, 9999 Time range : 00:00:00 to 23:59:59.997 Precision 23, scale 3	Date/Time	Date range : 0001-01-01 to 9999-12-31 Time range : 00:00:00 to 23:59:59.9999999 Precision 29, Scale 9
Datetime2	Date range : 0001-01-01 to 9999-12-31 Time range : 00:00:00 to 23:59:59.9999999 Precision 27, scale 7	Date/Time	Date range : 0001-01-01 to 9999-12-31 Time range : 00:00:00 to 23:59:59.9999999 Precision 29, Scale 9
Decimal(P,S)	Precision 1 to 28, Scale 0 to 28	Decimal	Precision 1 to 28, Scale 0 to 28
Float	-1.79E+308 to 1.79E+308	Double	Precision 15, Scale 0
Int	-2147483648 to 2147483647	Integer	-2147483648 to 2147483647 Precision 10, Scale 0
Money	-922337203685477.5808 to 922337203685477.5807	Decimal	-922337203685477.5808 to 922337203685477.5807 Precision 19, Scale 4
Nchar	1 to 4000 characters	String	1 to 104857600 characters
Ntext	1 to 1073741823 bytes	Text	1 to 104857600 characters Default is 32000
Numeric(P,S)	Precision 1 to 28, Scale 0 to 28	Decimal	Precision 1 to 28, Scale 0 to 28
Nvarchar	1 to 4000 characters	String	1 to 104857600 characters
Real	-3.40E+38 to 3.40E+38	Decimal	Precision 7, Scale 0
Smalldatetime	Date range : 1900-01-01 to 2079-06-06 Time range : 00:00:00 to 23:59:59	Date/Time	Date range : 0001-01-01 to 9999-12-31 Time range : 00:00:00 to 23:59:59.9999999 Precision 29, Scale 9
Smallint	-32768 to 32767	Integer	-32768 to 32767 Precision 10, Scale 0
Smallmoney	-214748.3648 to 214748.3647	Decimal	-214748.3648 to 214748.3647 Precision 10, Scale 4
Text	1 to 2147483647 bytes	Text	1 to 104857600 characters Default is 32000
Time	00:00:00.0000000 to 23:59:59.9999999	Date/Time	Date range : 0001-01-01 to 9999-12-31 Time range : 00:00:00 to 23:59:59.9999999 Precision 29, Scale 9
Tinyint	0 to 255	Integer	0 to 255 Precision 10, Scale 0
Varbinary	1 to 8000 characters	Binary	1 to 104857600 bytes Precision 1 to 8000
Varchar	1 to 8000 characters	String	1 to 104857600 characters

Rename Saved Search

Table of Contents

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Microsoft SQL Server and transformation data types

Microsoft SQL Server and transformation data types