Description

This is a simple daemon written in Perl to pump text messages from SQL server to Jabber.
It is intended for distributing database system mesages in a mid-to-large sized company.
It was written primarily for MSSQL7, but any other SQL server would do.

Assumptions

MS SQL server is running ( in native or domain auth mode )
Jabber server is running, and database users have clients installed.
You have an enterprise wide database system which wants to notify users about various events
Your business app doesn't have such functionality

Requirements

Perl and some non-standard modules:

DBD::Sybase
Jabber::Connection
HTML::Entities
XML::Simple
HTML::Entities
Net::LDAP (optional)

DBD::Sybase mini-howto

download FreeTDS from http://www.freetds.org/, compile, install
configure FreTDS and verify it is working with tsql
point SYBASE environmemt variable to FreeTDS location
install DBD::Sybase