What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

SQL Data Extractor

Votes:

0

Your Vote:

Up

Down

Wondering if anyone is using this in a production environment. I have roughly 11,000 sensors. And am struggling to get this to export to SQL?

What set are you using to get this done ? Thanks

database prtg sql

Created on May 7, 2015 8:01:46 PM by  kube1984 (560) 3 1



Best Answer

Accepted Answer

Votes:

2

Your Vote:

Up

Down

Hello all,

if you are looking for data extraction from PRTG to SQL / Oracle database, try our new

PRTG Data Pump

or check our video for a first information

https://youtu.be/uYObBq5QXlE

You can download for free and test for 30 days.

Main features:

  • supports PRTG Enterprise
  • export from multiple PRTG servers into 1 database
  • export to any number of DBs you need
  • export to MSSQL or Oracle (more DBMS types coming)
  • continuous automatic exporting to keep SQL data in sync
  • smart sensor filtering to automatically include new sensors in export
  • and more...

Feel free to contact our support team if you have any questions at [email protected]


Produced by CORP IT, Paessler Uptime Aliance Partner

Created on Feb 12, 2020 2:57:30 PM by  Thomas Wächter (180) 2 1

Last change on Dec 4, 2020 11:10:17 AM by  Florian Lesage [Paessler Support]



6 Replies

Votes:

0

Your Vote:

Up

Down

Hi,

What exactly do you want to export?

Created on May 8, 2015 7:06:49 AM by  PRTG Tools Family [prtgtoolsfamily.com] (13,413) 3 4



Votes:

0

Your Vote:

Up

Down

advanced reporting, say a weighted server report, we have a reporting department that writes all our reports and would be able to leverage a lot more of PRTG

Created on May 13, 2015 11:44:09 PM by  kube1984 (560) 3 1



Votes:

0

Your Vote:

Up

Down

What exact problems do you experience? Long execution time?

Created on May 14, 2015 11:30:52 AM by  Stephan Linke [Paessler Support]



Votes:

0

Your Vote:

Up

Down

yeah, that's really the only issue I have, is long execution....yesterday I did a robo copy of the datastore for PRTG to a dedicated server, disabled the probe service and started it again to see if I could cut it down.......in the previous attempt I was using 4 vm servers, processing 2500 sensors and it took each one 15 hours to complete.

Created on May 14, 2015 12:28:53 PM by  kube1984 (560) 3 1



Votes:

0

Your Vote:

Up

Down

That's actually one of the problem the tools has with larger installations. We're aware of it and trying to improve the extractor in the future. Although this might take a while, I'm afraid :/

Created on May 14, 2015 2:41:16 PM by  Stephan Linke [Paessler Support]



Accepted Answer

Votes:

2

Your Vote:

Up

Down

Hello all,

if you are looking for data extraction from PRTG to SQL / Oracle database, try our new

PRTG Data Pump

or check our video for a first information

https://youtu.be/uYObBq5QXlE

You can download for free and test for 30 days.

Main features:

  • supports PRTG Enterprise
  • export from multiple PRTG servers into 1 database
  • export to any number of DBs you need
  • export to MSSQL or Oracle (more DBMS types coming)
  • continuous automatic exporting to keep SQL data in sync
  • smart sensor filtering to automatically include new sensors in export
  • and more...

Feel free to contact our support team if you have any questions at [email protected]


Produced by CORP IT, Paessler Uptime Aliance Partner

Created on Feb 12, 2020 2:57:30 PM by  Thomas Wächter (180) 2 1

Last change on Dec 4, 2020 11:10:17 AM by  Florian Lesage [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.