ssml:connection

Connection

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-externalConnections.xsd

Type: ssml:CT_Connection

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:dbPr [0..1] ODBC & OLE DB Properties
2. ssml:olapPr [0..1] OLAP Properties
3. ssml:webPr [0..1] Web Query Properties
4. ssml:textPr [0..1] Text Import Settings
5. ssml:parameters [0..1] Query Parameters
6. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
id	[1..1]	xsd:unsignedInt	Connection ID
sourceFile	[0..1]	ssml:ST_Xstring	Source Database File
odcFile	[0..1]	ssml:ST_Xstring	Connection File
keepAlive	[0..1]	xsd:boolean	Keep Connection Open	Default value is "false".
interval	[0..1]	xsd:unsignedInt	Automatic Refresh Interval	Default value is "0".
name	[0..1]	ssml:ST_Xstring	Connection Name
description	[0..1]	ssml:ST_Xstring	Connection Description
type	[0..1]	xsd:unsignedInt	Database Source Type
reconnectionMethod	[0..1]	xsd:unsignedInt	Reconnection Method	Default value is "1".
refreshedVersion	[1..1]	xsd:unsignedByte	Last Refresh Version
minRefreshableVersion	[0..1]	xsd:unsignedByte	Minimum Version Required for Refresh	Default value is "0".
savePassword	[0..1]	xsd:boolean	Save Password	Default value is "false".
new	[0..1]	xsd:boolean	New Connection	Default value is "false".
deleted	[0..1]	xsd:boolean	Deleted Connection	Default value is "false".
onlyUseConnectionFile	[0..1]	xsd:boolean	Only Use Connection File	Default value is "false".
background	[0..1]	xsd:boolean	Background Refresh	Default value is "false".
refreshOnLoad	[0..1]	xsd:boolean	Refresh on Open	Default value is "false".
saveData	[0..1]	xsd:boolean	Save Data	Default value is "false".
credentials	[0..1]	ssml:ST_CredMethod	Reconnection Method	Default value is "integrated".
singleSignOnId	[0..1]	ssml:ST_Xstring	SSO Id

Used in

Type ssml:CT_Connections (Element ssml:connections)

Sample instance

<ssml:connection id="1" refreshedVersion="1">
   <ssml:dbPr connection="string"/>
   <ssml:olapPr/>
   <ssml:webPr>
      <ssml:tables>
         <ssml:m/>
      </ssml:tables>
   </ssml:webPr>
   <ssml:textPr>
      <ssml:textFields>
         <ssml:textField/>
      </ssml:textFields>
   </ssml:textPr>
   <ssml:parameters>
      <ssml:parameter/>
   </ssml:parameters>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:connection>