File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes avaya supervisor and java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "avaya supervisor and java" Watch "avaya supervisor and java" New topic

avaya supervisor and java

prakash chauhan
Ranch Hand

Joined: Jun 22, 2007
Posts: 81
hi all,
i am going to work on a project which is struts based
What i am required is to pull up the data from Avaya CMS and post the result in my website , i ll be using MySql server as my database
I am really lost , dont know where to start from i have got my database ready and my site is pulling up data from the database but it database is updated manually using excel files... i want to automate this process , what do i need to do/learn ?
Rob Spoor

Joined: Oct 27, 2005
Posts: 20276

Avaya CMS uses an OpenLink database, so you'd need to find a Java driver for that database.

We use CMS at my job too, and we have installed the OpenLink ODBC drivers on the database (SQL Server 2005) servers, then use an ODBC link to copy data from the CMS database through SSIS packages. The main thing these SSIS packages do is just copy all data from the previous day to the SQL database, after which we use that copied data to update other tables.

So you could do the same - install the ODBC drivers, then use that with the default ODBC JDBC link (driver class "sun.jdbc.odbc.JdbcOdbcDriver", connection string "jdbcdbc:" followed by the ODBC name) to do anything else you need.
[ November 23, 2007: Message edited by: Rob Prime ]

How To Ask Questions How To Answer Questions
prakash chauhan
Ranch Hand

Joined: Jun 22, 2007
Posts: 81
Thanks for the help Rob, i ll try to implement and see what happens..
thanks again!
I agree. Here's the link:
subject: avaya supervisor and java
It's not a secret anymore!