retrography
10/27/2014 - 10:09 PM

A Scriptella configuration file for exporting data directly from Neo4j into a MySQL database

A Scriptella configuration file for exporting data directly from Neo4j into a MySQL database

<!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
    <description>Scriptella ETL File Template.</description>
    
    <!-- Connections with batch-loading configuration -->    
    <connection id="graph" driver="org.neo4j.jdbc.Driver" 
        url="jdbc:neo4j://graphserver:7474">
        statement.fetchSize = 1000
    </connection>

    <connection id="project" driver="com.mysql.jdbc.Driver" 
        url="jdbc:mysql://sqlserver:3306/database" user="root" password="">
        statement.batchSize = 1000
    </connection>
    
    <!-- ETL Queries and Scripts -->
    <query connection-id="graph">
        MATCH (p:Package)-[r1]-(f:File)-[r2]-(s:Snippet) 
        RETURN p.title AS package, f.name AS file, s.sha AS sha 
        ORDER BY p.title;

        <script connection-id="project">
            INSERT INTO test (package, file, sha) 
            VALUES (?package, ?file, ?sha);
        </script>
    </query>
</etl>