shuttle-hq / synth

The Declarative Data Generator
https://www.getsynth.com/
Apache License 2.0
1.36k stars 104 forks source link

Synth integration with Oracle #410

Open pauldewaal-disy opened 1 year ago

pauldewaal-disy commented 1 year ago

Required Functionality I love you work and the build-in integration with Postgres! It would be awesome if the database integrations could be extended with Oracle support.

Proposed Solution Out-of-the box Oracle support for import & generation of data. Comparable to existing Postgres integration.

Use case I am doing a lot of consulting projects, so I can't always choose my favourite DB, it has to fit an existing client environment. Oracle is very common DB in public-private sector in Germany.

iamwacko commented 1 year ago

SQLx, which we use to connect to databases, doesn't support Oracle. Besides that, connecting with Oracle requires installing the Oracle client libraries, meaning that Oracle support wouldn't work out of the box.