Jump to Content
AnodotRevenueAnodotRevenue
HomeGuidesAPI ReferenceDiscussions
v1.0

Log InAnodotRevenue
Guides
Log In
v1.0HomeGuidesAPI ReferenceDiscussions

Getting Started

  • Anodot in a Nutshell
    • What is Anodot?
    • Anodot Workflow
    • Getting Data into Anodot
    • Creating Alerts
    • Viewing Alerts
    • Investigating Alerts
  • Next Steps
    • Inviting your Team
    • Introducing the Anodot UI
    • Using Dashboards and Anoboards
    • Getting Alert Notifications
    • Key Terms and Concepts
    • Getting Support from Anodot
  • Best Practices
    • Influencing Metrics
    • Influencing Events
    • Suppressing Events
    • Office Hours Events
    • Dynamic Routing of Alerts
    • Assigning Alerts

Metrics

  • Overview
    • Metrics Overview
    • Metric Expressions
    • Searching for Metrics
    • Calculated Metrics
    • Managing delays in Composite Metrics
    • Measuring Business Impact
    • Enrich Metrics with Tags
    • Tagging use case
  • Tutorials
    • Tutorials Overview
    • Displaying metrics
    • Finding the Average of a Series
    • Displaying Metrics in Groups
    • Replacing Metric Names with Property Name
    • Generating an Expression Tree with Multiple Expressions
    • The ratioPairs Function
  • Metric Functions
    • Metric Function List and Availability
    • Function Element Types
    • Absolute
    • addConstant
    • Alias
    • AliasByGroup
    • AliasByProperty
    • Alphanumeric
    • AsPercent
    • AverageAbove
    • AverageBelow
    • AverageSeries
    • Changed
    • CountSeries
    • CountZeros
    • CumulativeSum
    • CurrentAbove
    • CurrentBelow
    • Delta
    • Derivative
    • DivideSeries
    • expMovingAverage
    • Group
    • GroupBy
    • HighestAverage
    • HighestCurrent
    • HighestMax
    • Invert
    • IsNonNull
    • KeepBetweenPercentiles
    • KeepLastValue
    • Log
    • LowestAverage
    • LowestCurrent
    • LowestMin
    • MADDistSeries
    • MADSeries
    • MaximumAbove
    • MaximumBelow
    • MaxSeries
    • MinimumAbove
    • MinimumBelow
    • MinSeries
    • MostDeviant
    • MovingAverage
    • MovingMax
    • MovingMedian
    • MovingMin
    • MovingSum
    • MultiplySeries
    • NonNegativeDelta
    • NonNegativeDerivative
    • Offset
    • OffsetToZero
    • Pairs
    • PercentMissingValues
    • PercentileSeries
    • Pow
    • ratioPairs
    • RemoveAboveValue
    • RemoveBelowPercentile
    • RemoveBelowValue
    • RemoveNonEmpty
    • Scale
    • ScaleToSeconds
    • StdSeries
    • SubtractSeries
    • Summarize
    • summarizeToDate
    • SumSeries
    • TimeShift
    • TransformNull

Alerts

  • Overview
    • Alerts Overview
    • Alert Console
    • Alert Management
    • Insights Panel
    • Closing Alerts
    • Alert Trigger lifecycle
  • Creating Alerts
    • Creating New Alerts
    • Using the Minimum Impact Condition
    • Creating Static and No Data Alerts
    • Defining Advanced Alert Conditions
    • Assigning Alerts
    • Applying Variables to Alert Names and Descriptions
    • Creating Anomaly Alerts on Dashboard Tiles
    • Managing Alert Channels
    • Alert Notification Examples
  • Recommendations
    • Recommendations Overview
    • Using and managing Recommendations

Anomalies

  • Overview
    • Anomalies Overview
    • Creating an Anoboard Tile
    • Managing the All Anoboards Window
    • Presentation logic
  • Investigation
    • Investigating Anomalies
    • Alert Triage
    • Viewing the Latest and Previous Anomalies
    • Filtering Anomalies
    • Anomaps
    • Anomaly Charts
    • Commenting on an Anomaly Group
    • Actions

