ODI Mapping Generator

ODI Mapping Generator is a Spring Boot application I developed to create as-is extraction mappings in a standardized and repeatable way. Instead of building mappings manually in ODI Studio, users can manage the process from a web interface. The application connects directly to the ODI Master and Work Repository through the ODI SDK, reads project, model, datastore, and KM metadata, then generates ODI mappings and scenarios based on the selected parameters.

Single Mapping

Source and target models and tables are selected from repository-driven dropdowns. IKM and LKM options can be adjusted from the UI, and the "Create Mapping" action generates both the mapping and scenario through the ODI SDK.

Bulk Mapping

The bulk flow provides an Excel-like dataset grid for creating many mappings in one run. Existing lists can be imported from xlsx, xls, or csv files and converted into the dataset format. Each row shows its success or error status as the process runs.

Naming Rules

Naming templates are managed centrally in a JSON configuration file. The engine supports variables such as projectCode, sourceTable, and targetModel, together with functions like upper, substr, and regexReplace. This makes it easier to apply the same naming policy across the team.

Technologies

Java 17, Spring Boot 2.7, Oracle ODI SDK, React 18 (UMD - no build pipeline required), Bootstrap 5, SheetJS, Gradle