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!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.
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