We are doing CDC extract from AS400 and running the below command
ftp>user <user_name> *********
230 <user_name> logged on.
250 "CDC_DIR" is current library.
ftp>quote rcmd "CDC_DIR/RUNCDC FILE(Sub/table) LIBOUT(CDC_DIR) MODE(*DETACHED) MBROPT(*ADD)"
This command is using ftp utlitity to run the CDC command. But our server is not ftp enabled. Can we run the same command using sftp utility?
Usually, it is automatically executed via FTP by the Studio to install the RUNCDC program, restore the CDC library (the CDC database) and create the TSUBSCRIBERS table.
Do you want to manually call the RUNCDC program by yourself to write changes to the CDC table and use sftp utlitity instead?
Thanks for your reply. FTP is not enabled between job server and AS400. Waiting for SFTP access between those servers. Once it is provided I am planning to use tSSH component to check on this.
Expecting this will work.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.