Administration guide

Contents:

• Introduction
  • Responses that you can expect
  • About this guide
• Deployment architecture
  • Data sources
  • Qbo server
• Deployment options
• Product installation
  • Prerequisites
    • Install and configure the internal database
      • Install MariaDB
      • Configure MariaDB
      • Secure MariaDB
      • Configure MariaDB connections
      • Populate MariaDB time zone tables
      • Create MariaDB user for Qbo connection
      • Use a non-default MariaDB configuration
    • External dependencies
      • Install OpenResty
      • SSL certificate
  • Install Qbo
    • Extract the tarball
    • Run the installer
    • Configuring web proxy
      • Configure a DNS CNAME Entry to point to Qbo (Optional)
      • Obtain an SSL certificate
      • Configure Apache httpd
      • Configure nginx
      • Test and troubleshoot the web proxy installation
• Product start/stop
  • Start & stop services
    • Check shell environment configuration
    • Start Qbo services
    • Issues while starting the service:
    • Check that Qbo services are running
    • Stop Qbo services
  • Logs
  • Common errors
• One time setup
  • Administrator password
• Product settings
  • Concept dictionary
    • Concepts with synonyms
    • Unsupported concepts
  • Channels
  • Usage metrics
  • Organizational settings
  • User & role management
    • Users
      • Forgot password
    • Roles & Permissions
    • LDAP configurations
      • Active Directory
      • OpenLDAP
    • OAuth configurations
      • Register an application
      • Configure Qbo
    • Signup applications
      • Auto process configuration
      • Registration page for users
  • External services
  • Configuration
    • Bot Command Response
    • Unteach Qbo
    • Explore Data
    • Dialog message generation
    • Qgram
  • License management
• Data source configuration
  • New data source
    • On-premises data sources
    • Cloud data sources
      • Athena
      • HubSpot
      • Salesforce
      • Snowflake
      • AzureSQL
      • BigQuery
      • Databricks
      • AzureSynapse
      • Redshift
      • SAP HANA
    • File upload
      • Excel
      • SQLite
    • Data Source Settings
    • Revert to an older version of the draft in data source configuration
  • Configure the data model
    • Entity configurations
    • NLP Synonyms
    • Composite date attributes
    • Named filters
    • Named aggregates
    • Aggregate Phrase
    • Entity Usage Name
    • Aggregated Attribute Type
    • Aggregate function
    • NLP synonyms
    • Display Configurations
    • Referencing named aggregate
    • Referenced entities
    • Delete an entity
    • Add an entity
    • Validate Models
    • Attributes of an entity
    • Value Substitutes
    • Description
    • Grammar generation configuration
    • Display configuration
    • Synonyms
    • Derived attribute
    • Delete multiple attributes
    • Sample rows
• Overall Analytics Framework
• Analytics configuration
  • Variance Analysis
    • Types of variance analysis
    • Diagnosis of Variance
    • Variance Importance Score
    • Elements of variance analysis configuration
      • Data source & placeholders
      • Behavioral aspects
      • Component aspects
    • Example
    • Automated Insights
      • Global configuration
      • Entity level configuration
  • Correlation Analytics
  • Variance with Correlations
  • Association Rule
  • Clustering Analytics
  • Time Series Analytics
  • Save, Deploy & Reload
  • Data access roles
• Audit Logs
  • Board Report
  • Password Changed
  • Channel
  • PDF Downloaded
  • Vizy Downloaded
  • License Uploaded
  • Query Bot executors draft models
  • Query Bot Executor
  • Query Bot Interaction
  • Password Reset
  • Role Based Entitlement management
  • Role management
  • Vizy shared
  • Signup application
  • User account activity
  • User invitation
  • User management
• Troubleshooting
  • Issues
    • Qbo responds with Sorry, I’m unable to generate the vizy
    • Long strings not allowed
  • Migrate Qbo mapping from dev to QA/Prod
    • 1. Export the data model:
    • 2. Change the data model:
    • 3. Import the data model
  • Update existing mapping if database column is changed
    • 1. Export the data model
    • 2. Change the data model:
    • 3. Upload the data model
• Miscellaneous
  • UEL
    • The Unscrambl Chai Expression Language (UEL)
      • Introduction
      • Types
      • Literals
      • Arithmetic operations
      • Comparison operations
      • Logical operations
      • Ternary operation
      • List Operations
      • Precedence and Associativity of Operations
      • Attributes
      • Null values
      • Database specific behaviors
      • Built-in functions
  • UEL Builtin Functions
    • datetime functions
      • datetime.add
      • datetime.component
      • datetime.dayOfWeek
      • datetime.diffInSeconds
      • datetime.fromString
      • datetime.fromComponents
      • datetime.now
    • number functions
      • number.ceil
      • number.floor
      • number.log
      • number.power
      • number.round
      • number.toString
    • string functions
      • string.coalesce
      • string.concat
      • string.contains
      • string.endswith
      • string.lower
      • string.ltrim
      • string.rtrim
      • string.startswith
      • string.substring
      • string.trim
      • string.toInteger
      • string.upper
    • Generic Type Classes