File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "avaya supervisor and java" Watch "avaya supervisor and java" New topic
Author

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
Sheriff

Joined: Oct 27, 2005
Posts: 19655
    
  18

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 ]

SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
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: http://aspose.com/file-tools
 
subject: avaya supervisor and java
 
Similar Threads
Connect realphone J2ME program to PC localhost database vie TCP connection.
how to embedd Fusion Charts with XML files in Struts? Please help me........its urgent
bean:write datetime
formatting output columns
creating db2 datasource