Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

avaya supervisor and java

 
prakash chauhan
Ranch Hand
Posts: 81
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
prakash chauhan
Ranch Hand
Posts: 81
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the help Rob, i ll try to implement and see what happens..
thanks again!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic