ObjectDB ObjectDB

ObjectDB data migration/extraction

#1

Hi

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.

Thanks.

edit
delete
#2

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
edit
delete
#3

Thank you for help. JPA sounds good, 

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

Kind regards.

edit
delete

Reply

To post on this website please sign in.