SQL to Graph Database (NEO4J) adapter for enterprise databases
Enterprises have long adopted relational (SQL) databases as their choice for data storage due to their ubiquity and guarantee it provided. However, the need to migrate to non-relational databases has grown as data becomes more extensive and unstructured. So has the demand for tools that help migrate a backlog of existing SQL databases to NoSQL databases. Papers exist describing the migration processes, and tools exist that can practically migrate from SQL to NoSQL, but the focus has been on document-oriented databases such as MongoDB. Extract, Transform, Load (ETL) tools are automated pipelines that facilitate the movement of data between data sources and storage platforms. This project explores the development of such a pipeline tool that can help with the migration of data from SQL databases to graph databases using well-established and industry-recognized tools.
Applied project submitted to the Department of Computer Science and Information Systems, Ashesi University, in partial fulfillment of Bachelor of Science degree in Computer Science, May 2023