The connection string property ”DataTypeLegacyMode” is an undocumented property that tries to mimic the way an older (legacy) connector fetches data. It will try to convert the data to numeric format and use that if the conversion succeeded, or else use the string representation. It’s undocumented because it’s not very well tested, and can have other unexpected side effects. So the customer is free to use it, but support for it is sparse. And R&D may potentially remove it in upcoming releases. R&D will however look more into datatype handling and formatting for upcoming releases.
Environment:
Qlik SAP Connectors
QlikView
Qlik Sense Enterprise on Windows
The SAP data types CHAR (character) and NUMC (numeric character) were previously interpreted (in the Qlik script) as ‘numeric’ if they contained only digits. Leading zeroes were removed. (0000141000 became 141000).
Resolution:
It may resolve problems when the formatting of SAP data seems to be wrong. In particular with leading 0
QlikView
Change the parameter DataTypeLegacyMode=false; to DataTypeLegacyMode=1; in the connection string.
If the parameter does not exist, add DataTypeLegacyMode=1; within the connection string. For example:
CONNECT TO "Provider=QvSAPSqlConnector.exe;servertype=0;SNC_MODE=false;SNC_QOP=9;advancedProperties=1;ConvRoutine=false;CheckSeparator=false;Nulldate=true;
RemoveAllBlanks=false;ReplaceNullvalue=true;Trace=false;DataTypeLegacyMode=1;PacketSize=20000000;FetchBuffers=99999999;BufferPercentage=30;TimeOutBatch=6000;
TimeOutFetch=12000;TimeOutStartBatch=24000;BatchJobName=/QTQVC/READ_DATA;";
Qlik Sense
- Change "DataTypeLegacyMode=false;" to "DataTypeLegacyMode=1;" in the connection string in QlikView.
- Disable the Standard mode of Qlik Sense: Disabling standard mode
- In the Data load editor, copy and paste the QlikView connection string to Qlik Sense app.
