Fork me on GitHub
#sql
<
2021-04-25
>
seancorfield20:04:58

@henrikheine This would be a good channel to ask questions about ETL and migration, if you're talking about databases. I saw you ask about the topic in #data-oriented-programming

henrik4206:04:36

@seancorfield thx for inviting me. So what I'm looking for are libs/apps that help me do a migration of a database belonging to an old legacy app into a new database of our new app. I believe I need some way to explore and browse both. Someone suggested metabase. And then I would have to do ETL stuff and the transformation would have to go through some business logic (java). I'd be comfortable with just using next.jdbc and putting processing steps into go blocks. But maybe someone could suggest other ideas? I'm having a hard time finding posts on ETL and clojure eventhough I believe that would be a perfect match. So any hints are very much appreciated.

henrik4206:04:36

@seancorfield thx for inviting me. So what I'm looking for are libs/apps that help me do a migration of a database belonging to an old legacy app into a new database of our new app. I believe I need some way to explore and browse both. Someone suggested metabase. And then I would have to do ETL stuff and the transformation would have to go through some business logic (java). I'd be comfortable with just using next.jdbc and putting processing steps into go blocks. But maybe someone could suggest other ideas? I'm having a hard time finding posts on ETL and clojure eventhough I believe that would be a perfect match. So any hints are very much appreciated.