User Guide

Back Next

Microsoft SQL Server Data Types

Informatica supports the following Microsoft SQL Server data types when you use Sqoop:

Bigint

Bit

Char

Datetime

Decimal

Float

INT

Money

Numeric

Real

Smalldatetime

Smallint

Smallmoney

Text

Time

Tinyint

Varchar

Consider the following rules and guidelines when you configure Microsoft SQL Server data types in a Sqoop mapping:

If you create or replace the target table at run time and run the mapping on the Blaze or Spark engine to export Bigint data, the mapping fails.

If you run a Sqoop mapping to export time data, Sqoop does not export milliseconds.