ImportSpec.xsd 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!--
  3. Licensed Materials - Property of IBM
  4. IBM Cognos Products: fmmd
  5. (C) Copyright IBM Corp. 2003, 2010
  6. US Government Users Restricted Rights - Use, duplication or disclosure
  7. restricted by GSA ADP Schedule Contract with IBM Corp.
  8. -->
  9. <!--This schema describes a selection specification for importing database metadata.-->
  10. <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified" version="v0.1.3">
  11. <xs:simpleType name="typeEnum">
  12. <xs:annotation>
  13. <xs:documentation>the types of schema nodes that can exist in metdata sources ("tables" etc. is an artificial level between schema and "table" etc.)</xs:documentation>
  14. </xs:annotation>
  15. <xs:restriction base="xs:NMTOKEN">
  16. <xs:enumeration value="namespace"/>
  17. <xs:enumeration value="database"/>
  18. <xs:enumeration value="catalog"/>
  19. <xs:enumeration value="cube"/>
  20. <xs:enumeration value="schema"/>
  21. <xs:enumeration value="tables"/>
  22. <xs:enumeration value="views"/>
  23. <xs:enumeration value="synonyms"/>
  24. <xs:enumeration value="procedures"/>
  25. <xs:enumeration value="proceduresNoFunc"/>
  26. <xs:enumeration value="functions"/>
  27. <xs:enumeration value="table"/>
  28. <xs:enumeration value="view"/>
  29. <xs:enumeration value="synonym"/>
  30. <xs:enumeration value="procedure"/>
  31. <xs:enumeration value="procedureUnknown"/>
  32. <xs:enumeration value="function"/>
  33. <xs:enumeration value="column"/>
  34. <xs:enumeration value="dimension"/>
  35. <xs:enumeration value="OLAP_catalog"/>
  36. <xs:enumeration value="hierarchy"/>
  37. <xs:enumeration value="level"/>
  38. <xs:enumeration value="attribute"/>
  39. <xs:enumeration value="measures"/>
  40. <xs:enumeration value="measure"/>
  41. <xs:enumeration value="infoQuery"/>
  42. <xs:enumeration value="dimensionGroup"/>
  43. <xs:enumeration value="folder"/>
  44. <xs:enumeration value="querySubject"/>
  45. <xs:enumeration value="filter"/>
  46. <xs:enumeration value="calculation"/>
  47. <xs:enumeration value="aliasTable"/>
  48. <xs:enumeration value="aliasTableLang"/>
  49. <xs:enumeration value="sysCatalog"/>
  50. <xs:enumeration value="sysSchema"/>
  51. <xs:enumeration value="sysObjects"/>
  52. <xs:enumeration value="sysTables"/>
  53. <xs:enumeration value="sysViews"/>
  54. <xs:enumeration value="sysSynonyms"/>
  55. <xs:enumeration value="sysTable"/>
  56. <xs:enumeration value="sysView"/>
  57. <xs:enumeration value="sysSynonym"/>
  58. </xs:restriction>
  59. </xs:simpleType>
  60. <xs:simpleType name="selectEnum">
  61. <xs:restriction base="xs:NMTOKEN">
  62. <xs:enumeration value="false"/>
  63. <xs:enumeration value="true"/>
  64. <xs:enumeration value="partial"/>
  65. <xs:enumeration value="noEval"/>
  66. <xs:enumeration value="unavailable"/>
  67. </xs:restriction>
  68. </xs:simpleType>
  69. <xs:simpleType name="optionEnum">
  70. <xs:restriction base="xs:NMTOKEN">
  71. <xs:enumeration value="keys"/>
  72. <xs:enumeration value="indexes"/>
  73. </xs:restriction>
  74. </xs:simpleType>
  75. <xs:complexType name="itemType">
  76. <xs:choice>
  77. <xs:element name="namePattern" type="xs:string">
  78. <xs:annotation>
  79. <xs:documentation>Indicates the parent item is to be browsed (expanded).</xs:documentation>
  80. </xs:annotation>
  81. </xs:element>
  82. <xs:element name="item" type="itemType" minOccurs="0" maxOccurs="unbounded"/>
  83. </xs:choice>
  84. <xs:attribute name="Name" type="xs:string" use="required"/>
  85. <xs:attribute name="Type" type="typeEnum" use="required"/>
  86. <xs:attribute name="Value" type="selectEnum" use="required"/>
  87. <xs:attribute name="uniqueName" type="xs:string" use="optional"/>
  88. <xs:attribute name="dbType" type="xs:string" use="optional"/>
  89. <xs:attribute name="isLeaf" type="xs:boolean" use="optional" default="false"/>
  90. <xs:attribute name="isSystem" type="xs:boolean" use="optional" default="false"/>
  91. <xs:attribute name="attributeDimensionsAsProperties" type="xs:boolean" use="optional" default="true"/>
  92. <xs:attribute name="dualStructures" type="xs:boolean" use="optional" default="true"/>
  93. </xs:complexType>
  94. <xs:element name="importSpec">
  95. <xs:annotation>
  96. <xs:documentation>Specifies what to import from a metadata source</xs:documentation>
  97. </xs:annotation>
  98. <xs:complexType>
  99. <xs:sequence>
  100. <xs:element name="credentials" minOccurs="0">
  101. <xs:annotation>
  102. <xs:documentation>access to content manager </xs:documentation>
  103. </xs:annotation>
  104. <xs:complexType>
  105. <xs:simpleContent>
  106. <xs:extension base="xs:string">
  107. <xs:attribute name="userID" type="xs:string" use="required"/>
  108. <xs:attribute name="password" type="xs:string" use="optional"/>
  109. </xs:extension>
  110. </xs:simpleContent>
  111. </xs:complexType>
  112. </xs:element>
  113. <xs:element name="includeOptions">
  114. <xs:annotation>
  115. <xs:documentation>what to include all items</xs:documentation>
  116. </xs:annotation>
  117. <xs:complexType>
  118. <xs:sequence>
  119. <xs:element name="indexes" type="xs:boolean" minOccurs="0"/>
  120. <xs:element name="primaryKeys" type="xs:boolean" minOccurs="0"/>
  121. <xs:element name="foriegnKeys" minOccurs="0">
  122. <xs:annotation>
  123. <xs:documentation>"reach" is the number of step to reach through; unlimited if absent</xs:documentation>
  124. </xs:annotation>
  125. <xs:complexType>
  126. <xs:simpleContent>
  127. <xs:extension base="xs:boolean">
  128. <xs:attribute name="reach" type="xs:positiveInteger" use="optional"/>
  129. </xs:extension>
  130. </xs:simpleContent>
  131. </xs:complexType>
  132. </xs:element>
  133. <xs:element name="descriptions" type="xs:boolean" minOccurs="0"/>
  134. </xs:sequence>
  135. </xs:complexType>
  136. </xs:element>
  137. <xs:element name="item" type="itemType" minOccurs="0" maxOccurs="unbounded">
  138. <xs:annotation>
  139. <xs:documentation>an item to include</xs:documentation>
  140. </xs:annotation>
  141. </xs:element>
  142. </xs:sequence>
  143. <xs:attribute name="relationshipOnKeys" type="xs:boolean" use="optional" default="false"/>
  144. <xs:attribute name="relationshipOnIndexes" type="xs:boolean" use="optional" default="false"/>
  145. <xs:attribute name="relationshipOnNames" type="xs:boolean" use="optional" default="false"/>
  146. <xs:attribute name="outerJoin" type="xs:boolean" use="optional" default="false"/>
  147. <xs:attribute name="insideSelection" type="xs:boolean" use="optional" default="false"/>
  148. <xs:attribute name="outsideSelection" type="xs:boolean" use="optional" default="false"/>
  149. <xs:attribute name="transformNames" type="xs:boolean" use="optional" default="false"/>
  150. <xs:attribute name="uniqueNames" type="xs:boolean" use="optional" default="false"/>
  151. <xs:attribute name="displaySummary" type="xs:boolean" use="optional" default="false"/>
  152. </xs:complexType>
  153. </xs:element>
  154. </xs:schema>