requires Internet access to https://repo.maven.apache.org/maven2/ and/or other tool sites to download drivers into <TDC_HOME>/data/download/MIMB/. For more information on how to retrieve third-party drivers when the TDC server cannot access the Internet, see this article.
requires the tool to be installed to access its SDK.
|Tool Web Site||http://www.cloudera.com/products/cloudera-navigator.html|
|Supported Methodology||[Metadata Management] Multi-Model, Metadata Repository, Data Store (Physical Data Model), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing) via REST API|
|Remote Repository Browsing for Model Selection|
Tool: Cloudera / Navigator version 2.x via REST API
Metadata: [Metadata Management] Multi-Model, Metadata Repository, Data Store (Physical Data Model), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing)
Component: ClouderaNavigator version 11.0.0
This bridge requires internet access to https://repo.maven.apache.org/maven2/ (and exceptionally a few other tool sites)
in order to download the necessary third party software libraries into $HOME/data/download/MIMB/
- If https fails, the bridge then tries with http.
- If a proxy is used to access internet, you must configure that proxy in the JRE (see the -j option in the Miscellaneous parameter).
- If the bridge does not have access to internet, that directory can be copied from another server with internet access.
By running this bridge, you hereby acknowledge responsibility for the license terms and any potential security vulnerabilities from these downloaded third party software libraries.
Navigator repositories contain the Hadoop data store definitions of HDFS files and HIVE tables, as well as the data flow lineage of operations between them.
Navigator repositories determine such data flow lineage from the execution log of various technologies (HiveQL, Spark, etc) produced by various applications, ingestion framework /ETL /DI jobs.
- Entities filter allows to define the data flow starting or end entities by location (e.g. files in various directories, and some precise files), and type (e.g. HIVE tables, HDFS files)
- Lineage Direction allows to pick a data flow direction from the above entities (i.e upstream or downstream)
- Operations filter allows to the data flow to some operation types (e.g. HiveQL, Spark) and time range (e.g. last week)
Navigator repositories can be extremely large as it contains any HDFS/HIVE transactions over multiple years of activities.
Therefore, it is important filter down the scope of a given Navigator import to a precise data flow activity.
FREQUENTLY ASKED QUESTIONS
Refer to the current general known limitations at http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html or bundled in Documentation/ReadMe/MIMBKnownLimitations.html
The purpose of this Navigator import bridge is NOT to extract the data store definitions, instead use the HIVE and HDFS import bridges for that purpose.
However, the purpose of this Navigator import bridge is to extract the data flow lineage (DI processes) between previously harvested HDFS and HIVE data stores.
Provide a trouble shooting 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 option -backup)
|URL||URL of the metadata server.
|Login||Name of the user account used to connect to metadata server||STRING||holger_gov|
|Password||Password for the user account used to connect to metadata server.||PASSWORD||holger_gov|
|Entities filter||Bridge will import and build lineage using start entities(tables, files and directories) set, filtered by this parameter. The query syntax is exactly the same as in Cloudera Navigator search ui.
path like data.csv
path like *hdfs://quickstart.cloudera:8020/user/hive/warehouse/customers
path like *dirname* and type:directory
To make import faster, please provide as precise as possible query and check filtered entities count in Navigator ui before import.
|Operations filter||Limit imported operations by date or sourceType, e.g.
started:[2019-02-25T00:00:000Z TO 2019-02-27T00:00:000Z] and sourceType:impala
Using of this option will bring additional requests to the API server which may slow down the import process.
|Lineage direction||Use this parameter to set lineage extract direction.||ENUMERATED||
|Kerberos configuration file||Path to kerberos krb5 config file (usually krb5.ini or krb5.conf with correct configuration inside)
|Kerberos login.conf file||Path to login.conf with correct keytab file path and principal name. F.e:
|Miscellaneous||Specify miscellaneous options identified with a -option followed by a value if required:
-m <Java Memory's maximum size>
1G by default on 64bits JRE or as set in conf/conf.properties, e.g.
-j <Java Runtime Environment command line options>
This option must be the last one in the Miscellaneous parameter as all the text after -j is passed "as is" to the JRE, e.g.
-j -Dname=value -Xms1G
The following option must be set when a proxy is used to access internet (this is critical to access https://repo.maven.apache.org/maven2/ (and exceptionally a few other tool sites) in order to download the necessary third party software libraries.
-j -Dhttp.proxyHost=127.0.0.1 -Dhttp.proxyPort=3128 -Dhttps.proxyHost=127.0.0.1 -Dhttps.proxyPort=3128 -Dhttp.proxyUser=user -Dhttp.proxyPassword=pass -Dhttps.proxyUser=user -Dhttps.proxyPassword=pass
-jre <Java Runtime Environment full path name>
It can be an absolute path to javaw.exe on Windows or a link/script path on Linux, e.g.
-jre "c:\Program Files\Java\jre1.8.0_211\bin\javaw.exe"
-v <Environment variable value>
None by default, e.g.
-v var1=value1 -v var2="value2 with spaces"
-model.name <model name>
Override the model name, e.g.
-model.name "My Model Name"
-prescript <script name>
The script must be located in the bin directory, and have .bat or .sh extension.
The script path must not include any parent directory symbol (..).
The script should return exit code 0 to indicate success, or another value to indicate failure.
-prescript "script.bat arg1 arg2"
Clears the cache before the import, and therefore will run a full import without incremental harvesting.
Warning: this is a system option managed by the application calling the bridge and should not be set by users.
Full path of an empty directory to save the metadata input files for further troubleshooting.
-restore.dir <backup directory path>
Specify the backup directory to be restorted, e.g.
-connection.timeout <number of seconds>
Specify a connection time out (by default 20), e.g:
Sets the number of threads to use while performing requests to api, e.g.
-cs <comma separated list of connections>
Creates Schemas per Connection, e.g.
-cs * (create a separate connection for each schema in each connection)
-cs c1, c2 (create separate connections for each schema in connections c1 and c2)
-cs app1=c.s1 (create a connection named app1 for the schema s1 in the connection c)
-request.limit <max number of entities>
Specify the maximum number of entities to fetch per one request, e.g.
Import System objects that are skipped by default
-cd <comma separated list of connections>
Creates Directories per connection, e.g.
-cd a_con=orig_con:/root/a (create a separate connection a_con for folder branch root/a in connection origin_con)
-cd hdfs://nameservice2/podium=hdfs://nameservice1/podium (create a separate connection hdfs://nameservice2/podium for connection hdfs://nameservice1/podium)
Imports logical-physical relations
Mapping information is not available