EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

Supported Amazon Redshift datatypes

Norman Matos

Associate Scrum Master • Strategy

This is a summary of the Amazon Redshift data types that are supported by MicroStrategy, and how datatypes in Amazon Redshift are converted to MicroStrategy datatypes

Amazon Redshift Datatype Support


Currently Strategy supports 23 out of 26 Amazon Redshift data types which is 88% of the data types in Amazon Redshift.
 
Supported data types are listed below.
 


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)


[PostgreSQL Unicode(x64)]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=ODBC for PostgreSQL
Setup=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
FileUsage=1
DriverUnicodeType=1[TPCH_PG]
Driver=/opt/mstr/MicroStrategy/install/pgsql-11/lib/psqlodbcw.so
Description=PostgreSQL Unicode(x64)
Database=tpch
Servername=xxx.xxx.xxx.xxx
Port=5432
Protocol=9.3
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ConnSettings=
DriverUnicodeType=1Amazon Redshift DatatypeMSTR DatatypeDATA TYPEMSTR TYPEDATEDATETIMETIME(6)SECONDTIMETIMESTAMP(6)TIMESTAMPTIMESTAMP(7)TINYINTINTEGER(1)SAMLLINTINTEGER(2)INTEGERINTEGER(4)BIGINTINTEGER(8)SMALLDECIMALDECIMAL(16,0)DECIMALDECIMAL(10,10)REALREALDOUBLEDOUBLEFLOAT(n)DOUBLEVARCHARVARCHAR(n)NVARCHARNVARCHAR(n)ALPHANUMVARCHAR(n)SHORTTEXTVARCHAR(n)VARBINARYVARBIN(5000)BLOBLONG VARBIN(0)CLOBLONG VARCHAR(0)NCLOBLONG VARCHAR(0)

Comment

0 comments

Details

Knowledge Article

Published:

August 4, 2017

Last Updated:

August 4, 2017