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 turned this knowledge into a fully-fledged module of the Oracle Forms and Reports Converter duo. Depending on the license, users will either access Oracle Forms Converter or Oracle Reports converter, or both.

Why it is valuable

From the Oracle’s statement in 2019, its Oracle Reports is no longer supported, meaning it will lack updates and enhancements. With many companies, especially from the public sector, 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.

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

With 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.

Conversion to SSRS illustrated

Installation hiccups

You can request a trial version of Oracle Reports Converter on the product page. Then, 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 plus on 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 to plan the affair 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 in details

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:

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

After publishing in SSRS, users will either do or don’t 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 keep being 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 drilldown, drillthrough, and subreports will be available for utilizing.

Reports converter flow

Licensing aspects

As noted above, Oracle Reports Converter is available as a standalone module with its own license. At the same time, it neighbors Oracle Forms Converter that 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 only convert up to 20 reports per project, meanwhile, the number of projects isn’t limited.

Go full supported!

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

Or even make 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