Does anyone know of a DataDog integration for SQL Anywhere?

[former_SQLA_member1694873]

As the title says, does anyone know of a DataDog integration for SQL Anywhere?

Integrations exist for quite a few other db products (see https://www.datadoghq.com/product/integrations/#cat-data-store) and I'm hoping to find one for SA17.

[Vlad]

I don't know this product, but I was playing with Zabbix and I think DataDog should have a similar approach as it exists in Zabbix: custom monitoring (https://www.zabbix.com/custom_monitoring). It is where, you write a script (e.g. .bat or .sh) that the agent server executes every X seconds. In the script you run SQL queries and return result (strings, numbers) that the Agent should send to the master node, store it in DB and draw charts.

[former_SQLA_member1694873]

Thanks Vlad. I believe DataDog supports custom integrations (using python scripts) - I may have to go that way if no-one has already done one. Otherwise I will learn to use SAP Cockpit, although it would be nice to have everything integrated with the DataDog dashboard 🙂

[VolkerBarth]

Hm, SQL Anywhere's data dog is called "Foxhound"🙂

(Don't get me wrong, it's a different product, not related to DataDog...)

[former_SQLA_member1694873]

I had forgotten about Breck's product - my bad - thanks Volker.

[VolkerBarth]

Well, I just couldn't withstand to make pun of the animal connection:)

[former_SQLA_member1694873]

Maybe they are litter-mates 🙂

[Breck_Carter]

The Foxhound database monitor stores performance metrics and alerts in its own SQL Anywhere database, and that database is completely open to realtime adhoc queries.

For more information see the White Paper.

Version 4 is currently available and Version 5 is in the final stages of testing... Version 5 will be available for free to anyone who purchases Version 4 now.

Here's one of the adhoc query examples...

Active alerts for each target database

SELECT IF sampling_options.selected_tab = 1 
          THEN 'DSN' 
          ELSE 'String' 
       END IF AS connection_type,
       sampling_options.selected_name AS target_database,
       alert_union.*
  FROM sampling_options
          INNER JOIN alert_union
          ON alert_union.sampling_id = sampling_options.sampling_id
 WHERE alert_union.record_type                 = 'Alert'
   AND alert_union.alert_is_clear_or_cancelled = 'N'
 ORDER BY target_database ASC,
       alert_union.sample_set_number DESC;

[VolkerBarth]

Ah, Foxhound goes DataDog via Python:)