How To
Summary
At version 4.3.3 of i2 Analyze, IBM withdrew support for the Analysis Repository in favor of the Information Store. If you have data in a Local or Global Analysis Repository that you want to keep, you can export it from the database to files on disk. Optionally, you can also prepare the exported data for loading into an Information Store.
Objective
This document and its associated downloads provide tools and instructions for exporting item and document data from an Analysis Repository database, and for subsequently loading the item data into an Information Store.
Click here to download the tools from the IBM Box file store.
Steps
The process of migrating data from an Analysis Repository to an Information Store has three distinct stages:
-
Exporting data from the Analysis Repository to files on disk
exportOnyxItems and exportOnyxDocuments are Java-based tools for exporting data from an Analysis Repository into flat files on disk. Item data is saved in JSON format; documents and charts are saved in their original formats.
For information on using these tools, refer to the readme.md file in onyx-data-exporter-1.0.1.zip.
-
Converting the exported JSON files to CSV format
If you want to load the exported item data into an Information Store, the next step is to convert the JSON file to CSV format. convertOnyxJsonToCsv is a Java-based tool that takes the output from exportOnyxItems and creates CSV files that contain entity and link data.
For more information on using this tool, refer to the readme.md file in onyx-json-to-csv-converter-1.0.1.zip.
-
Loading and ingesting data into the Information Store
To complete a full migration, you need to load the CSV data into the Information Store staging tables, and then ingest it into the Information Store proper. The i2 Analyze documentation describes the process here: https://www.ibm.com/support/knowledgecenter/SSXVTH_4.3.3/com.ibm.i2.iap.admin.ingestion.doc/data_ingestion.html
You can find examples of data that is ready for loading into staging tables in the i2 Analyze deployment toolkit's examples/data directory, which also contains scripts for loading the data into Db2 and SQL Server databases.
For information about how the database scripts work, see the Db2 11.5 or SQL Server documentation.
Additional Information
The tools for exporting and converting data from an Analysis Repository are compatible with both Windows and Linux. They are provided as both CMD and SH files.
The process of exporting data from an Analysis Repository is relatively straightforward, but the process for importing it into an Information Store is not automatic. IBM recommends that loading and ingesting the data is carried out by a database administrator.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
12 August 2021
UID
ibm16415785