Data Lake date Format

DustinHughes
DustinHughes Member, Infor Partner Posts: 2
in Data Fabric

Using the ETL tool, I must extract data published to the Data Lake from Infor IPS. I have done this before with some other Infor LN clients, and it works great.

However, I'm getting a date format error for this IPS client.

image.png

If I look at the IPS data in Atlas it is in hours offset format.

image.png

If I look at the lake for another Infor LN customer where the ETL works without intervention, the date is in timezone format.

image.png

I can work around this issue by changing the format of every date fiel,d but I need to extract 149 tables!

Has Infor IPS pushed the date through incorrectly?

Categories