Topic: Change Write Datastore
Change Write Datastore
I have been making some examples to evaluate the product. Everything works fine, but when I want to export the results of the transformations, to a data writer ("Write data"), the Write to Datastore transformation only export to "db" files in the datastore folder. My question is, How can I export this results to a Oracle database insted of h2.db files?
Regards,
Francisco Yu
Regards,
Francisco Yu
Hi Francisco,
We still have that feature as an item in our backlog, so currently it is not there. But I think you will see it in one of the next releases...
In the mean time, you can do two things:
1) Export to a CSV file instead and load the CSV file into your Oracle DB. I'm sure Oracle has a small tool or a SQL statement or loading a CSV file, because that is quite ordinary.
2) You can also look if there's a tool for moving data from the embedded H2 database (which is saving it's data as .db files) into your Oracle DB.
I hope this gives you a few useful ideas.
We still have that feature as an item in our backlog, so currently it is not there. But I think you will see it in one of the next releases...
In the mean time, you can do two things:
1) Export to a CSV file instead and load the CSV file into your Oracle DB. I'm sure Oracle has a small tool or a SQL statement or loading a CSV file, because that is quite ordinary.
2) You can also look if there's a tool for moving data from the embedded H2 database (which is saving it's data as .db files) into your Oracle DB.
I hope this gives you a few useful ideas.
Log in by clicking the login link at the top of the screen
Go back to forum.
