|
trini_girl (f)
|
Hi,
I'm using an Oracle RDB ODBC driver to connect to an Oracle database that extracts data from a system that was built using Focus.
The connection is testing successfully, however when I view the table values each column has pure gibberish, and of course, if i run a report all the columns come up blank.
Now I tried using different types of middleware provided by BO, namely the Generic and Oracle 9 and 10. They all have the same result.
I'm sure it's a BO issue, becuase I have Crystal 10 installed and ran a report using the same ODBC and the results were successful.
However I prefer to use BO for this particular report.
If anyone is familiar with developing BO universes using Designer, any suggestions as to why this is happening in BO and how I can have it resolved would be much appreciated.
Thanks
|
|
|
|
|
|
pc guru (m)
|
hey dude you really sound like a certified guy am really new to this Oracle and i really want to be a programmer and i have a good knowledge of C++ and Vast in depth knowledge of computers and hardware especially operating systems but the limitation is that i am currently studying business administration in my school .will my course limit me. is there any way i can write an oracle certified exam without having to go to university to study comp sci. and also will have a job offer with it.my dream is to be a programmer because programming is my hobby,but i have to reduce it due to my course.i really don,t want to work in a bank.i worked there before and it,s quite fucking depressing.holla me please this young boy wants a future with computer thanks.
|
|
|
|
|
|
Cactus (m)
|
check out forum topics for business objects BI rocks I have worked with BO6.5 and XIR2 in terms of connection problem there could be so many things wrong make sure you use proper names, test all your sql statements and make sure they generate similar results in oracle sql+ or toad. sometimes you may need to change sql statements in BO to match BO's engine. well look at the forum on the site that should help you. not really sure how to fix ur problem http://www.forumtopics.com/busobj/index.php |
|
|
|
|
|
Cactus (m)
|
are there opportunities in trinidad for Business Objects, informatica, and datawarehousing?
|
|
|
|
|
|
BlkRaven (f)
|
Hi trini_girl I use BusObj designer and reporter connected to extract info from an Oracle database. - When you say the Oracle database extracts data from a system built using Focus, does this mean the data is not stored in the Oracle database?
- What version of Oracle are you using?
- What version of Oracle Client have you got installed on your PC?
- Have you been able to run BusObj reports using this Oracle database before?
You say the connection is successful. I've never heard of Focus. If it is a database system, that *may* be the problem. I don't think you can use Oracle to extract data from another database and feed it into BusObj. You'll have to create a connection directly to the database where the data is stored. |
|
|
|
|
|
Cactus (m)
|
extraction or transformation
you can use oracle to extract data from a different db platform
this doesnt seem reasonable when there is a driver in business objects that can connect directly to the other db platform
If you have no driver for business objects for your database, well you can transform the data into oracle or into a flat file and then connect with BO.
unless u don't have a driver, then you can extract
thats what i think
|
|
|
|
|
|
BlkRaven (f)
|
Cactus
I don't dispute that one can use Oracle to extract data from a different db. What I mean is that if she's connecting to an Oracle database, the data would have to be stored in that database before it can be fed into BusObj.
I just read the OP's post again and she can see the tables in BusObj Universe designer which means she's connecting directly to the database where the data is stored. This renders my previous post invalid. However, I also just noticed that it is an Oracle RDB database, not an Oracle database. Sounds like BusObj hasn't provided any middleware for Oracle RDB so she's trying to find a workaround hence the RDB ODBC driver. BusObj Tech Support is her best bet.
|
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
