How to ensure proper encoding of table names for Amazon Aurora and MariaDB in MicroStrategy 10

The web data import table catalog and Strategy developer warehouse table display table names are  truncated to one character when the datasource is MariaDB or Amazon Aurora, particularly when Strategy Intelligence Server is hosted in a Linux OS. This does not happen when Strategy Intelligence Server is installed in Windows OS:
 
Web data import (happens for both DSN and DSNless):
 

 
Strategy Developer WH catalog:

 
 
Workaround:
 
In high overview, the workaround is to change the way the driver encodes the character set from utf-8 to non utf-8. This works for both DSN and DSN-less connections:
 

1. Make sure that the odbc.ini file (found in the folder where Strategy is installed) the MariaDB and the Amazon Aurora DSN have the parameter “DriverUnicodeType=1”

[MARIADB]
Driver=/usr/lib64/libmyodbc5w.so
Description=MySQL ODBC 5.3 Driver
SERVER=10.27.10.190
PORT=3306
DATABASE=eatwh2
OPTION=1048576
DriverUnicodeType=1
 

• Open Strategy Developer. Go to the section “Administration>Configuration Managers>Database Instances”.

• Then select the related database instance, right-mouse click on it and edit:

• In the “Database Connections” dialog , change tab to the “Advanced” tab:

• Change the “Character set encoding for Unix Drivers” option to “Non UTF-8”.
• Ok in dialogs “Database Connections” and “Database Instance”.
• After these changes, the web data import table catalog and the developer warehouse catalog should work fine: