Migrating Cognos Analytics data between clusters

Import or export Cognos Analytics data, including artifacts such as JDBC drivers, custom images, and deployment files, between Cloud Pak for Data clusters.

Use the cpd-cli export-import utility to migrate Cognos Analytics data between Cloud Pak for Data clusters. For more information, see cpd-cli export-import.

Before you begin

Make sure that you completed the prerequisite tasks and initialized the cpd-cli export-import utility. For more information, see Migrating data between Cloud Pak for Data installations.
Check whether the cognos-analytics-aux auxiliary module is listed in both Cloud Pak for Data clusters. Run the following command to determine which auxiliary modules are installed:
```
cpd-cli export-import list aux-modules -n ${INSTANCE_PROJECT} --profile=${CPD_PROFILE_NAME}
```
Set the DEST_INSTANCE_PROJECT environment variable to the project in the destination cluster for your instance.
```
export DEST_INSTANCE_PROJECT="<project-in-destination-cluster>"
```
Tip: If you are using the same project in the destination cluster as your source cluster, use the INSTANCE_PROJECT environment variable:
```
export DEST_INSTANCE_PROJECT=${INSTANCE_PROJECT}
```

About this task

Note: The cpd-cli export-import does not export the content store database. You must use Cognos Analytics to export the content store database.

Procedure

Export the Cognos Analytics data from the source cluster:

From the source environment, use the export create command to create the data export job.

cpd-cli export-import export create -n ${INSTANCE_PROJECT} --profile=${CPD_PROFILE_NAME} -c=cognos_analytics EXPORT_JOB_NAME

Verify that the export job is complete in the namespace.
```
oc get pods -n ${INSTANCE_PROJECT}
```
Tip: If you need to start another export job, delete the last export job before you start a new one.
```
cpd-cli export-import export delete -n ${INSTANCE_PROJECT} --profile=CPD_PROFILE_NAME EXPORT_JOB_NAME --purge
```

Import the Cognos Analytics data into the destination cluster:

From the destination cluster, use the export download command to download the exported data.

cpd-cli export-import export download -n ${INSTANCE_PROJECT} --profile=CPD_PROFILE_NAME EXPORT_JOB_NAME

Use the export upload command to upload the data into the destination project.
```
cpd-cli export-import export upload -n ${DEST_INSTANCE_PROJECT} -f cpd-exports-EXPORT_JOB_NAME-YYYYMMDDNNNNNN-data.tar --profile=CPD_PROFILE_NAME
```
cpd-exports-EXPORT_JOB_NAME-YYYYMMDDNNNNNN-data.tar is the name of the downloaded file that contains the exported data.

Use the import create command to create the data import job in the destination project.

cpd-cli export-import import create --from-export cpd-exports-EXPORT_JOB_NAME-YYYYMMDDNNNNNN-data.tar --namespace ${DEST_INSTANCE_PROJECT} --profile=CPD_PROFILE_NAME IMPORT_JOB_NAME --log-level=debug --verbose

Verify that the import job is complete in the destination project.
```
oc get pods -n ${DEST_INSTANCE_PROJECT}
```
Tip: If you need to start another import job, delete the last import job before you start a new one.
```
cpd-cli export-import import delete -n ${DEST_INSTANCE_PROJECT} --profile=CPD_PROFILE_NAME IMPORT_JOB_NAME
```

What to do next

To verify that the migration is successful:

Log in to the Cognos Analytics instance in the destination environment.
Import the data that you migrated. For more information about importing Cognos Analytics data, see Run an Import.
Open a project and verify that the data, dashboards, and reports in the destination environment are the same as the data, dashboards, and reports in the source environment.