Archive CMS data into an hadoop cluster

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • clemem
    Member
    • Apr 2014
    • 3

    Archive CMS data into an hadoop cluster

    We have a need to archive CMS data into an hadoop cluster. The import application connects through JDBC to the Avaya database and attempts to do some transaction isolation. The connection then fails because logging is not turned on for the CMS database. We would like to request that logging be turned on for the databases that we will being connecting to. Using this import application will give us a reliable way to import this data without having to add in extra layers of staging and importing into other methods before moving the data to hadoop.

    It isn’t clear to me why the connection is failing or how that is connected to logging. It is my understanding that JDBC applications normally are written to pull data from the Informix database. Although the factor that we have of adding in transaction isolation may be what causes the problem.

    In any case, issues like activating logging is more of an implementation issues and therefore I’m really not familiar with what would be needed to turn on logging.
  • shaikht
    Genius
    .
    • Feb 2010
    • 246

    #2
    Hi,

    If odbc connection is created properly, Informix database tables data can be retrieved.

    If still there is issue, I will suggest to open Service request with Avaya so that we can further look into the issue.

    Comment

    • clemem
      Member
      • Apr 2014
      • 3

      #3
      The connection is working properly. I did open a Service Request with Avaya. They came back with that Avaya will not be able to change the schema of the CMS DB. The reason being is CMS is rolled out in a standard deployment as a turn key solution, so in order to achieve best performance, certain parameters are not used or configured for CMS/IDS.

      Comment

      Loading