Creating Database objects using ETL

[ShastriV]

I have a requirement to create Database Objects (Stored Procedures,Views etc) reading the SQL from a specific path in both MS SQL and oracle. Does Talend support this type of process? Can any one help me out with this?

Appreciate your Quick Response.

Thanks.

[Anonymous]

Hi,

    Could you please try tMSSQLRow and tOracleRow components for MSSQL and Oracle respectively? Below links will provide details for both components.

https://help.talend.com/reader/JVMPG~OQSVk01lsFQd1O_A/JKjMgpw7C4ogQEBaApl7_g

https://help.talend.com/reader/lZLCVAvlC2eua7~d4oeP4w/pe7BmJyq2GakfT2J6_W3jg

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved