Skip to main content
GuideServerConfigure and deploy Tabsdata servers on your machine.TutorialsConfigure data integration workflows within a running Tabsdata server.Advanced TutorialsBuild end-to-end workflows between two specific systems.API ReferenceCLI ReferenceRelease Notes
Version: 2.0.0

tabsdatak.conn.oracle

CredentialsSpecThe credential type for Oracle connections: UserPassword (user + password), spliced into the URI by the engine factory.
DestCfgKey
DestCfgSpec
IfTableExistsSpecWrite disposition when the target table exists: "append" adds rows; "replace" truncates before insert.
OracleDestOracle destination for @subscriber -- one target table per slot.
OracleDestConnOracle connection used by OracleDest.
OracleSrcOracle source for @publisher -- one output slot per query.
OracleSrcConnOracle connection used by OracleSrc.
OracleTableNameSpecAn Oracle table name, either table or schema.table (at most two dot-separated parts).
OracleTableNamesSpecA list of Oracle table names (see OracleTableNameSpec).
QueriesSpecA non-empty, ordered list of SELECT statements -- one output slot per query.
SrcCfgKey
SrcCfgSpec
UriSpecA SQLAlchemy-style Oracle URI, e.g.

CredentialsSpec

type_alias
CredentialsSpec: UserPassword

The credential type for Oracle connections: UserPassword (user + password), spliced into the URI by the engine factory.


DestCfgKey

type_alias
DestCfgKey: Literal['oracle.logging_level', 'tabsdata.sql.write_engine', 'tabsdata.sql.chunk_size']

DestCfgSpec

type_alias
DestCfgSpec: Mapping[DestCfgKey, Any]

Resolved type:

Mapping[Literal['oracle.logging_level', 'tabsdata.sql.write_engine', 'tabsdata.sql.chunk_size'], Any]

IfTableExistsSpec

type_alias
IfTableExistsSpec: Literal['append', 'replace']

Write disposition when the target table exists: "append" adds rows; "replace" truncates before insert.


OracleTableNameSpec

type_alias
OracleTableNameSpec: str

An Oracle table name, either table or schema.table (at most two dot-separated parts). Parts may be double-quoted; Oracle has no way to embed a literal double-quote inside a quoted identifier.


OracleTableNamesSpec

type_alias
OracleTableNamesSpec: list[OracleTableNameSpec]

Resolved type:

list[str]

A list of Oracle table names (see OracleTableNameSpec).


QueriesSpec

type_alias
QueriesSpec: list[str]

A non-empty, ordered list of SELECT statements -- one output slot per query.


SrcCfgKey

type_alias
SrcCfgKey: Literal['oracle.logging_level', 'tabsdata.sql.read_engine', 'tabsdata.sql.chunk_size', 'tabsdata.src_metadata.drop']

SrcCfgSpec

type_alias
SrcCfgSpec: Mapping[SrcCfgKey, Any]

Resolved type:

Mapping[Literal['oracle.logging_level', 'tabsdata.sql.read_engine', 'tabsdata.sql.chunk_size', 'tabsdata.src_metadata.drop'], Any]

UriSpec

type_alias
UriSpec: StrOrSecretSpec

Resolved type:

str | Secret

A SQLAlchemy-style Oracle URI, e.g. oracle+oracledb://host:port/service. The scheme must be oracle (an optional +driver is allowed). Accepts a plain string or a Secret.