[tMSSqlSCD] Change DB Type of SCD_Start to DATETIMEOFFSET

[Frank81]

Hi all,

I'm using the talend SCD component for masterdata historization. As the database should support different timezones, we have designed all time data colums as datetimeoffset, so we can harmonize all time dependant data.

When I use the talend SCD Component with SCD Type 2 fields the scd_start and scd_end timestamps are inserted into the database without the time offset. I changed the component to a tDBMSSqlOutput and inserted the identical rows into the table. With that component the timeoffset is properly inserted into the db.

I already changed the jdbc driver from jdts to native microsoft but the behaviour is identical.

Is there a possibility to change the DB Data Type within the SCD Component to DateTimeOffset?

I'm using Talend Studio 7.2.1, MSSQL Server Version 2014.

Any help or hints are highly appreciated

[manodwhb]

@Frank81 , use sysdatetimeoffset() in Adanced settings>>Additional JDBC Parameters in tMSSqlSCD .