Hi Maria,
Thank you for the feedback. Unfortunatelly, it failes since selecting ODBC instead of MYSQL complain about unknown attribute enum.
ODBC data source <SINGLESTORE_ODBC> error message for operation <SQLGetTypeInfo>: <[ss-1.1.0][7.8.15]Unknown column 'enum' in 'field list'>
I will continue to investigate this.
I forgot to mention that I’m using SingleStore ODBC driver Unicode. That kind of issue does not occured with ANSI driver but we need to use a Unicode driver.
I suspect that SAP Data Services add ‘N(String)’ for MySQL database in Unicode. But not sure.
Regards
emmanuel