I've made a start on a couple of Meltano SDK varia...
# singer-taps
m
I've made a start on a couple of Meltano SDK variants of
tap-oracle
and
tap-db2
: • Oracle - https://github.com/mjsqu/tap-oracle/tree/feat/sqlalchemy_2 - this one aims to use the oracledb driver which is currently only supported by SQLAlchemy2 - so currently it is hanging off the SDK branch put together by @edgar_ramirez_mondragon for SQLAlchemy2 compatibility. Adds a few extra features on top of the SDK, currently in the
feat/sqlalchemy_2
branch of my tap-oracle repository: ◦ fetchmany() - configurable by setting the
cursor_array_size
parameter ◦
filter_schemas
parameter ◦ defaults to the
oracledb
driver, but if it cannot connect using that, it falls back on
thick_mode=True
and uses local Oracle clients (@steve_clarke and I are working with an Oracle 11.2 Db which requires this) • DB2 - https://github.com/mjsqu/tap-db2/tree/feature/meltano_sdk Both repositories are also pulling public docker images of Oracle Free and Db2 Community Edition to do some tap testing in Github Actions. Hoping I can help contribute towards development efforts for SQL Taps using the Meltano SDK. I was pleasantly surprised by how easy it was to get a tap up and running using the cookiecutter templates, a few command line options and then tweaking the TODO bits. This guide is brilliant for anyone looking to have a go: https://sdk.meltano.com/en/latest/guides/porting.html#if-you-are-building-a-sql-tap