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
    • Courses
    • Tutorials
    • Certification
      • DataMiner Operator
      • DataMiner Administrator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
    • Video Library
    • Books We Like
    • Third-party Courses
    • DevOps Enablement Services
    • Quizzes
  • RESOURCES
  • 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)
  • Expert Hubs
    • DataMiner DevOps Professional Program
    • DataMiner
      • DataMiner Releases & Updates
      • System Architecture
      • Integration Studio
      • Visual Overview
      • Security
    • Technologies
      • Converged Interconnect Networks
      • DOCSIS 3.1 / DAA
      • Kubernetes
      • Telemetry / Flow Monitoring
      • PTP
      • SDN / ST2110 / NMOS
    • Business
      • Software Business models
      • Perpetual Use or Usage-based Services
      • Storage as a Service (STaaS)
  • Discover
    • Markets
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Solutions
    • Use Case Library
    • DataMiner Dashboards
    • DataMiner Downloads
    • DataMiner Modules
      • Core features
      • SRM features
    • DataMiner Apps
    • Professional Services
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • Pricing
  • More
    • Feature Suggestions
    • Online DataMiner Systems
    • Leaderboard
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
    • Verify a certificate
  • >> Go to dataminer.services

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

Solved127 views31st October 2023virtual connections
1
Dennis Nacorda44 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 Enabler] Selected answer as best 31st October 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
5
Ben Vandenberghe [SLC] [DevOps Enabler]7.03K 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 Enabler] Selected answer as best 31st October 2023
Please login to be able to comment or post an answer.

My Dojo Points

0 Credits
0 Reputation

Question Tag Cloud

adl2099 (58) Alarm Console (55) alarms (72) alarm template (62) Automation (150) automation scipt (74) Automation script (103) backup (55) C++ (37) Cassandra (149) cloud (38) Connector (48) Correlation (42) Cube (120) Dashboard (142) Dashboards (142) database (67) DataMiner Cube (42) DIS (57) DMS (48) DOM (81) driver (52) DVE (45) Elastic (76) Elasticsearch (100) elements (53) Failover (91) GQI (64) HTTP (50) IDP (59) low code app (81) low code apps (50) lowcodeapps (39) MySQL (52) protocol (153) QAction (61) resources (36) security (74) SNMP (61) SRM (286) SRM resources (39) trending (69) upgrade (47) Visio (392) Visual Overview (301)
Privacy Policy • Terms & Conditions • Contact

© 2023 Skyline Communications. All rights reserved.

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