Importing Data to Ultipa

Your journey with Ultipa can begin right where you are. Leverage our tools to import or connect your existing data in various formats and populate your graphs effortlessly.

Available Tools

Loader in Ultipa Manager

The Loader module in Ultipa Manager supports data loading from various sources, featuring an intuitive user interface.

Complete guide →
Quick Example →

Ultipa Transporter

Ultipa Transporter is a cross-platform command-line tool designed for importing and exporting data to and from Ultipa.

Complete guide →
Quick Example →

Supported Data Sources

Files

Relationals

Graph Platforms

Others

Example: Import from CSV

This example demonstrates the process of importing from CSV files using Loader in Ultipa Manager.

Prepare CSV Files

Click to download the CSV files:

• Customer.csv
• Merchant.csv
• Transaction.csv

To understand the columns included in these files and the graph structure we're going to use, refer to Modeling: Relational to Graph.

Create the Graph

Before using Loader to import data into a graph, ensure that the graph is already created in the database.

Create a new graph named Retail

Create a Loader

Navigate to the Loader module from the left-side menu and create a new loader. The default name is My Loader.

Create a new Loader

Create Task to Import Nodes

Hover on New Task and select CSV, then configure this task before clicking Import:

• Select Retail under Graph.
• Enter Customer under Schema.
• Upload the Customer.csv for File.
• Uncheck Headless as the CSV file has the header row, which contains the property name and type.
• Update the Type of the property cust_no to _id.

Create a Task to import Customer nodes

You may import the Merchant nodes in the same way. Update the Type of the property merch_no to _id.

Create Task to Import Edges

Hover on New Task and select CSV, then configure this task before clicking Import:

• Select Retail under Graph.
• Select Edge and enter TransfersTo under Schema.
• Upload the Transactions.csv for File.
• Uncheck Headless as the CSV file has the header row, which contains the property name and type.
• Update the Type of the property cust_no to _from, and merch_no to _to.

Create a Task to import TransfersTo edges

Verify the Graph

You may click Schema from the left side menu to verify the graph.

Verify the graph

Example: Import from Relational

This example demonstrates the process of importing from a MySQL database using Ultipa Transporter.

Download Ultipa Transporter

Download the Ultipa Transporter from here. The Windows version will be used for the following operations.

Prepare the Configuration File

Ultipa Transporter requires a configuration file to run. Below is an example. Please ensure you update it with your MySQL and Ultipa server information under the sqlDatabase and server sections. Click to download this config.yml file.

config.yml
# Mode options: csv/json/jsonl/rdf/graphml/bigQuery/sql/kafka/neo4j/salesforce; only one mode can be used
# SQL supports mysql/postgreSQL/sqlserver/snowflake/oracle
Click to expand

Run Ultipa Importer

Unzip the file you just downloaded in the previous step, and navigate to the folder that contains ultipa-importer.exe and ultipa-exporter.exe. You can also put the config.yml file into that folder. Open the terminal software (e.g., PowerShell) from that folder and run the following command:

Terminal
./ultipa-importer --config ./config.yml

Import the graph using Ultipa Importer

Verify the Graph

You may use Ultipa Manager or other methods to connect to your Ultipa server to verify the graph just imported.