Hey Vishnu -
So - IMHO - I would highly caution using the term "eliminating" - ETL tools have there place and are more structured along the lines including orchestration and workflow - usually all done with a slick GUI. Qlik's has "ETL" capabilities, but I use the term loosely - as it greatly depends on the solution. You can use Qlik script to perform programmatic like functions to transform and augment data and write out . QVD files (in-memory representation on disk) - but writing back to the DB is not technically what it was designed to do. I am not saying it cannot be done, but there are better ways to achieve what you are looking for. If you want to continue this discussion let us know and we will do our best to assist.
If you are looking to cut costs, you may want to look at Pentaho Data Integration or the open source project it is based on Kettle - I worked for Pentaho for 5 years - and for a free ETL tool - it is quite amazing what it can do. There is a licensed or subscription based enterprise version as well.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Thanks for the honest answer. I have loosely worded my post. But in all reality, IT has some intrinsic red tape and they never "eliminate" a tool. Pardon me for inaccurate statements. (I have corrected my above post.)
IT's just interested in knowing if there are any Qlik 3rd party tools that can do a writeback to DB. Please let me know if you come across such tools now or in the future.
Is storing in a QVX file any better than QVD? (Probably a seperate thread)
- thanks Vishnu - always need to be a bit politically correct when it comes to IT and their toys!
So output to QVX is the open format used by partners / 3rd party tools - take a look at this post for more info:
Most of us are aware that neither Qlik nor any other BI tool is designed to handle writeback. It is not even ideal as such functionality undermines data integrity. However, out of passion for your tool, many clients want to use Qlik as workflow tool. I have similar requests from Qlik clients whom I support. In my case, end users will trigger the writeback.