• Welcome to OZ Query Designer
• Store
  • Database store
    • Add store
      • DB connection setup
        • Using dialog
        • Using alias
        • Using user defined parameter
      • DB Initial/Final Query
    • Add dataset
  • NoSQL store
    • Add store
    • Add dataset
  • UDS(User data store)
    • Add store
    • Add dataset
    • Add user field
  • Group data store
    • Add store
    • Add dataset
    • Dividing dataset
      • Vertical division
      • Horizontal division
  • File store
    • Add dataset
      • XML dataset
      • CSV dataset
      • Dynamic XML dataset
      • Dynamic CSV dataset
    • File specification
      • XML file specification
      • CSV file specification
  • HTTP store
    • Add dataset
      • XML dataset
      • CSV dataset
      • Dynamic XML dataset
      • Dynamic CSV dataset
  • SOAP store
    • Add store
    • Add dataset
      • Design view mode
      • Manual mode
  • ADO DataSet web service store
    • Add store
    • Add dataset
  • XML store
    • Add store
    • Add dataset
      • Design view mode
      • Manual mode
  • SAP store
    • Add store
    • Add dataset
  • CLEAR QUEST store
    • Add store
    • Add dataset
• Dataset design
  • Manual mode
  • Design view mode
    • Selecting table
    • Creating join
    • Adding fields
    • Sort order
    • Query view
    • Executing query
  • Master-detail dataset
  • Dynamic dataset design
  • Multi-dataset design
  • Procedure dataset design
  • Add user defined parameter
  • Add calculated field
  • Add dataset using INCLUDE ODI
  • Compiled SQL design
• OZ Query component
  • OZ data tree
    • Ignore Null Data
    • User-Defined Parameter Marker
    • ConcurrentFetchSize
    • Connection Position
    • Allow DataService
    • Display zero before the decimal point
    • Ignore Script Error
  • OZ data store
    • Database Store
      • Name
      • User Name
      • JDBC Driver
      • DB Alias
      • Alias Name
      • DB Alias Filename
      • Auto Commit
      • Vendor
      • DataAction Class
      • DataAction Initialization Parameter
    • User Data Store
      • Name
      • Class Name
      • Define field information manually
    • Group Data Store
      • Name
      • Source Dataset
    • SOAP Store
      • Name
    • ADO DataSet web service store
      • Name
    • XML Data Store
      • Name
    • SAP Data Store
      • Client Name
      • Language
      • Host Name
      • System Number
      • DataAction Class
      • DataAction Initialization Parameter
      • SID
    • CLEAR QUEST Store
      • Name
  • OZ dataset
    • DATABASE STORE Dataset
      • Name
      • SQL Statement
      • Marster Set
      • Maximum Rows
      • Compiled SQL Statement
      • JDBC Fetch Row
      • Script
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstROW
      • Send data before binding
      • Send data after binding
      • Query Timeout
      • Ignore Query Errors
      • Description
    • Dynamic Dataset
      • Name
      • Master Set
      • Maximum Rows
      • Starting Row Number
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Compiled SQL Statement (Source Dataset)
      • Use Script (Source Set)
      • Send data before binding
      • Send data after binding
      • Query Timeout
      • Ignore Query Errors
      • Description
    • Multi Dataset
      • Name
      • SQL Statement
      • Master Set
      • Compiled SQL Statement
      • Script
      • Query Timeout
    • Procedure Dataset
      • Name
      • Procedure name
      • Procedure type
      • Target parameter
      • Master Set
      • Query Timeout
    • USER DATA STORE Dataset
      • Name
      • Statement
      • Master Set
      • Maximum Rows
      • Script
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • GROUP STORE Dataset
      • Name
      • Statement
      • Master Set
      • Consume Row
      • Maximum Rows
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • FILE STORE XML Dataset
      • Name
      • Master Set
      • Maximum Rows
      • Dataset Node Name
      • RecordsetNode Name
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • FILE STORE CSV Dataset
      • Name
      • Master Set
      • Maximum Rows
      • Field Delimiter
      • Line Delimiter
      • Character Set
      • Null Mark
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • HTTP STORE XML Dataset
      • Name
      • Master Set
      • Maximum Rows
      • Dataset Node Name
      • Recordset Node Name
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • HTTP STORE CSV Dataset
      • Name
      • Master Set
      • Maximum Rows
      • Field Delimiter
      • Line Delimiter
      • Character Set
      • Null Mark
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • SOAP STORE Dataset
      • Name
      • Master Set
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Base XPath
      • Description
    • ADO DataSet WebService Dataset
      • Name
      • Master Set
      • EndPoint
      • SOAPAction
    • XML STORE Dataset
      • Name
      • Master Set
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • SAP STORE Dataset
      • Name
      • Dataset
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
    • CLEAR QUEST STORE Dataset
      • Name
      • Type
      • Master Set
      • Maximum Rows
      • Use Script
      • Hidden
      • ConcurrentFetchSize
      • ConcurrentFirstRow
      • Send data before binding
      • Send data after binding
      • Description
  • OZ data field
    • Dataset field
      • Name
      • Type
      • Decryption
      • Description
    • SOAP dataset field
      • Name
      • Type
      • XPath
      • Decryption
      • Description
    • XML dataset field
      • Name
      • Type
      • XPath
      • Decryption
      • Description
  • User defined parameter
    • Name
    • Type
    • Value
    • Encryption
    • Session Key
    • Description
  • Include field
    • Name
    • OZURL
• Reference
  • Environments setup
    • Working Folder
    • Designer options
    • Database options
    • Editor options
  • Repository server
    • Setting repository server
    • Connect and disconnect repository server
    • Open file from repository server
    • Managing categories and items
    • Check in and out
    • Show history
    • Find items
  • File path setup
  • Character sets and available alias