Migrating ReportCaster Data and Settings

In this section:

How to:

To migrate ReportCaster content from WebFOCUS 7.x to WebFOCUS 8, you need to first export the content from WebFOCUS 7.x and then import the content into WebFOCUS 8.


Top of page

x
Procedure: How to Export From WebFOCUS Version 7.x
  1. In WebFOCUS 8, navigate to the \ibi\WebFOCUS80\utilities directory.
  2. If you are migrating from:
    • WebFOCUS 7.7, copy the \ibi\WebFOCUS80\utilities\rc directory from WebFOCUS 8 and paste it into the \ibi\WebFOCUS77\ReportCaster directory.
    • WebFOCUS 7.6, copy the \ibi\WebFOCUS80\utilities\rc directory from WebFOCUS 8 and paste it into the \ibi\ReportCaster76 directory.
    • WebFOCUS 7.1, copy the \ibi\WebFOCUS80\utilities\rc directory from WebFOCUS 8 and paste it into the \ibi\ReportCaster71 directory.
  3. If you are migrating from:
    • WebFOCUS 7.7 or WebFOCUS 7.6, run rcExport2XML.bat on Windows, or rcExport2XML.sh on UNIX or Linux.
    • WebFOCUS 7.1, run rc71Export2XML.bat on Windows, or rc71Export2XML.sh on UNIX or Linux.
  4. You are prompted for a user ID and password and whether you want to export Library content.

    The scripts export the current 7.x ReportCaster repository, including Schedules, Distribution Lists, Library Access Lists, Execution IDs, Blackout Dates, and Library content.

    Upon completion of the export, the exported data is created in the following export directory, unless you specified a different location:

    .../ibi/WebFOCUS7x/utilities/rc/rc_export

    The directory structure looks like the following:

    \rc_export\accessList
    \rc_export\addrBook
    \rc_export\blackoutDate
    \rc_export\execId
    \rc_export\library
    \rc_export\schedule
    \rc_export\export_migration.log

    Note: The log file created from the export is generated in the directory identified in the connections dialog box. In this example, the log, named migration.log, is located in the following directory:

    .../ibi/WebFOCUS77/utilities/rc/rc_export

Top of page

x
Procedure: How to Import to ReportCaster 8

Note: If you are using Managed Reporting and you are migrating Managed Reporting content, you must run Managed Reporting migration prior to importing ReportCaster content from an earlier release.

To import ReportCaster content from WebFOCUS 7.7 into WebFOCUS 8:

  1. Copy the .../ibi/WebFOCUS77/utilities/rc/rc_export directory to the .../ibi/WebFOCUS80/migration_import directory.
  2. Run rc_migrate_import.bat, located in the …/ibi/WebFOCUS80/utilities/rc directory.

    You are prompted for user ID and password, whether you are migrating Managed Reporting content, and whether you are migrating Library reports.

    Note: The log file created from the import is generated in the ibi/WebFOCUS80/migration_import/rc_export directory.


Top of page

x
Migrated ReportCaster Content

After migration, ReportCaster content is placed in designated folders in WebFOCUS 8. The migration import creates:

The following image shows the folder structure after a migration import.


Top of page

x
Migration in Place

How to:

As of WebFOCUS Release 8.0 Version 02, there is an alternate migration utility that enables a migration in place, that is, a conversion of a WebFOCUS 7.x repository into a WebFOCUS 8 repository, without the need to export and import the Report Library.

…/WebFOCUS80/utilities/WFReposUtil/upgrade7xDBto8x.sh
…\WebFOCUS80\utilities\WFReposUtil\upgrade7xDBto8x.bat

The BOTLDATA table contains the report output stored in the Report Library and is the table with the largest amount of data. The new utility allows for migration of existing WebFOCUS 7.x ReportCaster BOT tables to WebFOCUS 8, without dropping the WebFOCUS 7.x BOTLDATA table.

Note: This utility is available only for Oracle® and Derby™ repositories.



x
Procedure: How to Migrate in Place
  1. Ensure that there is a database backup of the existing WebFOCUS 7.x ReportCaster repository tables. This is a best practice when running the migration process several times during testing.
  2. If Managed Reporting content is being migrated, follow the WebFOCUS 8 export steps in Migrating Managed Reporting and Dashboard Settings.
  3. Copy the exported Managed Reporting content (…/utilities/mr/export) to the WebFOCUS 8 migration_import directory.
  4. Follow the WebFOCUS 8 export steps for ReportCaster in Migrating ReportCaster Data and Settings.

    Important: When prompted for the export library option, type 2 (false), as shown in the following image. This option will export the Library report references, but will not export the actual report output.

  5. Copy the exported ReportCaster content (../utilities/rc/rc_export) to the WebFOCUS 8 migration_import directory.
  6. Review and modify the upgrade7xDBto8x script:

    1. If you are migrating Managed Reporting content, change MR_ENABLED to yes.
    2. After you complete the above steps and are ready to run the migration script, change RUN_TYPE to actual.
  7. Run the upgrade7xDBto8x script, as shown in the following image.

  8. When prompted for repository credentials, as shown in the following image, type the ID and password. These credentials are validated against the repository credentials specified in the WebFOCUS 8 webconfig.xml file.

  9. When prompted for a valid WebFOCUS administration ID, type WebFOCUS 8 administrator credentials (for example, admin/admin), as shown in the following image.

  10. At the following prompt, enter 1 or 2 to indicate whether the Managed Reporting import has already been done or if the ReportCaster import should be used to create new WebFOCUS groups and users. Option 2 should be specified if Managed Reporting content is not being migrated.

  11. Even though the actual reports are not technically being migrated, the Library report references and links to the reports need to be migrated. When prompted to import Library reports, type 1 (yes), as shown in the following image.

As the script is running, you will see the output indicating the status of the migration process. This also provides some insight into the specific tasks that are included in this process.

The standard migration logs should be used for review of any import errors:

As is the case for all migrated ReportCaster content in WebFOCUS 8, the schedules that run Reporting Server procedures are migrated to the ReportCaster folder. The Report Library content is migrated to the Library Content folder.


WebFOCUS