Found a good tradeoff to integrate SQLite databases
Hi,
sometimes ago I posted a question about integrating SQLite database in ODI an ODQ. SQLite is commonly used in many tools for PDA and also in many other places (sometimes with a different file extension, but it simple to detect the true content).
This because is a single file db as Access but is free with all can be needed for small but sophisticated apps.
I received a post about duplicate another technology and customize that. It could a solution if no other solution could work, being time expensive.
I found a better solution: DBconvert for SQLite and MySQL (http://www.dbconvert.com/) . It support:
- full schema recreation / update on the target (in this case we are interested to go towards MySQL) with PK FK etc.
- any number of sessions (named job to run different tasks)
- run from command line with any external scheduler or with an internal scheduler set from the gui
All this at 79 $, so we could take care of the information business while it makes the loading.
When data are in a MySQL database they will be reachable with all the full supported ODI components for MySQL.
Hope this could be useful to others.
Thanks
Fabio D'Alfonso
http://www.fabiodalfonso.com