ObjectDB data migration/extraction



What is the way to extract data from ObjectDB to relational databases (Oracle). We need to feed an Oracle database with data for reporting/datawarehosing.

Should JPQL be used or is there some tools to do it.



Currently there is no such tool, so you will have to migrate data using your own code.

Notice that you should be able to use ObjectDB with BIRT to produce reports directly with no need to migrate data.

You may consider using JPA in order to migrate data between ObjectDB and Oracle. By using a JPA implementation to access your Oracle server, you may retrieve entity objects from the source database and then persist them to the destination database.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)

Thank you for help. JPA sounds good, 

we will try BIRT altough we have a dedicatet reporting system.

Kind regards.

Post Reply

To post a reply and/or subscribe to update notifications - please login