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

MIMB Bridge Documentation

MIMB Import Bridge from Microsoft SQL Server Integration Services (SSIS) (Repository Server)

Bridge Specifications

Vendor Microsoft
Tool Name SQL Server Integration Services (SSIS)
Tool Version 9.0 (2005) to 13.0 (2016)
Tool Web Site http://msdn2.microsoft.com/en-us/library/ms141026.aspx
Supported Methodology [Data Integration] Multi-Model, Metadata Repository, ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via IS API

Import tool: Microsoft SQL Server Integration Services (SSIS) 9.0 (2005) to 13.0 (2016) (http://msdn2.microsoft.com/en-us/library/ms141026.aspx)
Import interface: [Data Integration] Multi-Model, Metadata Repository, ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion) via IS API from Microsoft SQL Server Integration Services (SSIS) (Repository Server)
Import bridge: 'MicrosoftSqlServerRepositoryIs' 10.0.0

The bridge imports SSIS Packages from a corresponding SQL Server Repository using the SQL Server SDK APIs.

In order for this bridge to connect to the SQL Server Repository and import, it is necessary to ensure that the SQL Server Client Components are installed properly and corresponding services are running locally or established in your local network. The bridge uses Windows Authentication to connect to Integration Services. Please be sure the application is logged into Windows Domain as a 'User', which has appropriate rights to the objects you wish to import.

FREQUENTLY ASKED QUESTIONS:

SUPPORT:
When experiencing issues with the bridge, you should report the issues in a manner that is reproducible by the support engineers. In order to provide a complete set of source metadata to reproduce the issue, please export and attach the Data Service(dtsx) files. As always, attach the MIMB Log file, as well.


Bridge Parameters

Parameter Name Description Type Values Default Scope
SQL Server Version Specifies the version of SQL Server. ENUMERATED
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008
SQL Server 2005
2012  
Host Host name or IP address where SQL Server IS is running. STRING   localhost Mandatory
Package SQL Server Integration Service Project name to be processing. REPOSITORY_SUBSET     Mandatory
Password The value of the password for the protected package. PASSWORD      
Variable values file File defines values for SSIS variables. Variables are grouped by their package and task context, and prefixed with namespace:
[Package.Task]
Namespace::Variable=Value

Consider using the file when SSIS employs variables (without reasonable default values) in SQL statements. It should help with understanding lineage through SQL statements.

The file supports SSIS 2005, 2008 and 2012 variables. It does not support SSIS 2012 parameters.

Use the [Package] context to define variables for all tasks in the Package.
When the same variable is defined multiple times in a context, the latest definition is used. However, when the same variable is defined in [Package] and [Package.Task] contexts the definition in the higher level context, [Package.Task] is used.

Variable names are case sensitive. The file overrides default variable values if any defined in SSIS.
FILE
*.txt
*.ini
*.var
*.properties
   
Miscellaneous Specify miscellaneous options identified with a -letter and value.

For example, -l -c -m 4G -j -Dname=value -Xms1G

-s enable specifying mappings between Transformation Script inputs and outputs externally. In this case, the inputs go to a table in "_Script_" database and outputs come from a table in the database. One can specifying mapping relationships between inputs and outputs by defining a mapping between their tables.
By default the bridge interconnect all inputs to all outputs in Transformation Scripts.
-v set environment variable(s) (e.g. -v var1=value -v var2="value with spaces").
-m the maximum Java memory size whole number (e.g. -m 4G or -m 2500M ).
-j the last option that is followed by Java command line options (e.g. -j -Dname=value -Xms1G).
STRING      

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Microsoft SQL Server Integration Services (SSIS) (Repository Server)"
Metamodel
MicrosoftSqlServerIs
Mapping Comments
     
Attribute Column  
Description Column.Description  
Name Column.Name  
BaseType SSIS Type  
Class Table  
Description Table.Description  
Name Table.Name  
ClassifierMap Connection or Trainsformation Output link  
Description Description  
Name Name  
DataAttribute Transformation Column  
Description Description  
Name Name  
DataSet Output/Input  
Description Description  
Name Name  
DerivedType ColumnType  
Name DataType  
DesignPackage Package  
Description Package.Description  
Name Package.Name  
FeatureMap Input/Output column lineageId link  
Name Name  
StoreModel Package  

Last updated on Thu, 8 Feb 2018 17:19:37

Copyright © Meta Integration Technology, Inc. 1997-2018 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.