IPOL System Architecture
Below you can see how our system is implemented to allow for full inventory control and management.
Our hosting is done by a commercial hosting provider in the philadelphia region. Over the past 7 years we have had 99% uptime with provider. All of our servers are virtualized which allows us to easily migrate between server hosts if needed in event of a hardware failure or outage.
Inventory Pro is hosted in a multi server environment where load is split between application servers and database servers. Data is regularly transferred to our backup servers over a secure connection. Our backup servers are hosted off site and utilize enterprise backup solutions to collate and archive your data, we keep archived copies of data for up to 1 year.
Application servers are what your computer talks to and where your uploaded files are stored. Your data on these servers is backed up nightly to our offices and is replicated across multiple backup providers. At any point in time there are at least 3 current copies of your data and additional archived copies.
Database servers are where the majority of your information is stored, These servers cannot be connected to directly from outside our network. Databases are backed up hourly ( we use a 24 hour full, 4-6 hour diff, 1 hour log pattern ), such that if needed we can restore to a particular date/time in the event of a problem. We utilize this occasionally for clients if a bad import is run or a user clicks select all somewhere by mistake. At any point in time there are at least 4 current copies of your data and additional archived copies.
Windows Server 2016 or greater
SQL Server 2016 or greater ( Express or Standard )
Internet Information Services (IIS) 9 or greater
.Net 4.0 or greater
Mimic what I have on the document for installations, left me know if it’s not available on the ciss share
Cross reference the install template task to add any other pertinent information to the document and the site
Latest Chrome or Firefox preferred
Chrome / Firefox / Edge / Safari supported ( if less than 3 years old )
- http = port 80
- SQL = port 1443
- The system can be run over HTTPS if desired (need to buy certificates)
See if I wrote up a doc on this
Real time or Batch actions using Handheld or Mobile devices
- Windows Mobile 2006+ devices
(Symbol PPT8800, MC9000, Psion Teklogix Workabout Pro, etc)
- .NET Framework 4.0
- Ftp proprietary file formats
- CSV (Excel Spreadsheets)
- ODBC / Direct database connections
User Interface based upon standard WWW browsers:
- IE v6/7
* Must have cookies enabled
Process for Install on Server with no SQL Server using an empty Inventory Master DB:
- Install SQL server
- Install db manager software
- Attach Master DB to SQL Server
- Copy files to IPOL folder
- Give write permissions on specific import/export folders
- Register dlls
- Add specific dlls to component services
- Create IIS website
- Register dll files