Tutorial: Add node types to your graph

In this tutorial step, you add node types to your graph model. Nodes represent entities in your data, such as customers, products, or orders. Later, you connect these nodes with edges to define relationships between them.

Adventure Works node mappings

In the Adventure Works data model, create a node type for each entity. The following table shows the node mappings. Use this information to add nodes to your graph:

Add node types to the graph

To add node types to your graph, follow these steps:

1. In your graph model, select Add node to add a new node type to your graph.

2. In the Add node to graph dialog, enter a Label name and select the appropriate Mapping table and ID of the mapping column.

   

   For example, for the first node, use these values:

   • Label: Customer
   • Mapping table: adventureworks_customers
   • ID of the mapping column: CustomerID_K

   Tip

   You can set compound keys (IDs consisting of multiple columns).

3. Select Confirm to add the node type to your graph.

4. Repeat the process for all other node types in the Adventure Works data model:

   Node type label	Mapping table	ID of mapping column
   Employee	adventureworks_employees	EmployeeID_K
   Order	adventureworks_orders	SalesOrderDetailID_K
   ProductCategory	adventureworks_productcategories	CategoryID_K
   Product	adventureworks_products	ProductID_K
   ProductSubcategory	adventureworks_productsubcategories	SubcategoryID_K
   VendorProduct	adventureworks_vendorproducts	ProductID_K
   Vendor	adventureworks_vendors	VendorID_K

   Tip

   When you double-click on a node type, you see its properties. Each property maps to a column in the source table. Delete properties that you don't need in queries or analysis, because excessive properties make your graph harder to maintain and use.

5. You should see all the node types represented in your graph.

   

6. Select Save to save your progress.

Now that you added nodes to your graph, the next step is to add edges to define the relationships between these nodes.

Next step