RDS to neptune data modelling and migration

[Vinod Pandey]

Do we have nay tool by which I can convert /migrate/ my data modeled in RDBMS to neptune supported gremlin csvs

[Stephen Mallette]

I'm not aware of any such tools and until I read this I didn't know that neptune had a CSV format. The format looks pretty straightforward though - seems like it would be quite simple to write some SQL to get your RDBMS data into that form.

On Thu, Mar 29, 2018 at 6:37 AM, Vinod Pandey <vinod....@gmail.com> wrote:

Do we have nay tool by which I can convert /migrate/ my data modeled in RDBMS to neptune supported gremlin csvs

--
You received this message because you are subscribed to the Google Groups "Gremlin-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gremlin-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gremlin-users/d6cef812-2277-4239-9aaf-a5998f87a634%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[kARTHIK R]

I did a similar exercise (not RDBMS but NoSql), and it was fairly easy using python. TL;DR version - Create the CSV files, write the headers (based off your data model), read each row and append to the right files. How you want to model your data into a Graph (what attributes become vertices, what becomes an edge, what becomes a property etc) depends on your user case and application, so I would imagine writing a custom script as the easiest way to go for this. Of course, if you want to do some sort of live migration, where you want all new inserts/edits to your RDBMS to mutate data into your graph, then you'd probably want to write an AWS Lambda function that does it.

Karthik

On Tuesday, 3 April 2018 04:59:55 UTC-7, Stephen Mallette wrote:

I'm not aware of any such tools and until I read this I didn't know that neptune had a CSV format. The format looks pretty straightforward though - seems like it would be quite simple to write some SQL to get your RDBMS data into that form.

On Thu, Mar 29, 2018 at 6:37 AM, Vinod Pandey <vinod....@gmail.com> wrote:

Do we have nay tool by which I can convert /migrate/ my data modeled in RDBMS to neptune supported gremlin csvs

--
You received this message because you are subscribed to the Google Groups "Gremlin-users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to gremlin-user...@googlegroups.com.