Hello, I'm fairly new to Meltano, and I'm trying to install the target-oracle loader. I'm getting the following error

Using Python 3.11.14 environment at: .meltano\loaders\target-oracle\venv                                                                                                                                                                    │
│ Resolved 38 packages in 760ms                                                                                                                                                                                                               │
│    Building cx-oracle==8.3.0                                                                                                                                                                                                                │
│    Building pendulum==2.1.2                                                                                                                                                                                                                 │
│    Building target-oracle @ git+<https://github.com/radbrt/target-oracle.git@fdcb6e3e4327b39ba81974da708b08596d2c4a22>                                                                                                                        │
│   × Failed to build `cx-oracle==8.3.0`                                                                                                                                                                                                      │
│   ├─▶ The build backend returned an error                                                                                                                                                                                                   │
│   ╰─▶ Call to `setuptools.build_meta.build_wheel` failed (exit code: 1)                                                                                                                                                                     │
│                                                                                                                                                                                                                                             │
│       [stderr]                                                                                                                                                                                                                              │
│       Traceback (most recent call last):                                                                                                                                                                                                    │
│         File "<string>", line 14, in <module>                                                                                                                                                                                               │
│         File                                                                                                                                                                                                                                │
│       "C:\Users\sashah\AppData\Local\uv\cache\builds-v0\.tmptdRGof\Lib\site-packages\setuptools\build_meta.py",                                                                                                                             │
│       line 333, in get_requires_for_build_wheel                                                                                                                                                                                             │
│           return self._get_build_requires(config_settings, requirements=[])                                                                                                                                                                 │
│                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                 │
│         File                                                                                                                                                                                                                                │
│       "C:\Users\sashah\AppData\Local\uv\cache\builds-v0\.tmptdRGof\Lib\site-packages\setuptools\build_meta.py",                                                                                                                             │
│       line 301, in _get_build_requires                                                                                                                                                                                                      │
│           self.run_setup()                                                                                                                                                                                                                  │
│         File                                                                                                                                                                                                                                │
│       "C:\Users\sashah\AppData\Local\uv\cache\builds-v0\.tmptdRGof\Lib\site-packages\setuptools\build_meta.py",                                                                                                                             │
│       line 317, in run_setup                                                                                                                                                                                                                │
│           exec(code, locals())                                                                                                                                                                                                              │
│         File "<string>", line 6, in <module>                                                                                                                                                                                                │
│       ModuleNotFoundError: No module named 'pkg_resources'                                                                                                                                                                                  │
│                                                                                                                                                                                                                                             │
│       hint: This error likely indicates that `cx-oracle@8.3.0` depends on                                                                                                                                                                   │
│       `pkg_resources`, but doesn't declare it as a build dependency. If                                                                                                                                                                     │
│       `cx-oracle` is a first-party package, consider adding `pkg_resources`                                                                                                                                                                 │
│       to its `build-system.requires`. Otherwise, either add it to your                                                                                                                                                                      │
│       `pyproject.toml` under:                                                                                                                                                                                                               │
│                                                                                                                                                                                                                                             │
│       [tool.uv.extra-build-dependencies]                                                                                                                                                                                                    │
│       cx-oracle = ["pkg_resources"]                                                                                                                                                                                                         │
│                                                                                                                                                                                                                                             │
│       or `uv pip install pkg_resources` into the environment and re-run with                                                                                                                                                                │
│       `--no-build-isolation`.                                                                                                                                                                                                               │
│   help: `cx-oracle` (v8.3.0) was included because `target-oracle` (v0.0.1)                                                                                                                                                                  │
│         depends on `cx-oracle`

I've made it so that I'm using

setuptools 81.0.0

rather then v82, which is where support for

pkg_resources

was dropped, but I'm still getting the same error. The steps I followed [from this post](https://meltano.slack.com/archives/C069C6Q96AF/p1770656514484639) did allow me to install target-s3, but they didn't work for target-oracle. Does anyone have any idea what else I could do to get this working?

Hi @Sasha Hegland! How does your

meltano.yml

look like?

Sorry for the late reply @Edgar Ramírez (Arch.dev)

meltano.yml

default_environment: dev
project_id: 019d735b-3924-7a16-906a-46c09f00b742
environments:
- name: dev
- name: staging
- name: prod
env:
  UV_OVERRIDE: ./overrides.txt
plugins:
  extractors:
  - name: tap-rest-api-msdk
    variant: widen
    pip_url: tap-rest-api-msdk setuptools<82 pip-system-certs
    config:
      ... this works and has info specific to my employer
  loaders:
  - name: target-oracle
    python: python3.11
    variant: radbrt
    pip_url: git+<https://github.com/radbrt/target-oracle.git>

I have tried putting setuptools<82 in the target's pip_url, it doesn't help.

pyproject.toml

...
[build-constraints]
meltano = { setuptools = "<82" }

and

overrides.txt

setuptools<82

Can you try

python3.10

instead? The

cx-oracle

package doesn't appear to have Python 3.11 wheels.

That worked! Thank you.