Using JasperReports/iReport with SAP ...

[2006 JR Open Discussion]

By: Teodor Danciu - teodord

Using JasperReports/iReport with SAP ...

2006-07-03 23:59

 

Hello,

 

The JasperSoft team would like to know if there

are any applications out-there successfully using

JasperReports/iReport with SAP.

If you know of such combination, please contact

us at teodord@users.sourceforge.net.

 

Thank you,

Teodor

 

 

 

By: spoorthi - spoo_anu

RE: Jasper Server -Oracle DB

2006-07-11 03:01

 

 

Hi Team,

 

This is Shivaraj from Surya software systems, Bangalore- India. We are working on Jasper Server related project.

 

We have some queries:

 

By default when we install jasper server, it’s installed in Tomcat with MySQL as database (DB used by jasper application).

 

• How can we configure jasper to work with Oracle?

 

• Are there any Oracle specific scripts for creating jasper server database?

 

• We converted the MySQL scripts to oracle and tried creating the database/tables, but the problem is that there are some tables like USER, ROLE etc which are used in jasper database. These table names are keywords in Oracle, so we are not able to create this. How we can overcome this?

 

These tables are used by jasper server for implementing the functionalities like creating users, creating roles, role-user mapping ….etc.

 

Waiting for your response at the earliest.

 

Thanks & Regards,

Shivaraj

Surya Software Systems Pvt. Ltd

Bangalore, India

 

 

 

 

By: Sherman Wood - sgwood

RE: Jasper Server -Oracle DB

2006-07-11 19:16

 

This post should have gone on the JasperIntelligence forums.

 

I have posted a patch with instructions that show how to have JasperIntelligence 1.0.1 use Oracle as the metadata repository. See http://sourceforge.net/tracker/index.php?func=detail&aid=1520756&group_id=162962&atid=825863

 

 

 

You can use Oracle as a data source for reports and OLAP, by creating a JNDI or JDBC data source in the JasperIntelligence metadata, independent of using MySQL or Oracle as the metadata repository.

 

 

Sherman

JasperSoft