STM Generator

Generate Source-to-Target Mappings — open the generator notebooks directly in Rogers Databricks.

Access required. You must have access to the Rogers Databricks (Dev access) to open these notebooks. Each link opens Rogers Databricks directly in a new tab.

Please note. Each notebook is a working sample built for one project. If your project is structured differently, copy the notebook and adjust the code to suit your project's source systems, schemas and target layers before generating the STM.

1. Oracle → EDL Generator

Generates the STM for Oracle sources: Oracle → raw → rawstd, and rawstd → curated layer.

Oracle → raw → rawstd → curated

2. SFTP → EDL Generator

Generates the STM for SFTP file feeds: SFTP → raw → rawstd, and rawstd → curated layer.

SFTP → raw → rawstd → curated

3. Azure Storage → Curated (FSM ADLS)

Generates the STM for Azure Storage (ADLS) sources: Azure Storage → raw → rawstd → curated layer.

Azure Storage → raw → rawstd → curated

4. Derived STM Generator

Generates the STM for derived tables (STM_GENERATOR_AUTOMATION).

Derived tables