MS SQL - webMethods - TERADATA


I have functionality to be fullfilled where webmethods needs to read the new tables created in MS SQL application database, export the DDL from it and create the replica tables in targe teradata database …

Is this possible by using webMethods ? :

And Can we assign webMethods trigger polling to a table where the table name will be passed to trigger as a run- time value.

am not sure is this fuctionality can be achieved in real-time scenario.

Please share me if any one have idea on solutioning

Thanks ain advance!!