Creating Database objects using ETL

ShastriV — Sat, 16 Nov 2024 04:04:54 GMT

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.

Re: Creating Database objects using ETL

Anonymous — Tue, 19 Nov 2019 17:07:45 GMT

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

topic Re: Creating Database objects using ETL in Talend Studio

Creating Database objects using ETL

Re: Creating Database objects using ETL