Can i copy data from ADL to Neo4j graph database using ADF

Siddartha Reddy Jammula 20 Reputation points
2024-06-06T14:27:54.4+00:00

Hello,

I want to load data from ADL to neo4j database using ADF. Can I do that using ADF??
If yes, what are the different options I have?

My first priority is I want to use ADF activities if that's not possible i can use python coding.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,409 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,012 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. phemanth 8,080 Reputation points Microsoft Vendor
    2024-06-07T06:30:13.5666667+00:00

    @Siddartha Reddy Jammula

    Welcome to Microsoft Q&A forum and thanks for reaching out here.

    No, Azure Data Factory (ADF) currently doesn't have a native connector to directly load data into a Neo4j database. However, ADF does not provide a direct activity for loading data into Neo4j. You might need to use a combination of activities and scripts to achieve this.

    Using ADF Copy Activity: You can use the ADF Copy Activity to move data from ADL to a more common format like CSV. Once the data is in CSV format, you can use the LOAD CSV command in Cypher, Neo4j’s query language, to import the data into Neo4j

    refer: https://neo4j.com/docs/getting-started/data-import/

    Using Python Coding Entirely:

    Direct Data Load: Develop a complete Python script using the Neo4j driver to:

    • Access data directly from ADL using libraries like adl-pandas.
    • Process and transform the data as needed.
    • Connect to Neo4j and execute Cypher queries for data insertion.
    • Python Coding Entirely: This option offers more control and flexibility, especially for complex data transformations. However, it requires writing and maintaining the entire data processing logic yourself.
    • Neo4j Python Driver: https://neo4j.com/docs/api/python-driver/current/

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments