redpanda-data
Support oracle db in sql components
Hey @cdz99, it'd need a bit of investigation as we'd need to open up support and ideally also add some sort of integration testing, but in theory it might be a relatively small task.
Hi, @Jeffail . We have a need for this Oracle DB functionality as well. We could use Oracle SQLcl with the subprocess processor to pass a script and get the results back. Need to test the feasibility of that approach. Ideally, there is just another option in the SQL processor Oracle.
Is this type of driver compatible with the ethos of Benthos? https://github.com/godror/godror
We might want to look at https://github.com/sijms/go-ora too, since it doesn't rely on CGo. The annoying part is adding integration tests for this, since Oracle refuses to publish prebuilt Docker images of their database engine for some reason. The only official way to get a Docker image seems to require building it from scratch: https://github.com/oracle/docker-images/blob/main/OracleDatabase/SingleInstance/README.md
LE: There seems to be a container on quay.io that's maintained by a 3rd party: https://github.com/MaksymBilenko/docker-oracle-12c. Not sure if we should rely on it, though.
LE2: This might be a better-maintained container: https://hub.docker.com/r/gvenzl/oracle-xe -> https://github.com/gvenzl/oci-oracle-xe
