Blog: Oracle Reports Converter release

DB Best proudly announces the release of Oracle Reports Converter. With the accumulated expertise of converting Oracle Reports as a service, we have turned this knowledge into a full-fledged module of the Oracle Forms and Reports Converter duo. Depending on the license, users will access Oracle Forms Converter or Oracle Reports converter, or both.

Why it is valuable

From Oracle’s statement in 2019, its Oracle Reports is no longer supported, meaning it will lack updates and enhancements. As with many companies still relying on Oracle database to generate and submit their financial reports, it became crucial to provide a solution for publishing reports using platforms that have official support from developers. This is especially true in the public sector,

Because of this, we selected SQL Server Reporting Services (SSRS) from Microsoft as a target platform for publishing reports. Not only is it backed by an enterprise-grade company, it also provides a rich set of features for building reports after a client moves to the SSRS environment.

Considering the number of enterprises stuck with Oracle, we understood the importance of making deprecated Oracle-generated Reports suited for SSRS with minimal human effort. And Oracle Reports Converter will automate this process. The product achieves at least 80% conversion accuracy and is ready to bring your outdated Oracle Reports back to life, powered by a Microsoft-supported platform.

Moving to SSRS from Oracle Reports

Installation hiccups

You can request a trial version of Oracle Reports Converter on the product page. After your request, we will send you a download link with a license key for activation.

Make sure you have all the necessary drivers installed. Namely, the ODAC driver (ODAC112040Xcopy_64bit) is a crucial piece of the puzzle for making the conversions work.

Once you install Oracle Reports Converter and all the necessary drivers, activate the license key, and restart the program.

How does it work?

Everything starts with the source material. First, users need an .XML file from the actual Oracle Report — it contains definition objects that denote its structure. To make it easier, Oracle Reports Converter uses an Oracle tool for converting files to .XML.

This file will be the basis for preserving the initial Oracle Report layout after its conversion.

Assessment

After the report file is uploaded, users can run a quick Assessment Report. Available as a standalone product, it shows the number of functions, triggers, data items, and other objects that are directly involved in the conversion process. Based on this information and the number of action items — objects that require manual tuning — the program generates the Complexity Index. The Assessment file also provides the estimated time it takes to convert Oracle Reports from start to finish, allowing users to plan beforehand.

The Action Items tab shows the possible issues occurring after the conversion. Users can export this information to .CSV files, thus show which reports’ elements should be converted manually. This information will be applicable after publishing reports on the SSRS server.

Assessment report results

Conversion

Once you know the conversion’s ins and outs, press that Convert button! Now, Oracle Reports Converter extracts the uploaded .XML file and dissects its code into 2 major parts:

  • The first part includes PL/SQL code — packages that Oracle Reports Converter will send to the Oracle database. These packages will be responsible for transferring the Oracle database data and showing it in SSRS.
  • The second part will preserve the core Oracle Reports structure and layout. It will be an .RDL report that is ready for publishing in SSRS.

After the process is completed, Oracle Reports Converter shows the result by comparing the Source tree against its Target counterpart. Users can inspect the converted objects’ code to make sure the conversion was successful.

Currently, Oracle Reports Converter supports the following publishing options:

  • Publish to files — for publishing the report in SSRS later.
  • Publish to a Visual Studio solution — for extra development purposes.

After publishing in SSRS, users may need to perform manual tuning.  This step is required to retain the structure and layout of Oracle Reports — the previously saved Action Items report will show items that require adjustment.

When the report is ready and published, the data will continue to be updated with its Oracle database source upon users’ requests. What is more, you will be able to maintain the Oracle database connection and form reports using a modern SSRS toolkit — such features as drill down, drill through, and subreports – will be available for use.

Oracle Reports structure

Licensing aspects

As noted above, Oracle Reports Converter is available as a standalone module with its own license. At the same time, its neighbor, Oracle Forms Converter, requires a separate license and delivers upon different goals.

With a trial version, you will be able to use Oracle Reports Converter for the first 14 days, then it won’t be available for usage. You can convert up to 20 reports per project, meanwhile, the number of projects isn’t limited.

Go full supported

Download Oracle Reports Converter now! Get on the same page with modern technologies — both visually- and legal-wise. Make a solid step towards fully supported Microsoft publishing tools, while maintaining the Oracle Reports original core.

Or make even bolder steps to using a cutting-edge Microsoft SQL Server toolkit, from SSRS to the very database.

Share this...
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin