N-Central Poor Mans Report Manager

Written by James McDonald

January 31, 2022

The problem with N-Central Report Manager is that it is only supported using a rather old version of SQL (Something like 2016). If you use the MAPS (Microsoft Action Pack Subscription) you only get licenses for the latest versions (SQL Server 2019)

Inspired by a reddit post

Option 1: Data Export to SQL Server

I would need to check that this would allow to export to SQL Server 2019 but this would be OK if staying in a Windows centric world. I wonder if this would keep exporting and so keep data greater than 90 days.

Under https://<yourncentralserver>:10000/ Setup => Data Export you can configure a connection to an SQL server

Option 2 – Postgres Restore from Backup Dump

A work-a-round perhaps… I haven’t as yet tried this but it looks completely feasable

If you untar the nightly FTP backup and go to ncbackup-202112102219-daily\tmp\ncbackup you will find the postgres dump files. (.bin and .schema files)

It would be possible to grab the backup, untar and restore it to a postgres sql db (running on Windows or Linux).

Once you have nosed around the schema a bit and perhaps connected it to something like the open source community edition of Pentaho Report Designer. You could get better access to the data than provided by the default NC reports.

This of course surmises that the data in the dump isn’t encrypted or has some other impenatrable obsfucation done to it to make this idea impossible

0 Comments

Submit a Comment

Your email address will not be published.

You May Also Like…

List your VSCode Extensions

Ever wondered what extensions you have installed and want to keep a list? This actually is a good way to audit your...

array_merge vs the + operator

<?php $options = [ 'rootNode' => 'response' ]; // array_merge // the same key appearing later will overwrite echo...