We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small secure web service application for reporting purposes that will require minimal IT experise to build or maintain, and will deliver maximum performance in terms of response time and data transfer via the Internet.
Our internal network is fast Ethernet (100 MBPS) and our connection to ISP is 5 MBPS maximum.
The back end RDBMS engine is built with MS SQL server and will be maintained by the partner. The size of the database is expected to grow over a period of 7 years to ~10 GB. The partner has chosen to use MS-Access and Crystal Reports 7 for report generation and is quite satisfied with these as they provide unrestricted views of the database (prefers MS-Access to Crystal). We would need to develop a similar reporting capability but with restricted view of the database to allow us to see only the data that we are entitled to see (i.e. record and column level security must be available).
We need capability to access the tool from remote offices, generate /download reports in Word, Excel and PDF format to the remote offices via the web. The tool should have capability of at least 5 concurrent remote users. On our side, users will have MS-Office with IE Explorer.
The partner does not object to our setting up a web server on their premises with access to the SQL server.
What are some good reporting tool technology choices ? Budget for the tool is below 15K$ CAD.
Thank you for your help.
March 2, 2005 10:03 AM
March 7, 2005 6:35 PM