#2240 feat: Added the Hamza Bouali variant of tap-oracle Pull request opened by edgarrmondragon 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