• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

avaya supervisor and java

 
Ranch Hand
Posts: 81
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?
 
Sheriff
Posts: 22701
129
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 "jdbc:odbc:" 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for the help Rob, i ll try to implement and see what happens..
thanks again!
 
First, you drop a couch from the plane, THEN you surf it. Here, take this tiny ad with you:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic