How to automate kick-starting a job

[Anonymous]

Here's my job

MSSQLInput-->tMap-->OutputExcel

Whenever there's any update or a new entry happened in the source table then the above job should kick start and send it to excel. Please suggest

[Anonymous]

Hello,

Could you please have a look at talend CDC feature, which has the ability to capture only the changed source data and to move it from a source to a target system(s) in real time.

For more information, please refer to online document about:TalendHelpCenter:Change Data Capture.

Let us know if it can meet your needs.

Best regards

Sabrina

[Anonymous]

Thanks Sabrina, i will go thru it and come back if i have any queries.

[Anonymous]

Is CDC a part of subscription edition? bcz i cant see it anywhere

[Anonymous · Accepted solution]

is it possible without CDC?

[Anonymous]

Hello,

Talend CDC feature will be available in talend subscription solution not open source.

With talend open studio, you have to compare your tables by manual to get the changed data and then load it into your target DB.

Best regards

Sabrina