# Direct Socket Connection in CloverETL

**URL:** https://forum.cloverdx.com/t/direct-socket-connection-in-cloveretl/1035
**Category:** CloverDX Platform
**Created:** [March 24, 2012, 12:00am UTC](https://forum.cloverdx.com/t/direct-socket-connection-in-cloveretl/1035 "2012-03-24T00:00:00Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jed\_uretlguy](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@jed\_uretlguy](https://forum.cloverdx.com/u/jed_uretlguy)
#### Post date: [March 24, 2012, 12:00am UTC](https://forum.cloverdx.com/t/direct-socket-connection-in-cloveretl/1035/1 "2012-03-24T00:00:00Z")

</div>

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,

---

<div class="post-metadata">

### Author: ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)
#### Post date: [March 27, 2012, 8:30am UTC](https://forum.cloverdx.com/t/direct-socket-connection-in-cloveretl/1035/2 "2012-03-27T08:30:26Z")

</div>

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

---

<div class="post-metadata">

### Author: ![jed\_uretlguy](https://avatars.discourse-cdn.com/v4/letter/j/f0a364/32.png) [@jed\_uretlguy](https://forum.cloverdx.com/u/jed_uretlguy)
#### Post date: [March 29, 2012, 4:26am UTC](https://forum.cloverdx.com/t/direct-socket-connection-in-cloveretl/1035/3 "2012-03-29T04:26:27Z")

</div>

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](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](mailto:postmaster@localhost).

## 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
