Migrating BIRT Analytics data from release 4.2
Prior to BIRT iHub 3, BIRT Analytics stored data in a SQL Server Express database. From BIRT iHub 3, BIRT Analytics stores data in a PostgreSQL database.
Actuate provides a tool to migrate existing BIRT Analytics data from the release 4.2 database to the BIRT iHub 3 database. Do not load new data into BIRT Analytics before migrating existing data. The data migration tool replaces any existing data in the BIRT iHub 3 database.
To install the data migration tool, follow the instructions in
How to install the BIRT Analytics tools. This tool runs only on Windows.
How to migrate the BIRT Analytics data from release 4.2
Use the BA 4.2 to 4.3 Backend DB Migration Tool to migrate the BIRT Analytics release 4.2 data to release BIRT iHub 3.
1 Open the 10-Tools folder and navigate to the subfolder named Tool Migration backend db.
2 Right-click the ba-mssql2psql.exe file and choose Run as administrator. BA 4.2 to BA 4.3 Backend DB Migration Tool appears.
3 In MS SQL Connection Parameters, type the following information:
In Server\instance, type the server and database name of the BIRT Analytics 4.2 FastDB database.
In User ID, type the administrative user name.
In Password, type the administrative user password.
4 In PostgreSQL Connection Parameters, type the following information:
In Server, type the name of server where the BIRT Analytics iHub 3 database component is installed.
In Port, type or select the port used by the BIRT Analytics iHub 3 database. The default port is 5432.
In User ID, type the name of the Postgres database administrator user. The default user name is postgres.
In Password, type the password of the Postgres database administrator user. The default user name is postgres.
The data migration tool looks similar to the one in
Figure 4‑12.
Figure 4‑12 Preparing to migrate data from BIRT Analytics 4.2 to iHub 3
5 To test the connection values for each database, choose Test Connection. If a failure message appears, correct the information.
6 Choose Launch Migration. The progress of the migration appears.
7 Close the BA 4.2 to BA 4.3 Backend DB Migration Tool.
