Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

What type of connector can be used to interact with a database, MySQL for instance?

Solved703 views31st October 2023virtual connections
1
Dennis Nacorda182 28th October 2023 0 Comments

Dear Dojo,

What type of connector can be used to interact with a database, MySQL for instance? I have read that "virtual" connection can be used, but I can't seem to find enough documentation on this type of connection to write a protocol.

May I ask if there are any links, tutorial or documentation for virtual connection. Or if there are example protocols.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 31st October 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
5
Ben Vandenberghe [SLC] [DevOps Enabler]9.06K Posted 28th October 2023 0 Comments

Hi Dennis - data can be fetched with either a connector or with an ad hoc data source.  The choice is defined by the use case you have.  What is the difference:

  • A connector will talk to the database continuously, fetching data from it, and create a managed object in DataMiner (visible in your surveyor tree, aka an element).  That object will then contain all the data that you fetched, and can then be used for a variety of use cases, such as alarming on metrics, trending, be part of automation procedures, correlation, etc.  The connector will define when to fetch data, at which intervals and all that.
  • An ad hoc data source will not create such a managed object.  The ad hoc data source is only available in dashboards and user-definable apps (you can select it there as part of a GQI query - which will then allow you to further manipulate the data, like filtering and aggregating data).  The data of an ad hoc data source will only be fetched when the dashboard or user-definable app using it is opened by a user.  In other words, the data is not fetched continuously in the background, and cannot be used for functions such as alarm monitoring, trending, etc.

If you are interested in ad hoc data sources, you can read all about it over here: Get ad hoc data | DataMiner Docs

If you are looking to build a connector, you would get started over here: About DataMiner connectors | DataMiner Docs

You could either make a connector tailored to your specific needs (because a MySQL  database is a very generic source, and could have a broad range of data sets and structures to be dealt with, for a wide range of use cases - so the most optimal solution could be something tailored to that specifically).

Then again, we also have a Generic MySQL Query connector, which provides a general implementation of an interaction with a MySQL database.  You can use that driver to fetch data from a MySQL database, just by configuring such an instance through it data display UI. Or it can also serve as a sample for you on how a connector can interact with MySQL (in case you want to develop something from scratch to have a tailored solution for your specific database and your specific use case).

Our catalog is not fully launched, so you might not be able yet to get that connector loaded on your DataMiner System (we are working on a new version of the catalog that will launch soon, and all connectors will then be accessible for everybody, also the ones that are not licensed - just to facilitate the work of DevOps professionals).  But let us know what you need and we'll make sure you get it, and get going with your work.

Cheers

Ben

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 31st October 2023
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (109) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin