Hi all,
Firstly, I would like to introduce my self as a fresher in the clover ETL, so really excuse me as might be my question appear dumb to some of you..:)
I am working on a clover ETL based project having following components
1) A web application
2) An Oracle database
3) Clover ETL
My question is as:-
Whenever a button is clicked on a web GUI, Oracle database table is updated in back-end and results are displayed on Web GUI. I want to listen to event using clover server/etl on web GUI (like click of button) or if updated is made available on web-service, i should be able to feed that data to other database.
What I did till Now:-
I created a job scheduler which checks the database every one minute and data is synched and fed to other database.
But my team want to use an event based (like button click) rather than a scheduling alternative.
Need your suggestion how to achieve the event based listening in clover etl (may be web service listener) or any other approach.
I tried to explain my question with best of mine knowledge, still it might be confusing, please let me know...
Thanks in advance!!!
Regards
Sandeep
Firstly, I would like to introduce my self as a fresher in the clover ETL, so really excuse me as might be my question appear dumb to some of you..:)
I am working on a clover ETL based project having following components
1) A web application
2) An Oracle database
3) Clover ETL
My question is as:-
Whenever a button is clicked on a web GUI, Oracle database table is updated in back-end and results are displayed on Web GUI. I want to listen to event using clover server/etl on web GUI (like click of button) or if updated is made available on web-service, i should be able to feed that data to other database.
What I did till Now:-
I created a job scheduler which checks the database every one minute and data is synched and fed to other database.
But my team want to use an event based (like button click) rather than a scheduling alternative.
Need your suggestion how to achieve the event based listening in clover etl (may be web service listener) or any other approach.
I tried to explain my question with best of mine knowledge, still it might be confusing, please let me know...
Thanks in advance!!!
Regards
Sandeep
-
Hi Sandeep,
I would recommend to invoke CloverETL Server graph/jobflow using HTTP (possibly Ajax based on click event) and:
* http://doc.cloveretl.com/documentation/ ... p-api.html
* http://doc.cloveretl.com/documentation/ ... rvice.html
* http://doc.cloveretl.com/documentation/ ... ap-ws.html
If you like JMS there is also alternative:
* http://doc.cloveretl.com/documentation/ ... eners.html
All of them would suite your needs.
I hope this helps. -
Hi Sandeep,
Please take a look on "security.basic_authentication.features_list" setting of Server http://server-demo-ec2.cloveretl.com/cl ... rties.html
Probably better possibility than exposing Server's interface without any password protection would be to build proxy service outside Server which would handle this kind of request and proxied them to Server with credentials.
I hope this helps.
Please sign in to leave a comment.
Comments 4