How to call a stored procedure from Informatica cloud data integration?

0
votes

I am new learner in Informatica cloud data integration. Currently I am trying to convert SSIS ETL to Informatica.

While conversion, at one point I need to call a SQL Server stored procedure inside Informatica data integration which mainly update some data in tables. I tried many things but not getting success.

Can anyone have any idea how we can call a SQL Server stored procedure using informatica cloud data integration?

2
informaticainformatica-powercenterinformatica-cloud
you should use sql transformation and then call the procedure from there - yoga
This sql transformation available in informatica cloud data integration? - NP007
see here: network.informatica.com/videos/1213 - yoga

2 Answers

1
votes

Please use the SQL transformation.

refer to the following link : network.informatica.com/videos/1213

Accept this as the right answer if it helped you. This will help people in future

0
votes

You need to use a pre- or post processing script and call it from the native system as part of an integration. If this is for Application Integration then call as a command (and enable commands).

HTH

Scott S Nelson