Xstream CDC : Write LCR Object to a flat file

Four Stars

Xstream CDC : Write LCR Object to a flat file

I was able to configure Xstream on my oracle database and created a Data Integration job using talend studio to connect to the out stream. The job was able to get the LCR (Logical Change Record) object and I was able to print in the system out log using the tLogRow node. But I am trying to write the LCR Object to a flat file. I tried writing to the file using tFileOutputDelimited, but the LCR record is not being written to the file. Any help is highly appreciated. 

Moderator

Re: Xstream CDC : Write LCR Object to a flat file

Hello,

The message printed by tLogRow component? If so, you can use tFileOutputDelimited instead of tLogRow to output the result into file.

Do you have trouble to write the LCR Object into DB directly?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Xstream CDC : Write LCR Object to a flat file

Yes. The LCR is printed to the sysout log using tLogRow. I tried using the tFileDelimited node to write to a file but for some reason it does not write the LCR to the file. I don’t want to write to the target database directly.
Moderator

Re: Xstream CDC : Write LCR Object to a flat file

Hello,

Would you mind posting your current job setting screenshot on forum which will be helpful for us to address your issue quickly.

Thanks for your time.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Xstream CDC : Write LCR Object to a flat file

Yes. Sure. Below are the job settings.

 

image.pngimage.pngimage.png

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download