Dodeca Software Docs Docs
Products
Dodeca Drillbridge Next Generation Outline Extractor

Dodeca

    • Release Notes
      • 8.10
        • 8.10.0
      • 8.9
        • 8.9.1
        • 8.9.0
      • 8.8
        • 8.8.1
        • 8.8.0
      • 8.7
        • 8.7.4
        • 8.7.3
        • 8.7.2
        • 8.7.1
        • 8.7.0
      • 8.6
        • 8.6.3
        • 8.6.2
        • 8.6.1
        • 8.6.0
      • 8.5
        • 8.5.1
        • 8.5.0
      • 8.4
        • 8.4.8
        • 8.4.7
        • 8.4.6
        • 8.4.5
        • 8.4.4
        • 8.4.3
        • 8.4.2
        • 8.4.1
        • 8.4.0
      • 8.3
        • 8.3.6
        • 8.3.5
        • 8.3.4
        • 8.3.3
        • 8.3.2
        • 8.3.1
        • 8.3.0
      • 8.2
        • 8.2.3
        • 8.2.2
        • 8.2.1
        • 8.2.0
      • 8.1
        • 8.1.5
        • 8.1.4
        • 8.1.3
        • 8.1.2
        • 8.1.1
        • 8.1.0
      • 8.0
        • 8.0.4
        • 8.0.3
        • 8.0.2
        • 8.0.1
        • 8.0.0
      • 7.8
        • 7.8.8
        • 7.8.7
        • 7.8.6
        • 7.8.5
        • 7.8.4
        • 7.8.3
        • 7.8.2
        • 7.8.1
        • 7.8.0
      • 7.7
        • 7.7.3
        • 7.7.2
        • 7.7.1
        • 7.7.0
      • 7.6
        • 7.6.3
        • 7.6.2
        • 7.6.1
        • 7.6.0
      • 7.5
      • 7.4
        • 7.4.3
        • 7.4.2
        • 7.4.1
        • 7.4.0
      • 7.3
      • 7.2
        • 7.2.2
        • 7.2.1
        • 7.2.0
      • 7.1
        • 7.1.11
        • 7.1.10
        • 7.1.09
        • 7.1.08
        • 7.1.07
        • 7.1.06
        • 7.1.05
        • 7.1.04
        • 7.1.03
        • 7.1.02
        • 7.1.01
        • 7.1.0
      • 7.0
        • 7.0.1
        • 7.0.0
    • Installation Guide
      • Framework Installation Guide
      • macOS Framework Installation Guide
      • License Update Guide
    • Connectors
      • Essbase Connector
      • HFM Connector
      • PBCS Connector
      • Universal Connectors
        • AuraPlayer Connector
        • Copilot Connector
        • Drillbridge Connector
        • GitHub Connector
        • Microsoft Connector
        • OpenAI Connector
        • Oracle Connector
        • SharePoint Connector
        • Zendesk Connector
    • Administrator’s Guide
      • Dodeca Basics
      • Quick Tours
        • Creating a Basic Dodeca Application
        • Creating an Essbase Ad Hoc View
        • Creating an Essbase Excel View
        • Creating a SQL Excel View
      • Advanced Topics
        • Creating a Workbook Script
        • Using Relational Data with SQL Excel and Essbase Excel Views
        • Toolbar Configuration
        • Toolbars Designer
        • Version Control for Dodeca Repository Artifacts
      • Repository Schema Reference
      • Metadata Editor Reference
        • View Property Sets
        • Views and Properties
        • Server Administration
      • View Properties Reference
        • Adhoc Essbase View
        • Composite View
        • Essbase View
        • Excel Essbase View
        • Excel View
        • Hyperion Planning Spreadsheet View
        • Mdx Essbase View
        • Outline Viewer
        • PDF View
        • Report Generator View
        • Report Script Essbase View
        • Reporting Services
        • SQL Excel View
        • Universal Excel View
        • Web Browser View
        • Auto Complete Range
        • Binary Artifact Id And Version
        • Cascade Sheet Info
        • Comment Range
        • Composite View Source View Configuration
        • Data Table Range
        • Distribution Settings
        • Email Settings
        • Ess Properties
        • Essbase Auto Complete Range
        • Essbase Chart Info
        • Named Key Value Pair
        • Power Point Export Range
        • Report Generator Run View Configuration
        • Report Parameter Token Pair
        • SQL Passthrough Data Set Range
        • View Export
      • Connection Properties Reference
        • Amazon Connection
        • Anthropic Connection
        • AuraPlayer Connection
        • Copilot Agent Connection
        • Copilot Connection
        • Credential Source
        • Drillbridge Connection
        • EDM Connection
        • EPM Cloud Planning Connection
        • Essbase Connection
        • GitHub Connection
        • Google Calendar Connection
        • Google Connection
        • HFM Connection
        • HTTP Connection
        • LDAP Connection
        • MCP Connection
        • Microsoft Connection
        • OAuth Connection
        • OpenAI Connection
        • Oracle Connection
        • SQL Connection
        • SharePoint Connection
        • SMTP Connection
        • Zendesk Connection
        • Zendesk OAuth Connection
      • Selector Properties Reference
        • Connection Selector List
        • Connection Selector List Box Properties
        • Connection Selector Tree View Properties
        • DataSet Selector List
        • Date Selector List
        • Delimited String Selector List
        • Essbase Selector List Box Properties
        • Essbase Selector Tree View Properties
        • Generic Text Selector List
        • Name Value Pairs Delimited String Selector List
        • Range Selector List
        • SQL Passthrough DataSet Hierarchy Selector List
        • SQL Passthrough Data Set Selector List
        • SQL Selector Tree View Properties
        • Selector List Box Properties
        • Selector Tree View Properties
        • View Selector Explorer Bar Properties
        • View Selector Explorer Bar Tree Hybrid Properties
        • View Selector Tree Properties
        • Data Set Column
      • Application Properties Reference
        • Application
      • Toolbar Tool Arguments Reference
        • Build View
        • Draw Line Button
        • Draw Shape Button
        • Draw Text Button
        • Essbase Member Operations
        • Essbase Message Viewer
        • Essbase Options
        • Member Select
        • Members Related List
        • Open View For Data Cell
        • Open View For Member Cell
        • Open View
        • Open View Using Retrieve Range State
        • Print
        • Rename Sheet
        • Rich Text Box Task Pane
        • Save Accelerator Install Command File
        • Save Accelerator Uninstall Command File
        • Save As PDF
        • Saved View Manager
        • Show Component
        • Sign On And Set Active Essbase Connection
        • Web Browser Document View
        • Web Browser Task Pane
        • Workbook Script
      • Authentication Service Properties Reference
        • Authentication Provider Properties
        • Dodeca User Roles Properties
        • Domain Authentication Properties
        • Essbase Simple Properties
        • Essbase User Roles From Group Names Properties
        • Essbase User Roles From SQL Passthrough DataSet Properties
        • LDAP User Roles From SQL Passthrough DataSet Properties
        • LDAP User Roles From Group Names Properties
        • Legacy Authentication Properties
        • Oidc Authentication Properties
        • SQL Simple Properties
        • SAML Authentication Properties
        • Single Sign On Authentication Properties
        • Windows User Roles From SQL Properties
        • LDAP Authentication Connection Properties
      • SQL Passthrough DataSet Properties Reference
        • Query
        • SQL Passthrough DataSet
        • Column
        • Primary Key
        • Table Info
      • Binary Artifact Properties Reference
        • Binary Artifact
    • Best Practices
      • Administrative Functionalities
      • Database
      • Staffing
      • Infrastructure and Installations
      • Applications
      • Essbase Connections
      • Selectors and Selector Lists
      • Essbase Scripts
      • SQL Connections
      • SQL Passthrough Datasets
      • View Development
      • Spreadsheet Design
      • Comments
    • Excel Add-In for Essbase
      • Release Notes
        • 8.8.0 and later
        • 8.7.4
        • 8.7.3
        • 8.7.2
        • 8.7.1
        • 8.7.0
        • 8.6.3
        • 8.6.2
        • 8.6.1
        • 8.6.0
        • 8.5.1
        • 8.5.0
        • 8.4.8
        • 8.4.7
        • 8.4.6
        • 8.4.5
        • 8.4.4
        • 8.4.3
        • 8.4.2
        • 8.4.1
        • 8.4.0
        • 8.3.6
        • 8.3.5
        • 8.3.4
        • 8.3.3
        • 8.3.2
        • 8.3.1
        • 8.3.0
        • 8.2.3
        • 8.2.2
        • 8.2.1
        • 8.2.0
        • 8.1.5
        • 8.1.4
        • 8.1.3
        • 8.1.2
        • 8.1.1
        • 8.1.0
        • 8.0.4
        • 8.0.3
        • 8.0.2
        • 8.0.1
        • 8.0.0
        • 7.8.8
        • 7.8.7
        • 7.8.6
        • 7.8.5
        • 7.8.4
        • 7.8.3
        • 7.8.2
        • 7.8.1
        • 7.8.0
        • 7.7.3
        • 7.7.2
        • 7.7.1
        • 7.7.0
        • 7.6.3
        • 7.6.2
        • 7.6.1
        • 7.6.0
        • 7.5.0
        • 7.4.3
        • 7.4.2
        • 7.4.1
        • 7.4.0
        • 7.3.0
        • 7.2.2
        • 7.2.1
        • 7.2.0
        • 7.1.9
        • 7.1.8
        • 7.1.7
        • 7.1.6
        • 7.1.5
        • 7.1.4
        • 7.1.3
        • 7.1.2
        • 7.1.11
        • 7.1.10
        • 7.1.1
        • 7.1.0
        • 7.0.1
        • 7.0.0
      • Installation Guide
    • Dodeca Workbook Script Reference Guide
      • Workbook Scripting Overview
      • Dodeca
      • Essbase
      • Composite View
      • SharePoint
      • Report Generator
      • Workbook Script Extensions
    • Dodeca Shell Reference Guide
      • Getting Started
      • Data Sources
      • JDBC Drivers
      • SQL Commands
      • External Credential Providers
      • Tenant Token Commands
      • General Commands
      • License Commands
      • Server Commands
      • Smart Client Commands
      • Artifacts
      • Artifact Lock Commands
      • Artifact Dependencies
      • Starter Kit Commands
      • Tenants
      • Comments
      • Comment Attachment Commands
      • Saved Views
      • Key Generation
      • Audit Log Commands
      • View Usage Commands
      • Command Reference
      • Known Issues
  • Dodeca
  • Administrator’s Guide
  • SQL Passthrough DataSet Properties Reference

SQL Passthrough DataSet Properties Reference

A complete reference of the properties available on each object type below, generated from the same definitions the SQL Passthrough DataSet editor displays.

SQL Passthrough DataSets

  • Query Properties

  • SQL Passthrough DataSet Properties

Shared Types

These objects appear as expandable sub-properties of the types above.

  • Column Properties

  • Primary Key Properties

  • Table Info Properties

LDAP Authentication Connection Properties Query

© 2026 Dodeca Software