Listening external event and triggering webservice

CloverDX Platform
1

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…:slight_smile:
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

2

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.

3

Thanks Dear,

You have shown me direction, now I can walk on to create a solution…

Regards
sandeep

4

Hi,

I need to turn off global security while using http API, can some one suggest as I want to send the request using a click button/hyperlink and don’t want to see the basic authentication for user.

Regards

Sandeep

5

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.