Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_Connection
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-externalConnections.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-externalconnections_xsd Drilldown into parameters in schema sml-externalconnections_xsd Drilldown into textPr in schema sml-externalconnections_xsd Drilldown into webPr in schema sml-externalconnections_xsd Drilldown into olapPr in schema sml-externalconnections_xsd Drilldown into dbPr in schema sml-externalconnections_xsd Drilldown into singleSignOnId in schema sml-externalconnections_xsd Drilldown into credentials in schema sml-externalconnections_xsd Drilldown into saveData in schema sml-externalconnections_xsd Drilldown into refreshOnLoad in schema sml-externalconnections_xsd Drilldown into background in schema sml-externalconnections_xsd Drilldown into onlyUseConnectionFile in schema sml-externalconnections_xsd Drilldown into deleted in schema sml-externalconnections_xsd Drilldown into new in schema sml-externalconnections_xsd Drilldown into savePassword in schema sml-externalconnections_xsd Drilldown into minRefreshableVersion in schema sml-externalconnections_xsd Drilldown into refreshedVersion in schema sml-externalconnections_xsd Drilldown into reconnectionMethod in schema sml-externalconnections_xsd Drilldown into type in schema sml-externalconnections_xsd Drilldown into description in schema sml-externalconnections_xsd Drilldown into name in schema sml-externalconnections_xsd Drilldown into interval in schema sml-externalconnections_xsd Drilldown into keepAlive in schema sml-externalconnections_xsd Drilldown into odcFile in schema sml-externalconnections_xsd Drilldown into sourceFile in schema sml-externalconnections_xsd Drilldown into id in schema sml-externalconnections_xsdXSD Diagram of CT_Connection in schema sml-externalconnections_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_Connection">
    <xsd:sequence>
        <xsd:element name="dbPr" minOccurs="0" maxOccurs="1" type="CT_DbPr">
            <xsd:annotation>
                <xsd:documentation>ODBC &amp; OLE DB Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="olapPr" minOccurs="0" maxOccurs="1" type="CT_OlapPr">
            <xsd:annotation>
                <xsd:documentation>OLAP Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="webPr" minOccurs="0" maxOccurs="1" type="CT_WebPr">
            <xsd:annotation>
                <xsd:documentation>Web Query Properties</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="textPr" minOccurs="0" maxOccurs="1" type="CT_TextPr">
            <xsd:annotation>
                <xsd:documentation>Text Import Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="parameters" minOccurs="0" maxOccurs="1" type="CT_Parameters">
            <xsd:annotation>
                <xsd:documentation>Query Parameters</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="id" use="required" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Connection Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sourceFile" use="optional" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Source Database File</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="odcFile" use="optional" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Connection File</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="keepAlive" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Keep Connection Open</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="interval" use="optional" type="xsd:unsignedInt" default="0">
        <xsd:annotation>
            <xsd:documentation>Automatic Refresh Interval</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" use="optional" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Connection Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="description" use="optional" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Connection Description</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="type" use="optional" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Database Source Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="reconnectionMethod" use="optional" type="xsd:unsignedInt" default="1">
        <xsd:annotation>
            <xsd:documentation>Reconnection Method</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshedVersion" use="required" type="xsd:unsignedByte">
        <xsd:annotation>
            <xsd:documentation>Last Refresh Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minRefreshableVersion" use="optional" type="xsd:unsignedByte" default="0">
        <xsd:annotation>
            <xsd:documentation>Minimum Version Required for Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="savePassword" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Save Password</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="new" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>New Connection</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="deleted" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Deleted Connection</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="onlyUseConnectionFile" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Only Use Connection File</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="background" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Background Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshOnLoad" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Refresh on Open</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="saveData" use="optional" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Save Data</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="credentials" use="optional" type="ST_CredMethod" default="integrated">
        <xsd:annotation>
            <xsd:documentation>Reconnection Method</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="singleSignOnId" use="optional" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>SSO Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
dbPr nsM:dbPr 0 1
olapPr nsM:olapPr 0 1
webPr nsM:webPr 0 1
textPr nsM:textPr 0 1
parameters nsM:parameters 0 1
extLst nsM:extLst 0 1
Collapse Child Attributes:
Name Type Default Value Use
id nsM:id Required
sourceFile nsM:sourceFile Optional
odcFile nsM:odcFile Optional
keepAlive nsM:keepAlive false Optional
interval nsM:interval 0 Optional
name nsM:name Optional
description nsM:description Optional
type nsM:type Optional
reconnectionMethod nsM:reconnectionMethod 1 Optional
refreshedVersion nsM:refreshedVersion Required
minRefreshableVersion nsM:minRefreshableVersion 0 Optional
savePassword nsM:savePassword false Optional
new nsM:new false Optional
deleted nsM:deleted false Optional
onlyUseConnectionFile nsM:onlyUseConnectionFile false Optional
background nsM:background false Optional
refreshOnLoad nsM:refreshOnLoad false Optional
saveData nsM:saveData false Optional
credentials nsM:credentials integrated Optional
singleSignOnId nsM:singleSignOnId Optional
Collapse Derivation Tree:
Collapse References:
nsM:connection
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0