I am new to this forum, so not sure what is the proper project. Just wondering if there is a way via Jaspersoft to send just a HQL Query from SQL Server (hql queries will be stored in the table on SQL Server) to HIVE for processing, process it on HIVE (and store output in HDFS) and once its completed, just send notification on completion back to SQL Server.
You're probably talking about Jaspersoft ETL. This is just Talend Open Studio.
Not sure if the current version of Jaspersoft ETL has tSqoopImport component.