4

Perhaps this post major editing :

I work for company which sells services online. I would like to build some kind of software bridge/integration tool which would integrate our Oracle database with some sort of device.

We have screens showing live stata like number of items sold, how many are enquiring and similar kind of data. Now it is all fun for executives but I wanted to add extra staff to do.

So when a booking is made in the system and there is INSERT on the booking table new stats are appearing. But for example every 100 orders some sort of bulb lights on. 1000 - Phanfare.

I am not entirely sure what are possible ways of doing it with limited budget. So basically I am looking into software-to-hardware solution.

Any advice,links greatly appreciated.

fixer1234
  • 27,486
Jestem_z_Kozanowa
  • 153
  • 3
    Isn't this what triggers are for? To trigger an event... – Dave Sep 09 '13 at 15:30
  • 1
    Consider an Arduino- or Raspberry Pi-based solution, perhaps? – Aaron Miller Sep 09 '13 at 19:39
  • @DaveRook problem is not coding the trigger. Difficulty is linking it with some sort middle tier communication layer which then talk to something else. Essentially it needs to be three tier structure: DB, middle tier, hardware at the end. – Jestem_z_Kozanowa Sep 11 '13 at 08:01
  • You may be able to call a function from a dll - http://docs.oracle.com/cd/B10501_01/appdev.920/a96590/adg11rtn.htm. – Dave Sep 11 '13 at 08:07

1 Answers1

1

You can look into products such as this. It's a light indicator that plugs into the USB port.

http://thingm.com/products/blink-1.html

You can find more similar items if you search for "usb light indictator" or something like that.

wisbucky
  • 3,076