Dashboards

  • Overview
    • Dashboard Overview
    • Dashboard Views and Filters
    • Upgrading from Classic Dashboards to V2.0
  • Creating & Configuring Dashboards
    • Create a New Dashboard
    • Dashboard Edit Mode vs View Mode
    • Graph Tiles
    • Single Metric Tiles
    • Text Tiles
    • Pie Chart and Donut Chart Tiles
    • Managing your Dashboard and tiles
    • Importing and Exporting Dashboards
  • Classic Dashboards
    • Dashboard Overview
    • Main Dashboard Window
    • Creating Dashboards
    • Viewing Dashboard Tiles
    • Dashboard Icons
    • Creating a Dashboard Chart Tile
    • Customizing Charts
    • Creating a Meter Tile
    • Customizing a Meter
    • Creating a Dashboard Free Text Tile
    • Viewing Chart and Metrics Tiles
    • Updating Chart and Meter Tiles
    • Exporting and Importing Dashboards
    • Copying a Dashboard Tile
    • Selectors
    • Creating Selectors
    • Adding a Selector to an Expression
    • Using Dependency Groups
    • Time Range and Time Scale
    • Setting a Custom Time Range per Chart or Meter Tile
    • Zooming in on Charts

Management

  • Events
    • Events Overview
    • Viewing Events in Dashboards
    • Filtering Event Presets in Dashboards
    • Managing Event Categories
    • Managing Event Sources
    • Event Streaming Overview
    • Correlating Events with Anomalies
  • Asset Management
    • Asset Management Overview
    • Lookup Tables
    • Dynamic Routing Tables
  • User Management
    • Login and API URLs
    • Roles and Permissions
    • Role Based Access Control (RBAC)
    • Authentication Page
    • Google OAuth Authentication
    • Single Sign-On using Azure Active Directory
    • SAML SSO Authentication
    • Configuring SAML 2.0 for Okta
    • Configuring SAML 2.0 for Google
    • Configuring Anodot in Google Apps
    • Managing Users and Groups
    • Multiple Accounts
    • Saving Resources of Deleted Users
  • Monitoring
    • Anodot Activity Log
    • Anodot Service Usage
    • Anodot System Notifications
    • Anodot Health Status

Integrations

  • Start Here
    • Integration Overview
  • Data Collectors Overview
    • Introduction to Collecting and Streaming Data
    • Editing Live Data Streams
    • Fill data gaps using Anodot collectors
    • Stream Tables
    • Mapping Dimensions to Measures
    • Stream Summaries
    • Guidelines by Data Source Type
    • Google Service Accounts
    • Updating Source Credentials for Existing Sources
  • Data Collectors: Business Packages
    • AWS Cost Monitoring
    • AWS CUR Data Source Configuration
    • Facebook Ads
    • Google Analytics
    • Google Analytics GA4
    • Google Ads
    • Google Auction Insights
  • Data Collectors: Storage
    • Amazon S3
    • Providing read access for Anodot using a cross-account AWS role
    • Amazon S3 Parquet
    • File Upload
    • Google Storage
  • Data Collectors: Monitoring
    • Google Search
    • Mixpanel
    • Salesforce Collector
  • Data Collectors: Databases
    • Creating a Stream Query from a Database
    • Amazon Athena SQL
    • Amazon Timestream
    • Amazon Redshift
    • Databricks
    • Google BigQuery
    • MariaDB
    • Microsoft SQL Server
    • MySQL
    • Oracle Database
    • PostgreSQL
    • Snowflake
    • Teradata JDBC
  • Data Collectors: Data Streams
    • Azure Event Hubs
    • Amazon Kinesis
    • Enable Reading from the Kinesis Stream
    • mParticle
  • Data Collectors: APM
    • Coralogix
    • Datadog
    • New Relic
    • Sumo Logic
  • Additional Data Collectors
    • Segment
    • Rivery Integration
    • Adobe Analytics
  • Agents and Open Source Collectors
    • Anodot Agent Overview
    • Apache Kafka Agent
    • Anodot Prometheus Collector
    • Legacy Agents Overview
    • Using collectd
    • Using Statsd
    • Using Anodot Relay
    • Using Coda-Hale Metrics
    • Anodot Agent - SQL to S3
  • Anodot REST API
    • Anodot API Overview
    • Token Management
  • Alert Channels
    • Alert Channels Overview
    • Anodot Email integration
    • Anodot Slack Application integration
    • Anodot PagerDuty integration
    • Anodot JIRA integration
    • Anodot Opsgenie integration
    • Anodot Microsoft Teams integration
    • Anodot Microsoft Teams (Workflow App) integration
    • Anodot TamTam Chat integration
    • Anodot Telegram integration
    • Anodot AWS SNS integration
    • Anodot Mattermost integration
    • Anodot ETL Channel (Rivery)
    • Anodot PowerBI integration
    • Anodot Salesforce Integration
    • Anodot ServiceNow Integration
    • Anodot Slack integration (Legacy)
    • Anodot Webhook integration
    • Allowlist Anodot Servers

