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,
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"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<title>Object not found!</title>
<link rev="made" href="mailto:postmaster@localhost" />
<style type="text/css"><!--/*--><![CDATA[/*><!--*/
body { color: #000000; background-color: #FFFFFF; }
a:link { color: #0000CC; }
p, address {margin-left: 3em;}
span {font-size: smaller;}
/*]]>*/--></style>
</head>
<body>
<h1>Object not found!</h1>
<p>
The requested URL was not found on this server.
If you entered the URL manually please check your
spelling and try again.
</p>
<p>
If you think this is a server error, please contact
the <a href="mailto:postmaster@localhost">webmaster</a>.
</p>
<h2>Error 404</h2>
<address>
<a href="/">localhost</a><br />
<span>3/29/2012 1:30:03 PM<br />
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</span>
</address>
</body>
</html>
Please sign in to leave a comment.
Comments 2