Turn off old ERP system running on Win2008R2 and view the exported data
-
I’m looking for a solution to allow users to view data from an old ERP system that is running on Windows 2008R2 servers. The company has migrated away from the old ERP, but not all information has been migrated into the new ERP system. Users are still accessing the old ERP system for data that didn’t get migrated. The old ERP system is running on a Windows 2008R2 sever with Pervasive SQL database backend. I will have the ability to export data to CSV files. Can someone point me in the right direction for users to view the archived data? My first thought was to create a new Fedora server with MariaDB installed. I could import the CSV files from the old ERP system into the MariaDB. I would then install some sort of simple web interface like Adminer for users to access the database in a GUI. Is there another solution that someone can point me to that would make more sense, or am I on the right track?
-
I have the same issue!
-
This post is deleted! -
Without going into the details on what you could do I would ask, why not just work to import this data into your new system?
The end goal is to have everything in one place, so building or setting up literally anything else seems counter-intuitive.
You could, if you really needed, just host this CSV somewhere that could be downloaded as needed by a handful of people so they can perform a Ctrl+F on it.
-
This post is deleted! -
@DustinB3403 said in Turn off old ERP system running on Win2008R2 and view the exported data:
Without going into the details on what you could do I would ask, why not just work to import this data into your new system?
The end goal is to have everything in one place, so building or setting up literally anything else seems counter-intuitive.
You could, if you really needed, just host this CSV somewhere that could be downloaded as needed by a handful of people so they can perform a Ctrl+F on it.
As much as I dont want agree with @DustinB3403 he has a good point. Having a CSV on Office 365 could save you ALOT of trouble.
-
@DustinB3403 The new ERP system is SAP. The SAP consultants are long gone now and technically the archived data on the old ERP isn't necessary to be imported into the new SAP system. You know how it goes, sometimes you need to look back at a old data to help you with something else. We just wanted to turn off the old Windows 2008R2 servers yet still give the users access to the old data if necessary. I will have to see how large the exported CSV files turn out to be. A nice simple solid option rather than going through all the steps to setup a Fedora DB server though.
-
@magicmarker while I can agree it would be nice to have access to the historical records, obviously the business disagrees with that stance otherwise they would've paid SAP to have imported this data.
Was this an approved choice of the business to want to retain the data and have it hosted on some other unknown platform, browsable in some unknown format?
Are you certain the business wouldn't be fine just downloading a CSV everyone once in a bluemoon?
-
@magicmarker said in Turn off old ERP system running on Win2008R2 and view the exported data:
@DustinB3403 The new ERP system is SAP. The SAP consultants are long gone now and technically the archived data on the old ERP isn't necessary to be imported into the new SAP system. You know how it goes, sometimes you need to look back at a old data to help you with something else. We just wanted to turn off the old Windows 2008R2 servers yet still give the users access to the old data if necessary. I will have to see how large the exported CSV files turn out to be. A nice simple solid option rather than going through all the steps to setup a Fedora DB server though.
If they don't need to run reports and whatnot, it seems a CSV could be the best option.
-
@DustinB3403 said in Turn off old ERP system running on Win2008R2 and view the exported data:
Are you certain the business wouldn't be fine just downloading a CSV everyone once in a bluemoon?
Sounds like Office Online / Onedrive is the best place for it.
-
The thought of a CSV for and ERP melts my brain.... I'm assuming there are way more than one table in the ERP - how will you relate date from one table to the next?
Would this really be as simple as a single CSV file?
-
@magicmarker said in Turn off old ERP system running on Win2008R2 and view the exported data:
My first thought was to create a new Fedora server with MariaDB installed. I could import the CSV files from the old ERP system into the MariaDB. I would then install some sort of simple web interface like Adminer for users to access the database in a GUI. Is there another solution that someone can point me to that would make more sense, or am I on the right track?
At that point, might Excel / LibreOffice Calc not do the job just as well?
-
@magicmarker said in Turn off old ERP system running on Win2008R2 and view the exported data:
A nice simple solid option rather than going through all the steps to setup a Fedora DB server though.
Fedora DB is like a single line of commands, nothing could be simpler to set up for just MariaDB or similar.
