Importer and Exporter are two components of Ultipa Transporter that import and export data respectively.
Usage of Importer
- Support importing from MySQL, PostgreSQL, SQLServer, Kafka, BigData, Neo4J, CSV, JSON, JSONL.
- Support creating graphset, schema and property in the Ultipa database
- Support prefix processing for data IDs
- Support importing into multiple schemas
For instance, acquire data from MySQL database test and inject into graphset shareholding:

- Generate a sample of configuration file
./ultipa-importer --sample
- Modify configuration file
# Declare data source type
mode: mysql
# Data source settings
sqlDatabase:
host: "192.168.1.1"
port: "5432"
dbname: "test"
username: "admin"
password: "abcd1234"
# Ultipa Server configurations
server:
host: "192.168.2.149:60075"
username: "admin"
password: "abcd1234"
graphset: "shareholding"
crt: ""
# Node data configurations
nodeConfig:
- schema: "human"
sql: "select _id, name from entity where type = 1"
properties:
- name: _id
type: _id
- schema: "firm"
sql: "select _id, name from entity where type = 3"
properties:
- name: _id
type: _id
# Edge data configurations
edgeConfig:
- schema: "hold"
sql: "select _from, _to, share from relation where type = 'holding'"
properties:
- name: _from
type: _from
- name: _to
type: _to
# General settings
settings:
batchSize: 10000
importMode: insert
# auto-create graph, schema, and properties
yes: true
- Execute import operation
./ultipa-importer --config ./import.sample.yml
Usage of Exporter
- Supports exporting to CSV (separated by comma)
- Supports exporting into multiple schemas
For instance, export several CSV files (without header) from graphset shareholding to local directory:

- Generate a sample of configuration file
./ultipa-exporter --sample
- Modify configuration file
# Ultipa Server configurations
server:
host: "192.168.2.149:60075"
username: "admin"
password: "abcd1234"
graphset: "shareholding"
crt: ""
# Node data configurations
nodeConfig:
- schema: "human"
- schema: "firm"
# Edge data configurations
edgeConfig:
- schema: "hold"
# General settings
settings:
writeHeader: false
outpath: ./temp
- Execute export operation
./ultipa-exporter --config ./export.sample.yml