SAP HANA Data Types

[Uziel]

When I load data to SAP Hana via Alteryx it converts booleans to integers and dates to timestamps. It does it with both the 'Write Data In-DB' and 'Output Data' widgets.  I have a select widget preceding the output that specifically defines the data types I want.

Does anyone know how to correct that?

[Uziel]

All I hear are crickets!  =P

[SeanAdams · Accepted solution]

Hey @Uziel 

The most fool-proof way to do what you're looking for is to explicitly create the table using a Create Table script with the data types you want.    This is the case for any DB you use.

This way you are not relying on Alteryx's best guess as to the right data-type, but rather you will get exactly what you want.

NOTE: this also is important with sizes of strings; and the subtype (Unicode vs. ANSI strings - in MS SQL these are NVARCHAR and VARCHAR)