Member since
03-18-2025
2
Posts
0
Kudos Received
0
Solutions
05-15-2025
06:46 AM
Maybe you can try another tool, for example, ODBC driver? For me, it works.
... View more
03-18-2025
07:47 AM
The issue may be due to NiFi's PutDatabaseProcessor applying a local time zone conversion during data ingestion, causing the 5-hour shift. To fix this, ensure NiFi is explicitly set to handle UTC time zones for both reading and writing. Additionally, using ODBC for PostgreSQL could help by providing better control over time zone handling during the data transfer, ensuring consistency between MSSQL and PostgreSQL.
... View more