Prepare for Neo4j integration

Before ingesting MySQL metadata into Dawiso, prepare your account for authentication by creating a dedicated user and granting it the necessary permissions.

Connection configuration

Prepare the following information from your Neo4j environment:

• Connection URL (server address)
• Username (Neo4j user account)
• Password (for the Neo4j user)
• Database name (the target database to connect to)

Find your Neo4j connection URL

Depending on your setup, your Neo4j instance may be hosted in the Aura cloud, on-premises, or with another provider.

For Neo4j hosted using Aura

1. Navigate to your list of instances and look for the three-dot symbol in the upper right corner next to the Connect button.
2. Click the three-dot symbol and continue to Inspect in the roll-down menu
3. Look for the Connection URI field, which should be in this format: neo4j+s://aa000000.databases.neo4j.io.
4. Copy this value as the connection URL.

For self-hosted and on-premises deployments

1. Your connection URL will be in this format: neo4j://<ip-address>:7687.
2. Copy this value as the connection URL.

Create a new role, user, and password for ingestion

1. Connect to the system database using your administrator account by running the  :use system Cypher command.

2. Create a new user-defined role, e.g., dawiso_catalog_reader.

   CREATE ROLE dawiso_catalog_reader;

3. Prepare the name of the database you want to ingest, and run the following Cypher script.

   GRANT ACCESS ON DATABASE <DB NAME> TO dawiso_catalog_reader;
   GRANT MATCH {*} ON GRAPH <DB NAME> TO dawiso_catalog_reader;
   GRANT TRAVERSE ON GRAPH <DB NAME> TO dawiso_catalog_reader;
   GRANT SHOW INDEXES ON DATABASE <DB NAME> TO dawiso_catalog_reader;
   GRANT SHOW CONSTRAINTS ON DATABASE <DB NAME> TO dawiso_catalog_reader;
   GRANT SHOW PROCEDURES ON DATABASE <DB NAME> TO dawiso_catalog_reader;
   GRANT SHOW FUNCTIONS ON DATABASE <DB NAME> TO dawiso_catalog_reader;
   GRANT EXECUTE PROCEDURE db.info TO dawiso_catalog_reader;

   • Replace all <DB NAME> with your actual database.

4. Create a user (e.g., dawiso_reader) and assign it the newly created role, setting a strong password of your choice.

   CREATE USER dawiso_reader SET PASSWORD 'password' CHANGE NOT REQUIRED;
   GRANT ROLE dawiso_catalog_reader TO dawiso_reader;

Use the newly created user and password when setting up the Neo4j connection in Dawiso.