EspressReport Vs Jasper Report

1. Jasper reports are not user friendly reporting tool. It needs an ant tool to compile, run the application.

EspressReport is a user friendly application. Anyone can create the report without knowledge for Java. It didn’t need any third party tool to compile/run applications.

2. Jasper reports can be exported into the following formats.

PDF, HTML, XLS, RTF, ODT, CSV, TXT or XML document.

EspressReport: Run reports in applets or generate HTML/DHTML, PDF, Excel, RTF, XML, text or CSV files.

3. Jasper provides only for the JDBC connection.

EspressReport: JDBC, JNDI, SOAP and Sales Forge

4. Jasper Report Supports data sources are Database, Java Class, CSV and XML files.

EspressReport: Draw data from databases, XML files, Text files, and Java arrays/objects/classes/EJBs. Unique Data View feature allows easy database access/querying.

5. Jasper only provides the Summary report and Crosstab reports.

　　EspressReport: Simple Columnar, Summary Break, Crosstab and Master & Detail report

6. Jasper Report supports the following charts

Pie, Pie 3D, Bar, Bar 3D, XY Bar, Stacked Bar, Stacked Bar 3D, Line, XY Line, Area, XY Area, Scatter Plot, Bubble, Time series, High Low Open Close, Candlestick.

EspressReport provides 2D Column ,3D Column,2D bar,3D bar,2D stack bar,3D stack bar,2D stack column,3D stack column,2D area,3D area,2D stack area ,3D stack area,2D line,3D line,2D pie,3D pie,2D scatter,3D scatter,2D High Low,3D High Low,2D HLCO,3D HLCO,2D 100% Column, 3D 100% Column,3D Surface,2D Bubble,2D Overlay,2D Box,2D Radar, 2D Dial,2D Gantt and 2D Polar .

7. Jasper didn’t provide the web service technology for the developers.

EspressReport provides the web service technology for the developers.

8. Jasper report: Anti-alias feature didn’t support for the charts

EspressReport provides the Anti-alias support for the charts.

Thanks,Publish Post

Veera

http://www.climb.co.jp

http://www.quadbase.com

AS/400(iSeries) Journal and Receiver

AS/400 Journal and Receiver is look like Oracle RedoLog, it contains the records details what we inserted/updated/deleted. It is necessary when we are going to mirroring or synchronization replications.

The following steps indicates you How do create a Journal and Receiver.

Step 1: Create a Receiver, Type CRTJRNRCV JRNRCV(QAFP/DBRSJ00001) AUT(*ALL)

Here QAFP is the Library name and DBRSJ00001 is the receiver name and Autherity for ALL.

Step 2: Create a Journal, Type

CRTJRN JRN(QAFP/DBRSJ) JRNRCV(QAFP/DBRSJ00001) AUT(*ALL)

Here QAFP is Library Name and DBRSJ is Journal Name.

Step 3: Change the Journal, Type

CHGJRN JRN(QAFP/DBRSJ) JRNRCV(*GEN)

Step 4: Activating a Journal

Here QAFCTUTDBF is a Physical Table name.

Regards,

Veera,

SystemEngineer,

ClimbInc, Nihombashi,Tokyo,

http://www.climb.co.jp

Database Replication

Maintaining multiple database platforms is a way of life for most organizations. Each platform supports its own application type, but businesses almost invariably need to exchange data between different database platforms.

SQL Server's built-in replication has limited support for other database platforms. HiT Software's DBMoto solves the problem of cross-platform communication through real-time database replication between almost all popular database platforms, including SQL Server, IBM DB2UDB,IBM iSeries,Oracle,Sybase ASE, SQL Anywhere, Cloudscape, MySQL,
Informix,Ingres, PostgreSQL, Microsoft Access, Gupta SQLBase,Firebird, and Solid.

They are four types of drivers can we utilize into Database connection using DBMoto.

With DBMoto, HiT Software brings real-time data replication and data integration with:

-Low Total Cost of Ownership (TCO)

-Heterogeneous Database Support

-Interoperability with Legacy Systems

-Accelerated implementation/faster time to market

-Non-proprietary and standards-based

-High reliability and proven performance

-Responsive, expert technical support

-Available in 32-bit/64-bit

Refresh mode is essentially snapshot replication:

DBMoto sends a point-in-time copy from the source to the target system.

Mirroring mode is like transactional replication: Real-time changes are sent from the source to the target.

Synchronization mode enables bidirectional replication beween the source and the target.

DMoto can automatically convert data types as well as perform data transformations using Visual Basic .NET scripts.

A grouping feature lets DBMoto intelligently handle common connections to remote databases.

After defining the source and target, you use the Replication Wizard to set up the replication type,

the source and target connections, the data mapping, and the schedule. To support transaction replication on the IBM i, DBMoto required journaling to be active for the files being replicated.

The above figure shows the Replication Wizard's data mapping screen, which lets you do simple one-to-one mapping.You can use the toolbar to edit the mappings to differently named columns and optionally elect to perform transformations on selected columns.

DBMoto was easy to use, and it supports almost all of today's popular databases. If you're looking for a solution to your heterogeneous transactional database replication problems,

DBMoto has the answer.

Download DBMoto, a full 30 day support.

http://www.hitsw.com/

Regards,

Veera,

SystemEngineer,

ClimbInc,Nihombashi,Tokyo.

http://www.climb.co.jp