2 Replies Latest reply: Jul 27, 2013 8:05 AM by Junaid Rehman RSS

    how to migrate jBASE env. to Oracle DB or NoSQL

    user604292
      Hello ...

      I have a customer running jBASE and thinking of moving him to use Oracle DB or NoSQL.

      anybody knows how to or specific direction?

      Thanks,
      Sam
        • 1. Re: how to migrate jBASE env. to Oracle DB or NoSQL
          Kgronau-Oracle
          Regarding NoSQL you'd better repost a similar question in the NoSQL forum: NoSQL Database

          Regarding an Oracle RDBMS there's no migration utility that assist you with the migration from JBase to Oracle. But if there's an ODBC driver you might think about using Database Gateway for ODBC which allows you to link from an Oracle database to JBase and gather the source data from JBase into the Oracle database. Another option would be to unload the JBase data into plain text files and load the content into the Oracle database using SQL*Loader.
          • 2. Re: how to migrate jBASE env. to Oracle DB or NoSQL
            Junaid Rehman

            Hi Sam,

             

            Temenos will do the migration. Moving to Oracle DB or any other relational database does not mean that JBASE will be eliminated.

            T24 will still write, read, update and delete the jBASE tables, however a driver will translate these operations to Oracle.

            For example, a write operation will be performed to the jBASE table, the driver will take over, translate the jBASE record to XML and then write the XML string to an Oracle table.

            A read operation will be performed from T24 to jBASE which in turn will go to Oracle, read the record, the result XML will be translated to jBASE format and sent to T24.

            Regards,

            Junaid UR Rehman