Forum Discussion

eleonb's avatar
eleonb
Frequent Visitor
8 months ago

Copy data Oracle Timezone Issue

Context / Background We are using Fabric to copy data from an internal Oracle database via an On-Premises Data Gateway. The Oracle database has TZFILE version 14 (timezlrg_14.dat). I do not have th...
data engineering
Data Pipeline
v-echaithra's avatar
v-echaithra
Community Support
7 months ago

Hi eleonb ,

Thank you for sharing the detailed findings and for taking the time to thoroughly investigate this behavior. As this is a current limitation of the OracleV2 connector used by Fabric Copy Data activities, which does not support pre-copy scripts, custom ODP.NET configurations, or external Oracle client settings on the gateway. We appreciate you clearly outlining the differences in behavior between Dataflows and Pipelines, as this information will be valuable for other customers encountering similar scenarios. We recommend submitting this as a feature request here  Fabric Ideas - Microsoft Fabric Community  so the product team can evaluate support for enhanced timezone handling in future updates.

Best Regards,
Chaithra E.