Thanks for your answer
Date fields are now shown as text. Leading zeroes in field are kept. This example is from COBK. All date fields are newly as text. I want to get the fields as in the right picture (please see the columns Text Count and Numeric)
I used this connection string for the current new extraction:
CUSTOM CONNECT TO "Provider=QvSAPSqlConnector.exe;servertype=0;ASHOST=xxxx;CLIENT=100;SYSNR=01;Nulldate=false;RemoveAllBlanks=false;ReplaceNullvalue=false;Trace=false;NulldateLegacy=true;FLTPLegacy=true;TIMSLegacy=true;MixedMode=1;XUserId=xxxx;XPassword=xxxxx;";
Do you have any idea?
Having the same problems myself now after updating to 6.5.
From the documentation, the Parameter MixedMode should help when changed to TRUE.
However, this doesn't seem to be the case. Not outright at least.
When I tried running the old QVW file with the new connection string parameter, nothing happens.
What I've noticed is that when I copied my script onto a new QVW file, the new connection string parameter now works.
We have updated the legacy transportation of DATS, TIMS & FLTP in the 6.5 release, see the release notes on the download page for more details. I'll paste the relevant ones here:
Some technical adjustments have been made to the Connection String Properties below:
FLTPLegacy: Turns on/off the legacy handling of FLTP data type. When turned on, FLTP values are transferred as text and it is up to Qlik to interpret the content. This will send FLTP values in scientific notation to Qlik.
TIMSLegacy: Turns on/off the legacy handling of TIMS data type. When turned on, TIMS values are transferred as DUAL's.
NulldateLegacy: Now sends the data type DATS values as DUAL's as in the legacy SQL connector.
I believe it will sort out your differences. If there still exists any after you tried the upgrade I would really like to see your findings so we can further adjust. But we have gotten some good feedback from customers who have upgraded from older 5.x versions of SAP Connectors, so most should at least be covered already.
// Thomas Örnmarker
SAP Connectors developer
I can confirm that what Thomas says is your best option to get identical treatment of values by the latest SAP Connector as with v5.xx.
We very recently migrated a customer from a v5.80SR4/v5.90 SAP Connector combo to v6.5.1, and changed these parameters from their default values to:
(note that true corresponds to 1, true/false are the values that are generated by the Connection dialog, and the nice thing is that it generates explicit default values for all parameters which leaves nothing to chance).
Extensive comparisons and testing have shown that we were able to get full data format and value compatibility.
You probably found out about this already yourself, so I'm posting a confirmation for any other member facing this uncertainty