Bridge Specifications
| Vendor | Meta Integration Technology, Inc. |
| Tool Name | Data Mapping Script |
| Tool Version | 11.x |
| Tool Web Site | http://metaintegration.com/Products/MIMB/ |
| Supported Methodology | [Data Integration] Multi-Model, Data Store (Physical Data Model), (Source and Target Data Stores, Transformation Lineage, Expression Parsing) via SQL TXT File |
SPECIFICATIONS
Tool: Meta Integration Technology, Inc. / Data Mapping Script version 11.x via SQL TXT File
See http://metaintegration.com/Products/MIMB/
Metadata: [Data Integration] Multi-Model, Data Store (Physical Data Model), (Source and Target Data Stores, Transformation Lineage, Expression Parsing)
Component: DataMappingScript version 12.0.0
OVERVIEW
The purpose of this import bridge is to capture the data flow lineage involved in proprietary Data Integration (DI) tools and technologies used for ETL/ELT/CDC data movements.
This import bridge parses a directory of Data Mapping Scripts (based on the standard database SQL Data Manipulation Language (SQL DML) syntax) to extract:
- The data connection data models (e.g. database schema, tables, columns) of their source and target data stores faithfully representing any supported technology (RDBMS, NoSQL, File Systems)
- The data integration (DI/ETL/ELT/CDC) for the data flow lineage between these data stores.
The data mapping script syntax is available in:
${MODEL_BRIDGE_HOME}/conf/MIRModelBridgeTemplate/DataMappingScript/DataMappingScriptTutorial.sql
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at https://metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with -backup option, although this common option is not implemented on all bridges for technical reasons).
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope |
| Directory | The directory of SQL DML scripts to import. | DIRECTORY | |||
| Include filter | The include folder and file filter pattern relative to the root directory, based on the extended Unix glob case-sensitive expression syntax, e.g. *.* - include any file at the root level *.sql - include only SQL files at the root level **.sql -include only SQL files at any level *.{sql,gz} include only SQL or gz files at the root level dir/*.sql - include only SQL files in the 'dir' folder dir/**.sql - include only SQL files under 'dir' folder at any level dir/**.* - include any file under 'dir' folder at any level f.sql - include only f.sql under root level **/f.sql - include only f.sql at any level **dir/** - include all files under any 'dir' folder at any level **dir1/dir2/** - include all files under any 'dir2' folder under any 'dir1' folder at any level If both the include and exclude filters are empty, then all folders and files under the root directory are included. |
STRING |
Bridge Mapping
Mapping information is not available