Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsThe connection string property ”DataTypeLegacyMode” is an undocumented property that tries to mimic the way 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.
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
1. Change "DataTypeLegacyMode=false;" to "DataTypeLegacyMode=1;" in the connection string in QlikView.
2. Disabling Standard mode of Qlik Sense.
http://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/LoadData/disable-standard-mode.htm
3. In Data load editor, copy and paste the QlikView connection string to Qlik Sense app.
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsSearch Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a caseExperiencing a serious issue, please contact us by phone. View phone numbers and hours by region.
Selecting the options from the dropdown will update the content below.