Exporting reports to ms Excel or text and more

general discussion
1

We are converting to BO XI (whatever version DoD has bought) in the next few weeks. I haven’t had any training yet but I currently write and run queries and reports in Oracle Discoverer.

  1. I can currently export my products to .xls, .txt or .pdf. Will I be able to continue in BO?

  2. Also I download data directly from the database using ODBC and update an ACCEL database. Will I still be able to download the data even if the BO database is CAC’d?

  3. I can also copy a Discoverer query in SQL. Can I copy the SQL file and paste or import to BO so I don’t have to rewrite all of my reports?

  4. I also use a .bat (batch) file to run all of my reports automatically. Can I do that in BO?

Thanks in advance.
Renegade

getu12 (BOB member since 2009-12-05)

2
  1. Yes
    2)Yes, you can use an ODBC or native connectivity (TNSNAMES.ora) to extract data from underlying database. But what you exactly mean by downloading?
    3)Yes you can do it in the Freehand SQL of BO DeskI with some modifications. Although remember that its always better to use a universe instead of FHS
  2. Yes
    .

haider :es: (BOB member since 2005-07-18)

3

Thanks for the reply.

I “download” all the data in a Discoverer/Oracle table directly in to a ACCESS table using ODBC and the MakeTable query function in ACCESS.

I might be able to just write a query in BO that captures all of the data I need and just export it using .xls or text files.

When I get the software and get in to it I probably will have more questions.

Thanks again for the help.

getu12 (BOB member since 2009-12-05)

4

Check the Export option in Data Manager from Data > View Data menu
.

haider :es: (BOB member since 2005-07-18)