Business Object Vs Microsoft Access 97

Posted on 2006-04-27
Last Modified: 2013-11-15
Business Object Vs Microsoft Access 97

We have a C/S application which is developed in PB/SQL SERVER 2000.

And we have another application which is in ACCESS 97 to generate reports from the SQL SERVER 2000 (same database) using link tables.

Now our client wants to store .jpg files in SQL SERVER and show it in the report.

I am not sure, if MS-Access 97 has an ability to retrieve files stored as BLOB in SQL Server. Also, I have heard many good things about Business Objects.

Is BO really better than Access. I think it should be   If so, can you give me some points where I can convince my client that BO is much better
than ACCESS 97?

Question by:gdamodaran
    LVL 4

    Expert Comment

    Hi gdamodaran,
    You are talking about Business Object. Do you mean that BO is an application or an architecture?
    LVL 4

    Expert Comment

    Hi gdamodaran,
    The time I studied at school, I remembered that my teacher one said about BO - Business Object and Informatica. They are two important component that support you build Data Warehousing.

    Below is the explanation of author Vamsi:
    "Sqlserver2000, Informatica, BO-Business Object are like three wings for data
    ware housing.
    For SQL server 2000 you need to start with administration to PL/SQL
    Informatica we need to learn from installation,administration,repository
    management,importing data bases, exporting objects, creating targets,
    creating mapping with all the transformations, then session and work flow
    creation in work flow manager, then about work flow monitor, at last you can
    learn about the repository tables.
    Bussiness objects, you need to concentrate on installation, repository
    creation, centralized repo.. maintenance, administration, job creation, data
    flow creation and work flow creation, how to import data bases and export
    jobs, and study of meta data is a must. Coming to reporting side concentrate
    all of the topics which comes with installation.
    (Read from

    P.S I am really interested in what you are discussing about. Hope more member will join this topic.
    LVL 4

    Expert Comment

    After asking some of my friend, I understand that Business Object help us to make Report easier.

    I found this one by TommyTupa (member of experts-exchange)
    Download the file and read it. The document is about usage of Business Object 5i. I guess that you did understand well on Microsoft Access 97 report generating, so now you could have a look at this document to make a comparison between two tools.
    LVL 4

    Expert Comment

    If you have free time, you can also have a look at
    Upgrading Business Objects Reporting Solutions

    Business Objects Information Resources

    Customer Support, Consulting, and Training

    Business Objects pushes reporting integration,10801,91951,00.html

    home page of Business Object

    I've tried and just have this for you. Hope you have a good presentation to your customer.
    I like your post!!!!
    LVL 4

    Expert Comment

    Register this page to have a white paper (technique document) of BO:

    also some other material here.

    Sincerely yours,

    Author Comment

    Thanks for your response.

    To answer your question, I am basically trying to find out what advantage will I have when I use  Business Object as a reporting tool over MS-Access. Thanks!

    LVL 13

    Accepted Solution

    1. Ease of use.
    2. Flexibility.
    3. Ability to query a variety of data sources..
    4. Pixel perfect reporting.
    5. Ability to exoprt in a variety of formats.
    6. Quick development time.
    7. Quicker response time.
    8. Easier ability to aggregate and\or rank results.
    9. Easier ability to create formulas and\or conditional logic.
    10. More eye-pleasing reports.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now