Forecast

  • Getting Started with Anodot Forecast

Resources

  • Sample Data Sets
    • Site Traffic Use Case
    • Business Packages
    • Rideshare Use Case
    • Ad Tech Use Case
    • eCommerce Use Case

FAQs

  • Facts and more
    • Facts & Figures
    • Anodot - GDPR Readiness
    • A/B Tests Done Correctly - Using Anodot to Run and Monitor A/B tests
  • Alerts
    • Minimum Metrics in an Anomaly: Use Case
    • Why can’t I see the alert rate estimate when tuning the alert settings?
    • Why didn't my alert trigger?
    • Why do I get multiple email notifications for the same anomaly?
    • Why do I get identical, double email notifications for the same alert?
    • Alerts Use Cases
    • Introducing the new Anodot detection engine
  • Anomalies
    • Why should I click the feedback button?
    • How does Anodot correlate anomalies?
    • How does Anodot calculate the delta of an anomaly?
    • In the anoboard, why am I seeing two different scores in what seems like a single, continuous anomaly?
  • Security
    • Indirectly accessing a database
    • Keep database names internal
  • Integration
    • SQL queries time pattern and the collection interval
    • Data types allowed as Timestamp
    • Reduce data stream processing time
    • Cannot find Google Analytics measure/dimension
    • Delay settings in the Google Analytics collector
    • Anodot S3 Collector Timezone settings
    • Handling long property values
    • Could not find a collector, what's next?
    • Sending data from multiple data silos to Anodot
    • Preparing a Data Set for AWS S3
    • Understanding Stream Delay and Backfill Policy
  • Data validation
    • Data Aggregation per Time-scale
    • My metric is missing a baseline. Why?
    • Why can’t I find my data in Anodot?
    • Why do I see doubled metric values in Anodot?
  • Functions use cases
    • Functions use case catalogue
    • GroupBy function: Count vs. Sum
    • Group and GroupBy comparison

Anodot On-Premise Documentation

  • Version 4.0 Documentation
    • What's New in Version 4.0?
    • On Premise Installation Guide Version 4.0
    • On Premise User Guide Version 4.0
  • Version 3.2 Documentation
    • What's New in Version 3.2?
    • On Premise Installation Guide Ver 3.2
  • Version 3.0 Documentation
    • What's New in Version 3.0?
    • Anodot API Reference (For On Premise)
    • On Premise Installation Guide Ver 3.0
  • Version 2.2 Documentation
    • On Premises Installation Guide V2.2
    • On Premises User Guide V2.2
Powered by 
  1. Integrations

Data Collectors: Databases

Supported database types

  • Amazon Athena SQL
  • Amazon Timestream
  • Amazon Redshift
  • Databricks
  • Google BigQuery
  • MariaDB
  • Microsoft SQL Server
  • MySQL
  • Oracle Database
  • PostgreSQL
  • Snowflake
  • Teradata JDBC

Updated over 1 year ago


Salesforce Collector
Creating a Stream Query from a Database
Did this page help you?
    • Supported database types