Does activiti support hadoop tools like pig, hive, hbase? We are searching for other orchestration tools like oozie. Inputs would be helpful.
What do you mean by "support"?
Activiti is just a jar file and can be included in pretty much any project.
While the system (process state) database is restricted to those documented, there is nothing to stop you accessing noSQL data from within a process using a listener or service task.
Retrieving data ...