noc.core.etl.extractor.oracle

Module Contents

class noc.core.etl.extractor.oracle.ORACLEExtractor(*args, **kwargs)

Bases: noc.core.etl.extractor.sql.SQLExtractor

Oracle SQL extractor. Requres cx_Oracle

Configuration variables ORACLE_DSN - Oracle database DSN ORACLE_HOST - Oracle host (when ORACLE_DSN is empty) ORACLE_PORT - Oracle port (when ORACLE_DSN is empty) ORACLE_SERVICE_NAME - Oracle database service name (

when ORACLE_DSN is empty)

ORACLE_SID - Oracle database SID (when ORACLE_DSN is empty) ORACLE_USER - Oracle database user ORACLE_PASSWORD - Oracle database password

ORACLE_CONCURRENCY - execute up to ORACLE_CONCURRENCY queries
in parralel

ORACLE_ARRAYSIZE - oracle client array size

get_cursor(self)
iter_data(self)