Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of uppercase, lowercase, numbers, and special characters (such as @*&#).
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Certifications

Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Invoice

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File
v4.3
Search
    中文EN
    v4.3

      Usage Overview

      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:

      From MySQL to Ultipa
      1. Generate a sample of configuration file

      ./ultipa-importer --sample
      
      1. 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
      
      1. 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:

      From Ultipa to CSV
      1. Generate a sample of configuration file

      ./ultipa-exporter --sample
      
      1. 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
      
      1. Execute export operation

      ./ultipa-exporter --config ./export.sample.yml
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写