Toracleinput does not send to_char, To_date values

Highlighted
Three Stars

Toracleinput does not send to_char, To_date values

Hi Talend Community,

 

I calcuted the utc time using the following query in oracle

 2019-12-11_21-58-12.png

I get the following desired result in the toracleinput preview:

2019-12-11_21-58-25.png

 

I configured the following schema for oracle( i dont send the stop_start_datetime/stop_end_datetime values)

2019-12-11_22-01-55.png

I configured the following schema for the tlogrow

2019-12-12_11-54-57.png

This is the result i get. As you can see the stop_start_utc/stop_end_utc. Doesnt get send.

 

2019-12-12_11-56-24.png

My question is: 

- Did i misconfigured the schema settings for toracleinput/tlogrow?

- Or is there something else im missing.

 

I used tlogrow as a test. For the endresult i would like to send those dates to a sql table (with the datetime datatype for the stop_start_utc/stop_end_utc)


Accepted Solutions
Forteen Stars

Re: Toracleinput does not send to_char, To_date values

@henkiiee02 , keep the columns machine id ,sku id ,time columns in select is returning and keep those only in the tDBInput schema and populate those into tLogRow.

 

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post


All Replies
Forteen Stars

Re: Toracleinput does not send to_char, To_date values

@henkiiee02 , keep the columns machine id ,sku id ,time columns in select is returning and keep those only in the tDBInput schema and populate those into tLogRow.

 

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog