Hi all,We want to get the timezone information from an oracle "timestamp with timezone" column and store that in a separate, additional column in the target. To get the timezone in plain sql on Oracle we would do:to_char(my_timestamp_w_tz_col, 'TZR')...
Hello team, I may need to replicate Array datatype column from Postgress to Snowflake Was unable to figure out exact options.Source column : field1 text[] COLLATE pg_catalog."default",Once Source table is added to Channel datatype of array column go...
Is anyone using HVA and/or HVR with Oracle EBS 12.2? We have HVA connected our Oracle EBS 12.1.3 production ERP system. Since HVA can't directly sync data from views, we are syncing the base tables in the Oracle 19C database that supports our EBS app...
Users of of the HVR technology have to manage their own HVR installation. When you start using HVR 6, or you migrate from version 5 to 6, you may wonder: how do I size my HVR hub server. The HVR documentation provides high-level guidelines. In this p...
This post only applies to the use of the Fivetran HVR technology. HVR provides two integration method: Continuous: with the continuous method changes are processed row-by-row in the order the changes were committed on the source.Burst: with the use o...