Direct Socket Connection in CloverETL

Hi All,

I would like to ask if it’s possible to establish a direct socket connection in CloverETL. If yes, what component to be used? I am doing an integration now with Fishbowl Inventory. I asked their development team, they said that Fishbowl is using socket connection and accepts XML calls to its API, and I have no idea how to set this up in my CloverETL graphs.

I would really appreciate if there’s someone who can help me with this. I’ve been working for this more than a week now.

Thanks,

Hi jed_urETLguy,

aren’t they using HTTP protocol? If yes, then you can use HttpConnector.

There is no support for direct socket connection in Clover. But you can consider:
* prepare/use existing commandline accessor utility (via SystemExecute)
* prepare own Clover component in Java

Hi,

Thanks much kubosj for replying to my previous queries. I really appreciate it. I have another question though.
I have some PHP codes here running in my XAMPP server. I use this PHP codes to call for Fishbowl’s API requests and get some responses. Running those codes, I was able to pull the data I need from Fishbowl’s server. I tried using HTTP Connector in Clover to get those data being returned by my codes from my localhost, however it’s not getting any data.

I have a sample URL below that I used to feed to my HTTP Connector component:

http://localhost/phpapi/exportProducts.php

Once again, the exportProducts.php , when this is run, this will send request to Fishbowl’s server and get the response, which is the data that I need to pull from my Clover, but it will return an error in Clover. The error looks like below:

<?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" ""> Object not found!

Object not found!

The requested URL was not found on this server.

If you entered the URL manually please check your
spelling and try again.

If you think this is a server error, please contact the webmaster.

Error 404

localhost

3/29/2012 1:30:03 PM

Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1