Infor CRM Date Offsets With Starfish ETL

Infor CRM Date Offsets With Starfish ETL

Infor CRM Date Offset

We recently ran into an issue in our Starfish ETL data integrations between a back-end ERP system and Infor CRM. We noticed that Date/Time fields were imported successfully via the OLEDB provider but displayed incorrectly inside the CRM application.

Infor CRM was doing the GMT adjustment to the Date/Time field correctly, so the problem could not be traced to faulty CRM functionality. Instead, this meant the initial data must have been incorrect.

This is what we expect to see, ideally:

  1. Date/Time supplied to Infor CRM is 01/01/2020 00:00
  2. Infor CRM saves this as 01/01/2020 06:00 AM (adjusted to GMT)
  3. Then when displaying information, Infor CRM re-adjusts the time to the original time zone and subtracts 6 hours (for Central Time) to show it as 01/01/2020
  4. We found that step #2 was not happening. After troubleshooting further, we found we could solve the issue if the supplied query was a parameterized one versus what we were using (non-parameterized).

    So the solution was to have Starfish ETL supply the update queries in a parameterized form, which can be accomplished by setting the UseParamQueries to True in the Web.Config file.

    Once this change was made, everything worked perfectly!

Allen is a senior CRM consultant at Technology Advisors Inc. He spends most of his time designing solutions using InforCRM, StarfishETL, and SQLServer. He also specializes in data migrations from-and-to Microsoft Dynamics CRM and Allen has been involved in large implementations for prominent players in the real estate, telecom, manufacturing, and publishing industries. Prior to working at Technology Advisors, Allen worked as a Microsoft application developer in the Accounting space. Outside of work, he likes to meditate, play his guitar, and eat chocolate.