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:

1. Generate a sample of configuration file

./ultipa-importer --sample

2. 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

3. 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:

1. Generate a sample of configuration file

./ultipa-exporter --sample

2. 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

3. Execute export operation

./ultipa-exporter --config ./export.sample.yml