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.

asked 10 May '19, 13:40

Terry%20Wilkinson's gravatar image

Terry Wilkinson
746303548
accept rate: 25%

1

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.

(12 May '19, 03:17) Vlad

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 :-)

(12 May '19, 21:49) Terry Wilkinson
Replies hidden

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

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

(13 May '19, 04:48) Volker Barth

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

(13 May '19, 10:14) Terry Wilkinson
Replies hidden

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

(13 May '19, 11:05) Volker Barth

Maybe they are litter-mates :-)

(13 May '19, 14:39) Terry Wilkinson
showing 4 of 6 show all flat view

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;
permanent link

answered 14 May '19, 09:18

Breck%20Carter's gravatar image

Breck Carter
32.5k5407241050
accept rate: 20%

Ah, Foxhound goes DataDog via Python:)

(14 May '19, 10:49) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×18

question asked: 10 May '19, 13:40

question was seen: 1,515 times

last updated: 14 May '19, 10:49