Qlik SAP SQL Connector: Date format issue after moving to 6.1.2 release or later

[Andre_Sostizzo]

Symptoms:

• DATS (or the Date data type) has changed from YYYY-MM-DD to Numeric (Integer) when stored in the QVD
• The behavior was experienced after moving from Qlik SAP Connector 5.80 SR x to Qlik SAP Connector 6.1.2 release or later
• Due to this change, extraction fails as it is expecting to have the YYYY-MM-DD
• Looking at the stored QVD in 5.80 SR 2 for example, the date field looks like this:
  
  
• However, looking at the stored QVD in 6.1.2 release or later, the date field looks like this:
  
  

 Legacy Qlik SAP Connector uses the format YYYY-MM-DD however, this has been changed on 6.1.2 of page 2 of the Release Notes. Due to this change, Qlik advises customers to start planning to move away from the NulldateLegacy but rather conform to the Numeric format stored in the QVD.

Environment:

Qlik SAP Connectors 

Resolution:

NOTE: It is important to remember that Qlik recommends not to use the NulldateLegacy for new development moving forward (see the Qlik SAP Connector 6.3.2 Release Notes on page 2 for further information)

The two parameters Nulldate and NulldateLegacy has to be changed to support legacy mode on the DATS date field to continue to store in YYYY-MM-DD format. Below must be changed in the SAP SQL Connector connection string:

• Nulldate=false
• NulldateLegacy=true