Is there any way(api) to import data from Mysql database to Arangodb directly?

[Bruce Feng]

Hello all,

I meet a problem that I can't find the answer by Google.

I have a lot of data saved in MySQL database, and now i want to transfer them to ArangoDB. I know that I can save the data from MySQL to csv or json type files, and them load csv or json files to Arangodb using arangodbimport. But I wonder if there is a more direct way to do this work. Is there any plug-in in ArangoDB to connect MySQL?

Thanks.

[Wilfried Gösgens]

Hi,

usually you want to adjust your data model to better utilize the features of a document store i.e. by removing SQL typical denormalizations, or adjusting pivot tables to become edge collections.

You can write a program that does all this without keeping the data locally, but there is no default tool which connects the two databases and does this for you.

Cheers,

Willi

[Bruce Feng]

OK, I got it.

Thanks for the kind reply.

在 2019年9月27日星期五 UTC+8下午4:50:05，Wilfried Gösgens写道：