/dicle

Primary LanguagePython

docker

  • Start services
cd db
docker compose up

oracle

user: sys
pass: oracle
db: xe

grant connect ,resource to hr;

ALTER USER hr account unlock

postgres

POSTGRES_USER: postgres
POSTGRES_PASSWORD: Welcome123
HOST: localhost

extraction

cd ext
pip install meltano
meltano add extractor tap-oracle
meltano add loader target-postgres

run

make sure LD_LIBRARY_PATH is set for oracle.

# in ext folder
meltano run tap-oracle target-postgres
# this will ext-load all tables in hr to postgres