Which connector has internal scheduling option on Table Row?

Which connector has internal scheduling option on Table Row?

• A. File
• B. FTP
• C. SFTP
• D. Database

Answer: (D)

Polling a table on a schedule is a built-in capability of the Database connector. This connector is designed to retrieve rows from a database table at defined intervals, treating each row as a message to be processed downstream. The scheduling is managed internally by the connector as part of its polling configuration, making it ideal for table-row data flows that must be retrieved regularly. File, FTP, and SFTP connectors handle files rather than database rows. They don’t provide an intrinsic “table row” scheduling mechanism because there is no table concept to poll in those sources. They can be triggered by a scheduler or poll a directory for new files, but that’s not the same as scheduling reads from a database table row. So for a scenario involving internal scheduling on a table row, the Database connector is the best fit.

Polling a table on a schedule is a built-in capability of the Database connector. This connector is designed to retrieve rows from a database table at defined intervals, treating each row as a message to be processed downstream. The scheduling is managed internally by the connector as part of its polling configuration, making it ideal for table-row data flows that must be retrieved regularly.

File, FTP, and SFTP connectors handle files rather than database rows. They don’t provide an intrinsic “table row” scheduling mechanism because there is no table concept to poll in those sources. They can be triggered by a scheduler or poll a directory for new files, but that’s not the same as scheduling reads from a database table row.

So for a scenario involving internal scheduling on a table row, the Database connector is the best fit.