I want to store the status of a task i.e. success, warning or failure after it completes. This is use case:
Before the task starts, i store the task information in an oracle table - i call a bat file in preprocessing cmd which in turn calls a sql script to insert a record in table. Once the task finishes, i want to capture its status, success records, error records and update oracle table. I tried doing this through post process cmd command but cant figure out how to get this information. Is there some way i can capture this from Actvity Log? I read about REST API on the community but i being an ETL developer, i could not make much sense out of the docs
Can someone explain what it is, which language to code it in and are some sample scripts available for ActivityLog method?
You can develop the ETL mapping by use of PoweCenter to make the activityLog REST API calls. This PowerCenter mappings can be then leveraged or run in ICS as PowerCenter servcie or Plug-in.
Other option you have is by writing script to parse the ICS task logs for statuses.
Give this a try,
hope this helps.
HI Elias,Thanks for the link.
I downloaded the extract and performed all the steps mentioned in the document. i got an error while executing the bat file:
C:\a_IOD\ICSTaskRun>java -jar runajob.jar 000IGZ0I000000000004 tst_restapi DSS t
'java' is not recognized as an internal or external command,
operable program or batch file.
I have Java installed on my machine still got this error.
Let me know what all needs to be installed to run this bat file. I am keen on using REST Api.
Are you able to run "java" from your command line in general? Try something like "java -version". That will confirm if you have it in the PATH.
Hi rishita pandya,
The bellow link helps you more.
hope this helps.
Unable to view the pictures on the blog. Also, is the solution for Informatica on Cloud tasks or Informatica on Premise jobs?