How to query data from a database

Follow

Wayne Taylor

• November 14, 2015 15:21

Is there a way to feed in data to sumo using result sets generated from a database?

e.g. I have a transactional table that stores all my purchases and i want to perform an aggregate by product/product type per day and push the results that can be fed into sumo so that I could have graphs over time for example on my dashboard.

1

• 

  Wayne Taylor

  • November 15, 2015 15:39

  Sorry about the duplicate post. I got an error posting and resubmitted.

  0

  Comment actions Permalink
• 

  Dwayne Hoover

  • November 16, 2015 14:23

  Hi Wayne

  You can accomplish this using a script source. Write a quick python/bash/perl/etc... script to hit the db and return data and the collector can ingest it. I have a few examples if you're looking for a particular DB platform (MySQL, postgres, Oracle...)

  Thanks!

  1

  Comment actions Permalink
• 

  Wayne Taylor

  • November 16, 2015 22:23

  Hi Dwayne, thanks for the quick response. an example of SQL server and MySQL would be great.

  Thanks
  Wayne

  0

  Comment actions Permalink
• 

  Bill Sim

  • January 30, 2018 02:11

  Hi Dwayne,

  This thread is pretty old, but I wonder if you have an example script source for pushing up data for a MySQL table you can share?

  Bill

  0

  Comment actions Permalink

Please sign in to leave a comment.