https://community.qlik.com/t5/Connectivity-Data-Prep/SAP-SQL-Connector-returns-String-instead-of-numbers-after/m-p/2485773#M14214 <P>Problem found!&nbsp;</P> <P>We had created new connection strings to connect to SAP and intially MixedMode is FALSE, but we need TRUE to get numbers instead of strings.</P> Tue, 08 Oct 2024 06:59:12 GMT carolinnolte 2024-10-08T06:59:12Z https://community.qlik.com/t5/Connectivity-Data-Prep/SAP-SQL-Connector-returns-String-instead-of-numbers-after/m-p/2485549#M14209 <P>Hi,</P> <P>we just upgraded our QlikView system from May2023SR1 to May2024IR and Qlik SAP Connector from 8.0.2 to 8.0.3.</P> <P>Now we noticed a lot of problems, which all are related to the returned data formats. Instead of returning numbers as with SAP Connector 8.0.2, we now get Strings.&nbsp;</P> <P>How does this make sense, especially when reading the release notes?</P> <P><SPAN>Jira issue ID: QB-22169</SPAN><BR /><SPAN>There was an issue with some conversion routines not being carried out during the extraction jobs for some fields, resulting in incorrect formatting of data. This was updated in both SQL and BW connectors&nbsp;</SPAN><STRONG>(8.0.3)</STRONG><SPAN>.</SPAN></P> <P>&nbsp;</P> <P><SPAN>How can we resolve this without modifying all Load Skripts?&nbsp;</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 07 Oct 2024 08:56:35 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/SAP-SQL-Connector-returns-String-instead-of-numbers-after/m-p/2485549#M14209 carolinnolte 2024-10-07T08:56:35Z https://community.qlik.com/t5/Connectivity-Data-Prep/SAP-SQL-Connector-returns-String-instead-of-numbers-after/m-p/2485773#M14214 <P>Problem found!&nbsp;</P> <P>We had created new connection strings to connect to SAP and intially MixedMode is FALSE, but we need TRUE to get numbers instead of strings.</P> Tue, 08 Oct 2024 06:59:12 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/SAP-SQL-Connector-returns-String-instead-of-numbers-after/m-p/2485773#M14214 carolinnolte 2024-10-08T06:59:12Z