Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution

MIMB Bridge Documentation

MIMB Import Bridge from JSON File

Bridge Specifications

Vendor ISO
Tool Name JSON (JavaScript Object Notation) File
Tool Version 1.0
Tool Web Site http://www.json.org/
Supported Methodology [Database] Data Store (Physical Data Model) via

Import tool: ISO JSON (JavaScript Object Notation) File 1.0 (http://www.json.org/)
Import interface: [Database] Data Store (Physical Data Model) via from JSON File
Import bridge: 'Json' 10.0.0

IMPORTING METADATA FROM JSON FILES USING NATIVE JAVA API. This bridge loads Json files content and parse loaded documents in order to extract the physical metadata. Please refer to the individual parameter's tool tips for more detailed examples.


Bridge will assign a data type for each JSON attribute according to following samples:
"_id" : { "$oid": "50a9c951300493f64fbffdb6" } STRING (SQL_VARCHAR)
"dateExample" : { "$date" : "2014-01-01T05:00:00.000Z"} DATE_8 (SQL_DATE)
"isoDateExample" : { "$date" : 1491461103897 } DATE_8 (SQL_DATE)
"timestampExample" : { "$timestamp" : { "t" : 1412180887, "i" : 1 } } TIMESTAMP (SQL_TIMESTAMP)
"stringDateExample" : "Thu Apr 06 2017 09:41:51 GMT+0300 (FLE Standard Time)" STRING (SQL_VARCHAR)
"numberLongExample" : { "$numberLong": "7494814965" } LONG_8 (SQL_BIGINT)
"booleanSample" : true BOOLEAN_1 (SQL_BOOLEAN)
"stringSample" : "some text" STRING (SQL_VARCHAR)
"expNumberSample" : 2.99792458e8 DOUBLE_10_5 (SQL_DOUBLE)
"smallNumberSample" : -1 LONG_8 (SQL_BIGINT)
"numberSample" : 3 LONG_8 (SQL_BIGINT)
"floatSample" : 3.141592653589793238462643383279 DOUBLE_10_5 (SQL_DOUBLE)
"rfc7493bignumber" : "9007199254740992" STRING (SQL_VARCHAR)
"expStringSample" : "2.99792458e8" STRING (SQL_VARCHAR)
"arraySample" : [1, 2, 3] array (SQL_ARRAY)
"objectEmptySample" : {} STRING (SQL_VARCHAR)
"nullSample" : null undefined
"nullStringSample" : "null" STRING (SQL_VARCHAR)


Bridge Parameters

Parameter Name Description Type Values Default Scope
Directory Select a directory that contains JSON files to import DIRECTORY     Mandatory
Miscellaneous Specify miscellaneous options identified with a -letter and value.

For example, -m 4G -t 6 -f 100 -j -Dname=value -Xms1G

-m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ).
-v set environment variable(s) (e.g. -v var1=value -v var2="value with spaces").
-j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G).
STRING      
Create Shared Folder Specifies if the Shared folder should be created or not.

- 'False' : Shared folder are not created(default)
- 'True' : Shared folder are created
BOOLEAN
False
True
False  

 

Bridge Mapping

Mapping information is not available

Last updated on Fri, 17 Nov 2017 18:36:37

Copyright © Meta Integration Technology, Inc. 1997-2017 All Rights Reserved.

Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.