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.
ObjectDB data migration/extraction
#1
peric.emil
#2
support
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
#3
peric.emil
Thank you for help. JPA sounds good,
we will try BIRT altough we have a dedicatet reporting system.
Kind regards.