Post reply

queries and reports corporative database

  • October 28, 2006 at 9:14 am

    #174994

     Hi! we have no Business Intelligence solution in my job and the general manager asked for a query and reports system where he (and other section managers and non IT staff) could query the corporative database (we work in healthcare, so it's mostly about patients, clinic histories, treatments)  so I will propose them SQL SERVER 2005.  I'll tell you my general idea and maybe you could tell me if I'm right:  Through Integration Services we will load our data from the corporative database (it's Borland's InterBase)   then through Reporting Services we can query these data to generate different reports (this reports can be generated for non-technical staff, but staff who knows quite a lot about for example the different treatments that different groups of patients follow, so this staff may want to query about which patients followed which treatment in a period of time and generate by himself a report about that).  And through Analysis Services we could (in a future) generate some OLAP solutions, Data Mining etc

    But for the query and report system it could be enough to start with Integration Services and Reporting Services?  it's very important for this system to work efficiently in terms of time: the non-technical staff generates the query and in seconds receives the report  result... some of this non IT staff who will use the system knows exactly which information we house in each InterBase table, so through this system they would like to generate their own queries and reports (this is a different level of non-IT staff who is in between a Medical doctor and a Software engineer, this staff does have some technical background specially in SQL.

    So my idea is to have an SQL SERVER 2005 to which this staff gets connected via LAN (all this system runs locally in one corporative place, will not run through Internet) feeded by the InterBase corporative database and delivering efficiently queries and reports... is this possible? could I test this using the trial free 6 months version?

  • October 30, 2006 at 10:18 pm

    #668920

    The free trial version would certainly work but... why don't you spend the $64 for the Developer's version so you don't have to worry?  And, why doesn't Borland Interbase support what you want to do?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply