[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Business Object Vs Microsoft Access 97

Posted on 2006-04-27
Medium Priority
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
  • 5

Expert Comment

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

Expert Comment

ID: 16560157
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 http://datawarehouse.ittoolbox.com)

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

Expert Comment

ID: 16560349
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.
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.


Expert Comment

ID: 16560450
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

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!!!!

Expert Comment

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

also some other material here.

Sincerely yours,

Author Comment

ID: 16563935
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

TommyTupa earned 1500 total points
ID: 16570493
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.


Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 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