Preface
Introduction to Greenplum Connector
- Greenplum Connector assets
- Administration of Greenplum Connector
Greenplum connections
- Greenplum connection properties
Mappings and mapping tasks with Greenplum Connector
- Greenplum sources in mappings
- Greenplum targets in mappings
  - Match and update columns
  - Error handling for Greenplum targets
Data type reference
- Greenplum and transformation data types

Greenplum Connector

Back Next

Greenplum and transformation data types

When you import Greenplum tables, the ODBC data types corresponding to the Greenplum data types appear.

The Secure Agent writes the data to the Greenplum writer as ODBC data type. The Greenplum writer writes the data into the gpload utility and the gpload utility converts the data type to the Greenplum data type before it writes to the Greenplum database.

The following table lists the Greenplum data types that the runtime environment supports and the corresponding ODBC and transformation data types:

Greenplum Data Type	ODBC Data Type	Transformation Data Type
Bigint	Bigint	Bigint
Bigserial	Bigint	Bigint
Boolean	Boolean	String
Character	Default is Char. For multibyte character, use Nchar.	String
Character varying	Default is Varchar. For multibyte character, use Nvarchar.	String
Date	Date	Date/Time
Double precision	Double or Float	Double
Integer	Integer	Integer
Numeric	Numeric	Decimal
Real	Real	Double
Serial	Integer	Integer
Smallint	Tinyint	Integer
Text	Text	Text
Time	Time. Precision is 6.	Date/Time
Timestamp	Timestamp. Precision is 6.	Date/Time

Rename Saved Search

Table of Contents

Greenplum Connector

Greenplum Connector

Greenplum and transformation data types

Greenplum and transformation data types