Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Jun 29, 2017 9:28 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Export data to another database
PostPosted: Tue Feb 10, 2015 3:59 am 
Offline

Joined: Tue Feb 10, 2015 3:56 am
Posts: 11
Hi,

I got simple Cacti installation on CentOS 6.5 server.
I monitor Access Point's traffic.

We need collect these data into Oracle Database.
So I need auto/manually export it.

Is there any option?

Thanks.


Top
 Profile  
 
 Post subject: Re: Export data to another database
PostPosted: Tue Feb 10, 2015 9:21 am 
Offline
Developer

Joined: Thu Apr 07, 2005 3:29 pm
Posts: 2564
Location: B/CS Texas
Your options.

1. Manually export the data from the RRDs to XML
2. Write a script to export the data from the RRDs to XML
3. Write a plugin to capture the data before Cacti puts it in the RRD, and also send it to the other database

With any of these options, you are basically on your own, as its outside the scope of what the software was meant to do.

Also see
desscartes @ Write rrd files to MS Sql server,is it possible??
where someone was asking to do it with MSSQL

_________________
CactiEZ CD


Top
 Profile  
 
 Post subject: Re: Export data to another database
PostPosted: Tue Feb 10, 2015 1:10 pm 
Offline

Joined: Tue Feb 10, 2015 3:56 am
Posts: 11
Hi,

First of all thanks for details, I will check later on.
I have to ask one more question if you don't mind...

As all these will be implemented manually, so there is no way to export it automatically?...
I am cacti will insert data to some database simultaneously ....

Thanks again.
Note: I am first time in this Cacti forum :)


Top
 Profile  
 
 Post subject: Re: Export data to another database
PostPosted: Tue Feb 10, 2015 1:39 pm 
Offline
Developer

Joined: Thu Apr 07, 2005 3:29 pm
Posts: 2564
Location: B/CS Texas
Option 3 above would be automatic, 2 could be automatic depending on how you wrote the script.

_________________
CactiEZ CD


Top
 Profile  
 
 Post subject: Re: Export data to another database
PostPosted: Tue Feb 17, 2015 7:37 am 
Offline

Joined: Tue Feb 10, 2015 3:56 am
Posts: 11
Hi,

I kind now can get network availability report.
For me key task is collect each host's (WiFi access point in my case) throughput, then we can query thing like, total down/upload for day etc.

Thanks.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group