Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Business Objects vs. MS Access

Discussion in 'Information Technology' started by Paperback Writer, Jul 28, 2006.

  1. Paperback Writer

    Paperback Writer
    Expand Collapse
    Guest

    They are rolling out Business Objects where I work. In my gut, I think MS
    Access iis probably better.

    Does anyone here know the differences (performance-wise) between the two?
     
  2. Loading...


  3. Mike Labosh

    Mike Labosh
    Expand Collapse
    Guest

    > They are rolling out Business Objects where I work. In my gut, I think MS
    > Access iis probably better.
    >
    > Does anyone here know the differences (performance-wise) between the two?



    If "Busines Objects" means some 3rd party software, then you will have a
    learning curve

    If "Busines Objects" means some programmer at your office developed a class
    library, then it will also have a learning curve, but it will let you change
    your code so that it's tighter. Imagine the Northwind database, how cool it
    could become, if it had programming that thinks in terms of customer
    collection of customer objects that had methods, instead of having to
    manipulate recordsets.

    While performance is important, you also have to think about how
    maintainable the code is. If your application can operate on a high level
    of abstraction, then GREAT! If your application is "married" to the nuts
    and bolts of the physical storage, then people like me will be sending
    proposals for incredible amounts of money to fix it.

    Here are some references:

    What to do:
    http://www.amazon.com/gp/product/02...102-0597696-8121709?s=books&v=glance&n=283155

    (Or if that has "session junk" in it, then just goto Amazon and do a search
    on "Design Patterns" and look at the first book on the list. It should be
    white with a blue border)

    What NOT to EVER DO:
    Anything on this guy's web site should be absolutely forbidden:
    http://mindprod.com/jgloss/unmain.html
    --


    Peace & happy computing,

    Mike Labosh, MCSD MCT
    Owner, vbSensei.Com

    "Escriba coda ergo sum." -- vbSensei
     
  4. Gina

    Gina
    Expand Collapse
    Guest

    I worked with Business Intelligence (Objects) a few years ago. The
    difference between it and Crystal was that BI has a security level. When you
    connect into the DB with Crystal you had access to everything, however, with
    BI you had access only to what the Universe allowed you access to. A
    Universe is simply a part of the complete DB. You can create many different
    Universes giving the end users access to only specific parts of the complete
    DB. I mention Crystal because the two companies have now merged into one.
    BI was very easy to use.

    Look up BI or BO (spelled out) on the internet, there is a lot of info.
    They have come a long way since then. There are some really useful new
    features.

    Hope this helps.
    --
    Gina


    "Paperback Writer" wrote:

    > They are rolling out Business Objects where I work. In my gut, I think MS
    > Access iis probably better.
    >
    > Does anyone here know the differences (performance-wise) between the two?
     
  5. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    Business Objects is crap.

    use Access Data Projects and a beefy 4-processor relational server.

    get a 2nd sql server (probably only a dual proc) for olap

    -Aaron


    Gina wrote:
    > I worked with Business Intelligence (Objects) a few years ago. The
    > difference between it and Crystal was that BI has a security level. When you
    > connect into the DB with Crystal you had access to everything, however, with
    > BI you had access only to what the Universe allowed you access to. A
    > Universe is simply a part of the complete DB. You can create many different
    > Universes giving the end users access to only specific parts of the complete
    > DB. I mention Crystal because the two companies have now merged into one.
    > BI was very easy to use.
    >
    > Look up BI or BO (spelled out) on the internet, there is a lot of info.
    > They have come a long way since then. There are some really useful new
    > features.
    >
    > Hope this helps.
    > --
    > Gina
    >
    >
    > "Paperback Writer" wrote:
    >
    > > They are rolling out Business Objects where I work. In my gut, I think MS
    > > Access iis probably better.
    > >
    > > Does anyone here know the differences (performance-wise) between the two?
     

Share This Page