WIXLIB

3.146Subversion: XML Metadata Comparator3-923.147Subview Properties3-923.148Table Properties3-933.149Table to View3-973.150Table DDL Transformation Scripts3-973.151Telephone Properties3-983.152Transformation Package3-983.153Transformation task-name 3-983.154Transformation Properties3-993.155Transformation Flow Properties3-1003.156TSDP Policy Properties3-1003.157Types Administration3-1013.158Types to Domains3-1013.159Unable to Connect3-1023.160Unique Identifier (UID, or Key) Properties3-1023.161View Properties (Logical Model)3-1023.162View Properties (Relational Model)3-1033.163View to Table3-1053.164Windows3-105Indexx

List of Figures1-1SQL Developer Data Modeler Main Window1-2xi

PrefacePrefaceThis guide provides conceptual and usage information about SQL Developer DataModeler, a data modeling and database design tool that provides an environment forcapturing, modeling, managing, and exploiting metadata. SQL Developer DataModeler is also referred to as Data Modeler.AudienceThis guide is intended for those using SQL Developer Data Modeler. It assumes thatyou either have some familiarity with data modeling, or that you can find resourcesoutside this guide for more advanced and detailed information about data modeling.Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the OracleAccessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic supportthrough My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id info or visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trsif you are hearing impaired.Product AccessibilityThe Oracle SQL Developer Data Modeler Accessibility Guide provides informationabout the accessibility features for SQL Developer Data Modeler.Related DocumentsTo download free release notes, installation documentation, white papers, or othercollateral, go to the Oracle Technology Network (OTN) athttp://www.oracle.com/technetwork/The documentation section of the OTN site is ntation/xii

PrefaceConventionsThe following text conventions are used in this document:ConventionMeaningboldfaceBoldface type indicates graphical user interface elements associatedwith an action, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables forwhich you supply particular values.monospaceMonospace type indicates commands within a paragraph, URLs, codein examples, text that appears on the screen, or text that you enter.Third-Party License InformationSQL Developer Data Modeler contains third-party code. Oracle is required to providethe following notices. Note, however, that the Oracle program license thataccompanied this product determines your right to use the Oracle program, includingthe third-party software, and the terms contained in the following notices do notchange those rights.Batik Version 1.7This program contains Batik version 1.7, which has the following associated attributiontext:This product includes software developed by The Apache Software Foundation(http://www.apache.org/). This software contains code from the World Wide WebConsortium (W3C) for the Document Object Model API (DOM API) and SVGDocument Type Definition (DTD). This software contains code from the InternationalOrganisation for Standardization for the definition of character entities used in thesoftware's documentation. 2. Must include Apache License, Version 2.0 with anydistribution of Apache Batik 1.7: Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION,AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions foruse, reproduction, and distribution as defined by Sections 1 through 9 of thisdocument. "Licensor" shall mean the copyright owner or entity authorized by thecopyright owner that is granting the License. "Legal Entity" shall mean the union of theacting entity and all other entities that control, are controlled by, or are under commoncontrol with that entity. For the purposes of this definition, "control" means (i) thepower, direct or indirect, to cause the direction or management of such entity, whetherby contract or otherwise, or (ii) ownership of fifty percent (50%) or more of theoutstanding shares, or (iii) beneficial ownership of such entity. "You" (or "Your") shallmean an individual or Legal Entity exercising permissions granted by this License."Source" form shall mean the preferred form for making modifications, including butnot limited to software source code, documentation source, and configuration files."Object" form shall mean any form resulting from mechanical transformation ortranslation of a Source form, including but not limited to compiled object code,generated documentation, and conversions to other media types. "Work" shall meanthe work of authorship, whether in Source or Object form, made available under theLicense, as indicated by a copyright notice that is included in or attached to the work(an example is provided in the Appendix below). "Derivative Works" shall mean anyxiii

Prefacework, whether in Source or Object form, that is based on (or derived from) the Workand for which the editorial revisions, annotations, elaborations, or other modificationsrepresent, as a whole, an original work of authorship. For the purposes of this License,Derivative Works shall not include works that remain separable from, or merely link (orbind by name) to the interfaces of, the Work and Derivative Works thereof."Contribution" shall mean any work of authorship, including the original version of theWork and any modifications or additions to that Work or Derivative Works thereof, thatis intentionally submitted to Licensor for inclusion in the Work by the copyright owneror by an individual or Legal Entity authorized to submit on behalf of the copyrightowner. For the purposes of this definition, "submitted" means any form of electronic,verbal, or written communication sent to the Licensor or its representatives, includingbut not limited to communication on electronic mailing lists, source code controlsystems, and issue tracking systems that are managed by, or on behalf of, theLicensor for the purpose of discussing and improving the Work, but excludingcommunication that is conspicuously marked or otherwise designated in writing by thecopyright owner as "Not a Contribution." "Contributor" shall mean Licensor and anyindividual or Legal Entity on behalf of whom a Contribution has been received byLicensor and subsequently incorporated within the Work. 2. Grant of CopyrightLicense.Subject to the terms and conditions of this License, each Contributor hereby grants toYou a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocablecopyright license to reproduce, prepare Derivative Works of, publicly display, publiclyperform, sublicense, and distribute the Work and such Derivative Works in Source orObject form. 3. Grant of Patent License. Subject to the terms and conditions of thisLicense, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive,no-charge, royalty-free, irrevocable (except as stated in this section) patent license tomake, have made, use, offer to sell, sell, import, and otherwise transfer the Work,where such license applies only to those patent claims licensable by such Contributorthat are necessarily infringed by their Contribution(s) alone or by combination of theirContribution(s) with the Work to which such Contribution(s) was submitted. If Youinstitute patent litigation against any entity (including a cross-claim or counterclaim in alawsuit) alleging that the Work or a Contribution incorporated within the Workconstitutes direct or contributory patent infringement, then any patent licenses grantedto You under this License for that Work shall terminate as of the date such litigation isfiled. 4. Redistribution. You may reproduce and distribute copies of the Work orDerivative Works thereof in any medium, with or without modifications, and in Sourceor Object form, provided that You meet the following conditions: a. You must give anyother recipients of the Work or Derivative Works a copy of this License; and b. Youmust cause any modified files to carry prominent notices stating that You changed thefiles; and c. You must retain, in the Source form of any Derivative Works that Youdistribute, all copyright, patent, trademark, and attribution notices from the Source formof the Work, excluding those notices that do not pertain to any part of the DerivativeWorks; and d. If the Work includes a "NOTICE" text file as part of its distribution, thenany Derivative Works that You distribute must include a readable copy of theattribution notices contained within such NOTICE file, excluding those notices that donot pertain to any part of the Derivative Works, in at least one of the following places:within a NOTICE text file distributed as part of the Derivative Works; within the Sourceform or documentation, if provided along with the Derivative Works; or, within a displaygenerated by the Derivative Works, if and wherever such third-party notices normallyappear. The contents of the NOTICE file are for informational purposes only and donot modify the License. You may add Your own attribution notices within DerivativeWorks that You distribute, alongside or as an addendum to the NOTICE text from theWork, provided that such additional attribution notices cannot be construed asmodifying the License. You may add Your own copyright statement to Yourxiv

Prefacemodifications and may provide additional or different license terms and conditions foruse, reproduction, or distribution of Your modifications, or for any such DerivativeWorks as a whole, provided Your use, reproduction, and distribution of the Workotherwise complies with the conditions stated in this License. 5. Submission ofContributions. Unless You explicitly state otherwise, any Contribution intentionallysubmitted for inclusion in the Work by You to the Licensor shall be under the termsand conditions of this License, without any additional terms or conditions.Notwithstanding the above, nothing herein shall supersede or modify the terms of anyseparate license agreement you may have executed with Licensor regarding suchContributions. 6. Trademarks.This License does not grant permission to use the trade names, trademarks, servicemarks, or product names of the Licensor, except as required for reasonable andcustomary use in describing the origin of the Work and reproducing the content of theNOTICE file. 7. Disclaimer of Warranty. Unless required by applicable law or agreed toin writing, Licensor provides the Work (and each Contributor provides itsContributions) on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OFANY KIND, either express or implied, including, without limitation, any warranties orconditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FORA PARTICULAR PURPOSE. You are solely responsible for determining theappropriateness of using or redistributing the Work and assume any risks associatedwith Your exercise of permissions under this License. 8. Limitation of Liability. In noevent and under no legal theory, whether in tort (including negligence), contract, orotherwise, unless required by applicable law (such as deliberate and grossly negligentacts) or agreed to in writing, shall any Contributor be liable to You for damages,including any direct, indirect, special, incidental, or consequential damages of anycharacter arising as a result of this License or out of the use or inability to use theWork (including but not limited to damages for loss of goodwill, work stoppage,computer failure or malfunction, or any and all other commercial damages or losses),even if such Contributor has been advised of the possibility of such damages. 9.Accepting Warranty or Additional Liability. While redistributing the Work or DerivativeWorks thereof, You may choose to offer, and charge a fee for, acceptance of support,warranty, indemnity, or other liability obligations and/or rights consistent with thisLicense. However, in accepting such obligations, You may act only on Your ownbehalf and on Your sole responsibility, not on behalf of any other Contributor, and onlyif You agree to indemnify, defend, and hold each Contributor harmless for any liabilityincurred by, or claims asserted against, such Contributor by reason of your acceptingany such warranty or additional liability. END OF TERMS AND CONDITIONSAppendix: How to Apply Apache License to Your Work To apply the Apache Licenseto your work, attach the following boilerplate notice, with the fields enclosed bybrackets "[]" replaced with your own identifying information. (Don't include thebrackets!) The text should be enclosed in the appropriate comment syntax for the fileformat. We also recommend that a file or class name and description of purpose beincluded on the same "printed page" as the copyright notice for easier identificationwithin third-party archives. Copyright [yyyy] [name of copyright owner] Licensed underthe Apache License, Version 2.0 (the "License"); you may not use this file except incompliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to inwriting, software distributed under the License is distributed on an "AS IS" BASIS,WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.See the License for the specific language governing permissions and limitations underthe License.xv

PrefaceLog4j 1.2.9This program contains Log4j 1.2.9, which has the following associated attribution text:The Apache Software License, Version 1.1 * * Copyright (c) 2000 The ApacheSoftware Foundation. All rights * reserved. * * Redistribution and use in source andbinary forms, with or without * modification, are permitted provided that the followingconditions * are met: * * 1. Redistributions of source code must retain the abovecopyright * notice, this list of conditions and the following disclaimer. * * 2.Redistributions in binary form must reproduce the above copyright * notice, this list ofconditions and the following disclaimer in * the documentation and/or other materialsprovided with the * distribution. * * 3. The end-user documentation included with theredistribution, * if any, must include the following acknowledgment: * "This productincludes software developed by the * Apache Software Foundation (Link1 /)." *Alternately, this acknowledgment may appear in the software itself, * if and whereversuch third-party acknowledgments normally appear. * * 4. The names "Apache" and"Apache Software Foundation" must * not be used to endorse or promote productsderived from this * software without prior written permission. For written * permission,please contact apache@apache.org. * * 5. Products derived from this software maynot be called "Apache", * nor may "Apache" appear in their name, without prior written* permission of the Apache Software Foundation. * * THIS SOFTWARE IS PROVIDED AS IS'' AND ANY EXPRESSED OR IMPLIED * WARRANTIES, INCLUDING, BUTNOT LIMITED TO, THE IMPLIED WARRANTIES * OF MERCHANTABILITY ANDFITNESS FOR A PARTICULAR PURPOSE ARE * DISCLAIMED. IN NO EVENTSHALL THE APACHE SOFTWARE FOUNDATION OR * ITS CONTRIBUTORS BELIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, * SPECIAL, EXEMPLARY, ORCONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT * LIMITED TO,PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF * USE,DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND *ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, *OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAYOUT * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THEPOSSIBILITY OF * SUCH DAMAGE. * * * This software consists of voluntary contributions made by many * individualson behalf of the Apache Software Foundation. For more * information on the ApacheSoftware Foundation, please see * Link2 / . * * Portions of this software are basedupon public domain software * originally written at the National Center forSupercomputing Applications, * University of Illinois, Urbana-Champaign. */MigLayout 4.0Copyright (c) 2004, Mikael Grev, MiG InfoCom AB. (miglayout (at) miginfocom (dot)com)All rights reserved.Redistribution and use in source and binary forms, with or without modification, arepermitted provided that the following conditions are met:Redistributions of source code must retain the above copyright notice, this list ofconditions and the following disclaimer.xvi

PrefaceRedistributions in binary form must reproduce the above copyright notice, this list ofconditions and the following disclaimer in the documentation and/or other materialsprovided with the distribution.Neither the name of the MiG InfoCom AB nor the names of its contributors may beused to endorse or promote products derived from this software without specific priorwritten permission.THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS ANDCONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OFMERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE AREDISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER ORCONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOTLIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OFUSE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSEDAND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT

1.6.5 Importing from a Data Dictionary 1-47 1.6.6 Importing an Oracle Designer Model 1-47 1.6.7 Importing a Data Modeler Design 1-47 1.6.8 Importing a Domain 1-47 1.7 Exporting and Importing Preferences and Other Settings 1-47 1.7.1 Restoring the Original Data Modeler Preferences 1-48 1.8 Data Modeler Reports 1-48