Hi John,
<smile> Seems like you have my suggestions pretty much in hand already.
I'm not familiar with the company or the product you mention so I don't have any specific knowledge here.
However... If you want or need to "leverage" your organizations investment in its AiX server that may well be possible.
Forgive me if you know this stuff already.
Software is, essentially], split into two parts.
1. The user interface, also known as The Front End - the part you can see, press buttons in and (sometimes) become impatient with.
2. Some way of storing data, also known as The Back End or the database, and this is the part that may interest you if you need to use your AiX machine.
It's quite possible, common in fact, for these two parts to run on different computers. You might hear software like this being called a "Client/Server Application"
Many software packages appear to run on Windows PCs, and they do -- but just the Front End, all of the data is stored on a separate database server, each PC connects over a network to a single database server -- often a UNIX machine such as AiX.
So - the short answer is: It may be possible to use your existing AiX machine with Windows based software.
There is, I'm afraid, a longer answer as well. It may not be wise to do so -- don't write it off just yet but there are a number of issues you will have to address first.
Technical Issues:
1. The s/w would have to be already written to do this. One of the most common ways of doing this would be to use ODBC. ODBC is communications software that runs on Windows PCs. It allows software on the Windows PCs to connect to a database running on another machine, perhaps a UNIX machine.
2. UNIX Support. You've said that you're a newcomer to AiX and that could be a problem unless you want to immerse yourself in it for a while so that you can support your machine, or pay someone else to do so.
3. Database Support. Databases that run on UNIX machines are designed to look after many users, sometimes hundreds or thousands and this comes with a cost -- these databases are complex (and costly). See 2 - above.
4. The age of your AiX machine might be a problem. It's not uncommon to find that, whilst your vendor (IBM in this case) is quite willing to maintain your machine as it is they will be unwilling (unable really) to add to it after a certain point. There will come a time when IBM may not make the spare parts for your machine and any stock they have will be allocated to maintenance. (I've not come across this with IBM but it is happening to me now with HP)
5. If they turn around and say -- "yes, it's client server and can work with any database you choose"; you have to ask if anyone else is doing it already, and can you talk to some of them. Client/Server configurations are fiddly, and choosing some database that your supplier doesn't recommend first off *will* be more work.
Financial:
It's an attractive idea to save money by re-using existing hardware but you shouldn't take it for granted that it will actually work out that way.
1. Unix and the databases that run on it are more expensive to buy and run than Win NT or 2000 configurations.
2. The cost of a Win something database server (if that's what your s/w supplier recommends) is likely to be a small percantage of the overall implementation costs. For the number of users you mention (30 or so concurrent users) it may be that you could save money on hardware and software maintenance by looking at a Win something database server.
That's quite a long post for me, I usually just say something like "have you tried X?" I hope it's useful to you or to someone else reading this.
I've implemented several systems that, at a technical level, are similar to this so I'd be interested in hearing more about it as you go through your thought processes.
Regards,
Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.