Database SQL DDL Script - Export
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
Bridge Specifications
| Vendor | ISO |
| Tool Name | Database |
| Tool Version | SQL-92 to SQL-2011 |
| Tool Web Site | http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=53681 |
| Supported Methodology | [Relational Database] Data Store (Physical Data Model) via TXT Export File |
SPECIFICATIONS
Tool: ISO / Database version SQL-92 to SQL-2011 via TXT Export File
See http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=53681
Metadata: [Relational Database] Data Store (Physical Data Model)
Component: DDL version 11.2.0
OVERVIEW
This import bridge generates SQL DDL.
REQUIREMENTS
n/a
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 | ||||||
| File | The generated SQL DDL file which must have a '.sql' or '.ddl' extension. | FILE |
|
Mandatory | |||||||
| Script language | The generated SQL DDL database language | ENUMERATED |
|
Oracle | |||||||
| Miscellaneous | INTRODUCTION Specify miscellaneous options starting with a dash and optionally followed by parameters, e.g. -connection.cast MyDatabase1="MICROSOFT SQL SERVER" Some options can be used multiple times if applicable, e.g. -connection.rename NewConnection1=OldConnection1 -connection.rename NewConnection2=OldConnection2; As the list of options can become a long string, it is possible to load it from a file which must be located in ${MODEL_BRIDGE_HOME}\data\MIMB\parameters and have the extension .txt. In such case, all options must be defined within that file as the only value of this parameter, e.g. ETL/Miscellaneous.txt JAVA ENVIRONMENT OPTIONS -java.memory <Java Memory's maximum size> (previously -m) 1G by default on 64bits JRE or as set in conf/conf.properties, e.g. -java.memory 8G -java.memory 8000M -java.parameters <Java Runtime Environment command line options> (previously -j) This option must be the last one in the Miscellaneous parameter as all the text after -java.parameters is passed "as is" to the JRE, e.g. -java.parameters -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. Note: The majority of proxies are concerned with encrypting (HTTPS) the outside (of the company) traffic and trust the inside traffic that can access proxy over HTTP. In this case, an HTTPS request reaches the proxy over HTTP where the proxy HTTPS-encrypts it. -java.parameters -java.parameters -Dhttp.proxyHost=127.0.0.1 -Dhttp.proxyPort=3128 -Dhttp.proxyUser=user -Dhttp.proxyPassword=pass OTHER OPTIONS -e <encoding> This value will be used to load text from the specified script files. By default, UTF-8 will be used. E.g. -e UTF-16 -e UTF-16BE -e US-ASCII -e ISO-8859-1 -p <warehouse path> Warehouse path. /user/hive/warehouse by default. E.g. -p /user/hive/temp |
STRING |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Database SQL DDL Script" Metamodel DDL |
Mapping Comments |
| AssociationRoleNameMap | Foreign Key | The AssociationRoleNameMap uses for export if available |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | ForeignKey.Name | |
| Attribute | Column | The database table column exports with max length validation. The length value is different for supported databases |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | Column.Name | |
| BaseType | Type | The database table column type exports accord to the native database types |
| DataType | See datatype conversion array | |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | Column.Type.Name | |
| CandidateKey | Primary Key | A primary candidate key is created for columns part of their table's primary key |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | PrimaryKey.Name | |
| Class | Table | |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | Table.Name | |
| DatabaseSchema | Schema | |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | Schema.Name | |
| ForeignKey | Foreign Key, Alternate Key, Unique Index | If the attributes in referenced table from the Foreign Key definition doesn't belongs to a Primary Key, the Alternate Key will generated. For Teradata database the attributes may belong to an Unique Index instead the Primary Key or the Alternate Key |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | ForeignKey.Name | |
| Index | Index | The Clustered and Unique options are supported |
| DesignLevel | The object doesn't exports if this property set to 'Logical only' | |
| PhysicalName | Index.Name | |
| IndexMember | Index | The IndexMember uses for the Index export |
| SQLViewAttribute | Column | The View Column |
| SQLViewEntity | View | If the source Model contains a database native SQL View statement - the statement will used in generated DDL. If not - the View structure only and related list tables will exported |
| StoreModel | Comment | The Comment with the source model name, selected database syntax and timestamp will generated |
| Name | Comment.Text |