topic Re: SAP Connector - Dates are Numeric in QlikView

SAP Connector - Dates are Numeric

tmumaw — Sun, 18 Mar 2018 19:20:52 GMT

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

Re: SAP Connector - Dates are Numeric

Peter_Cammaert — Mon, 19 Mar 2018 13:12:38 GMT

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

From which version to which version did you mgrate?

Re: SAP Connector - Dates are Numeric

tmumaw — Mon, 19 Mar 2018 13:20:27 GMT

Old SAP connector: 5.7

New SAP connector: 6.4

Re: SAP Connector - Dates are Numeric

Peter_Cammaert — Mon, 19 Mar 2018 14:31:21 GMT

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

Re: SAP Connector - Dates are Numeric

tmumaw — Mon, 19 Mar 2018 14:33:58 GMT

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

Re: SAP Connector - Dates are Numeric

micheledenardi — Mon, 19 Mar 2018 15:07:33 GMT

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-SQL-connection.htm

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