SAP HANA Data Types
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Database Connection
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
All I hear are crickets! =P
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)