SAP Connector - Dates are Numeric

[tmumaw]

Hi all,

I just updated to 12.10 SR6 along with upgrading my SAP Connector.  I have run into  major issues all the dates now in my QVD's I build from SAP have a format of YYYY-MM-DD.  How can I change how the connector stores the dates in my QVD's?  I need a format of MM/DD/YYYY and I don' t want to change all my extracts.  Must be a setting on the connect string but where?

Thanks

[Peter_Cammaert]

The SAP Connector comes in many versions, each with their own particularities.

From which version to which version did you mgrate?

[tmumaw]

Old SAP connector: 5.7

New SAP connector: 6.4

[Peter_Cammaert]

Inbetween we had SAP Connector v6.1 that introduced considerable data processing changes. Luckily, that release also introduced additional options to configure "legacy"-style data processing in the SAP Connector. Maybe those can solve your conversion problem.

Do a test with the extraction of a single SAP table with (multiple) date fields and configure legacy mode in the connection string. Then check the resulting QVD to see in what format they are stored.

Useful discussion about a similar issue: SAP Field interpretation as in Version 5.x

[tmumaw]

Thanks Peter.  One of my co-workers found that same thread.  Sounds like what all of my issues are.  Testing it out right now.  

[micheledenardi]

I don't think the legacy data processing can solve your problem.

Check this page for all connection parameters:

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.4/QV-connection/SAP-...

In your case I think you must change your extractors by insert date(SAP_FIELD,'MM/DD/YYYY') as SAP_FIELD during the extraction.