#2237 Add tap-oracle-godzilla extractor Pull request opened by Hamza-Bouali Add tap-oracle-godzilla extractor Description This PR adds tap-oracle-godzilla, a modern Singer tap for Oracle databases built with the Meltano Singer SDK and the latest oracledb Python driver. Features • ✅ Modern oracledb driver (2.0+) - thin and thick mode support • ✅ SQLAlchemy 2.0+ - auto-discovery with type mapping for Oracle-specific types • ✅ Python 3.10–3.14 - full compatibility with modern Python versions • ✅ Service name & SID support - flexible Oracle connection options • ✅ Schema & table filtering - optimize discovery performance • ✅ Incremental replication - efficient data sync with state management • ✅ Complete Singer capabilities - catalog, discover, state, about Why Add This? The existing

pipelinewise-tap-oracle

(s7clarke10 variant) relies on the legacy cx_Oracle driver and is no longer actively maintained. This modern implementation: • Uses the actively maintained

oracledb

driver (modern, performant) • Supports latest SQLAlchemy and Python versions • Built on the Singer SDK standard architecture • Fully open source on GitHub with active development Installation meltano add extractor tap-oracle-godzilla PyPI Package https://pypi.org/project/tap-oracle-godzilla/ Repository https://github.com/Hamza-Bouali/tap-oracle Settings Supported •

host

- Oracle hostname •

port

- Oracle port (default 1521) •

user

- Oracle username •

password

- Oracle password •

service_name

- Service name (preferred for PDB connections) •

sid

- System ID (alternative connection method) •

filter_schemas

- Comma-separated schema names •

filter_tables

- Array of tables (SCHEMA-TABLE format) •

cursor_array_size

- Batch fetch size (default 1000) •

thick_mode

- Use thick mode for oracledb driver •

https_proxy

- Proxy URL for connections •

start_date

- ISO format start date for incremental replication Testing • ✅ Validated discovery against real Oracle databases (23MB+ catalogs) • ✅ Type mapping tested with NUMBER, CLOB, BLOB, XMLTYPE, SDO_GEOMETRY • ✅ Service name vs SID connection methods verified • ✅ Schema filtering performance optimized • ✅ PyPI package published and installable Related Issues Modernizes Oracle extraction for data ELT/ELT pipelines using Singer SDK standards. meltano/hub

Hi I'm looking for a working TAP for oracle using meltano with incremental replication. I tried the default s7clark10, but couldn't get incremental working. I cam across this variant, and Im trying to install using meltano add tap-oracle-godzilla (the command doesn't like the word extractor). Im on meltano v 4.2.0 However Im getting error Extractor 'tap-oracle-godzilla' is not known to Meltano. Check https://hub.meltano.com/ for available plugins. Can someone please advise how I can get this working, and if possible a sample meltano.yml that will show me how to do incremental replication. Many Thanks

Hi @Richard Legge, just stumbled across your message here by accident - in future, I would suggest posting in #C069CQNHDNF or #C06A1LKFAAC instead. Your issue is that the plugin is still called

tap-oracle

, not

tap-oracle-godzilla

- I understand you are trying to specify an alternate variant, for which the syntax is

meltano add tap-oracle --variant godzilla

After running that, I see the error

PluginDefinitionNotFoundError: Extractor 'tap-oracle' variant 'godzilla' is not known to Meltano. Variants: ['s7clarke10 (default)', 'visch', 'airbyte', 'mpcarter',
'transferwise', 'hamza-bouali']. Check <https://hub.meltano.com/> for available plugins.

which tells us what the available variants of

tap-oracle

actually are - in this case, we need

hamza-bouali

, as per the plugin definition on the Hub (added in this PR)

$ meltano add tap-oracle --variant hamza-bouali
Added extractor 'tap-oracle' to your project
Variant:	hamza-bouali
Repository:	<https://github.com/Hamza-Bouali/tap-oracle>
Documentation:	<https://hub.meltano.com/extractors/tap-oracle--hamza-bouali>

2026-04-28T16:07:05.626398Z [info     ] Installing extractor 'tap-oracle'
2026-04-28T16:07:07.823908Z [info     ] Installed extractor 'tap-oracle'

To learn more about extractor 'tap-oracle', visit <https://hub.meltano.com/extractors/tap-oracle--hamza-bouali>

Hopefully that helps!

Thank Reuben. I successfully got it installed..