title | description |
---|---|
Data migration |
Master the process of data migration with Memgraph. In-depth documentation outlining the necessary steps for effective graph computing. |
import { Callout } from 'nextra/components' import { Cards } from 'nextra/components' import {CommunityLinks} from '/components/social-card/CommunityLinks'
Where is the data you want to migrate?
- CSV files
- JSON files
- CYPHERL files
- Neo4j
- Data from an application or a program
- Relational database management system (MySQL, SQL Server, Oracle DB, PostgreSQL, AWS S3)
- In a stream
- Parquet, ORC or IPC/Feather/Arrow file
- NetworkX, PyG or DGL graph
Schedule a 30 min session with one of our engineers to discuss how Memgraph fits with your architecture. Our engineers are highly experienced in helping companies of all sizes to integrate and get the most out of Memgraph in their projects. Talk to us about data modeling, optimizing queries, defining infrastructure requirements or migrating from your existing graph database. No nonsense or sales pitch, just tech.
To import data from CSV files into Memgraph, use the LOAD CSV clause, which is used as a standard Cypher clause, and can be invoked straight from a running Memgraph instance.
You can import data from a JSON file into Memgraph
by using the json_util
query
module, which contains
procedures for loading JSON files from a local file and from a remote address.
You can also use the import_util.json
procedure to
import data from a local JSON file, but the file needs to in a specific format
defined by the procedure.
If your data is in the form of Cypher queries (CREATE
and MERGE
clauses)
within a CYPHERL file it can be imported via Memgraph
Lab or mgconsole.
Export the data into a CSV file and import it into Memgraph using the LOAD CSV clause, like in this example.
Alternatively, you can use the migrate
module which allows you to
access data from a Neo4j
database.
Memgraph offers a wide range of client libraries that can be used to connect directly to the platform and import data.
Ideally, export data into a CSV file, remodeled the data and rewrite the CSV file, then import it into Memgraph using the LOAD CSV clause, like in this example.
Alternatively, you can use the migrate
module from the MAGE graph
library which allows you to access data from a MySQL database, an SQL Server,
Oracle database, PostgreSQL or a CSV file in AWS S3.
Memgraph comes with full streaming support, and you can connect directly to a Kafka, Redpanda or Pulsar stream using Cypher queries or Memgraph Lab.
If you are a Python user you can import Parquet, ORC or IPC/Feather/Arrow file into Memgraph using GQLAlchemy.
If you are a Python user you can import NetworkX, PyG or DGL graph into Memgraph using GQLAlchemy.