Home Applications IRIS Data Migration Manager

IRIS Data Migration Manager

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
5
1 reviews
0
Awards
562
Views
0
IPM installs
0
5
Details
Releases
Reviews
Issues
Pull requests
Articles
This application allows you to import data into IRIS from various sources in a simple way.

What's new in this version

Added JSON files import
Fixed docker issues

About application

This application allows you to import data into IRIS from various sources in a simple way.
Using this application, you can:

  • Import JSON data into IRIS globals.
  • Export IRIS globals to json files.
  • Transfer data from the MongoDB collections to the IRIS globals.
  • Transfer data from the PostgreSQL tables to the IRIS globals.

The data structure of the input data is reproduced in the IRIS global.

For example, if the first MongoDB document is like this:

{
    "name": "John",
    "info": {
        "age": 25,
        "gender": "male" 
    },
    "emails": [
        "john.1@example.email",
        "john.2@example.email",
        "john.3@example.email"
    ]
}

In IRIS it will be:

path value
^collection_name(0,“name”) “John”
^collection_name(0,“info”,“age”) 25
^collection_name(0,“info”,“gender”) “male”
^collection_name(0,“emails”, 0) john.1@example.email
^collection_name(0,“emails”, 1) john.2@example.email
^collection_name(0,“emails”, 2) john.3@example.email

JSON import is similar.

This application uses nativeAPI to work with IRIS.

How to use it

It is very simple. To start the application, clone project:

$ git clone https://github.com/danoleg/mongo-to-iris-migration

To run application as a tool, without demo databases.

$ docker-compose up -d

To run demo:

$ docker-compose -f docker-compose.demo.yml up -d

By url http://127.0.0.1:8080 will open a demo page with list of MongoDB collections.

To open collection import manager click button on collection card. On this page, you can migrate data or clear IRIS.
To start migration click on button and wait few seconds. After finishing the page will reload with updated information.

image

Importing data from PostgreSQL is similar to MongoDB, only tables instead of collections:

image

In sidebar you can switch to the JSON importer. It’s also very easy to use. Just put your JSON to the textarea and click on the import button.

image

Or import it with JSON file

image

Also you can download IRIS global in json file just in one click.

image

In the settings, you can connect remote databases to use the application as a tool.

image

Made with
Version
1.4.402 Jul, 2023
Category
Solutions
Works with
InterSystems IRIS
First published
30 May, 2020
Last checked by moderator
01 Nov, 2023Works