Docs portal

Enable the Grafo integration on data.world

The Grafo + data.world integration forges a novel connection between semantic domain modeling and your actual data. With Grafo and data.world, you can:

  • Model your business domain as a knowledge graph using the intuitive drag and drop editor.

  • Give your data meaning by mapping your data.world data sources directly to your model using Grafo's unique building-block approach.

  • Query your model in data.world as though your mapped data was part of your raw data source.

  • Manage your mapping definitions atomically so that your data.world queries don't have to change when the underlying data sources change.

Enable the integration

To integrate your data.world account with your Grafo account, go to the Grafo integration in the data.world inetgrations gallery and select the Enable Integration button:

integration_1.png

In the popup window, you will be asked to authorize Grafo to access some of your information. For more information, select the arrow to the right of the permission. You will need to authorize Grafo in order to use the integration:

integration_3.png

In the next popup window, click the Back to your Datasets button.

integration_4.png

On the dataset detail page, click the drop-arrow to the right of Explore this dataset, and select Open in third-party app:

Configuring a data source from data.world

Once you have enabled the Grafo integration, you can access it from any dataset. To begin, open a dataset and select Open in third party app from the dropdown menu to the right of Explore this dataset:

Note

You can also add a data source from the My Data Sources page in Grafo.

In the New Data Source popup window, edit the Display Name and choose data.world for the Data Source Vendor.

integration_8.png

Also, enter the Dataset Owner and the Dataset Identifier, which can be found in the URL of the dataset page in data.world. If you have the URL https://jsmith/fall-2021-rosters, the dataset owner is jsmith and the dataset identifier is fall-2021-rosters.

Click the Submit button to display a confirmation popup window. Confirm that this is the correct Grafo account and then click the Continue button

integration_9.png

The Grafo app should open to the My Data Source page, on which you should see the new dataset.

integration_10.png

Click on the data source name to view the details page, on which you can click to explore the schemas and views of this data source.

integration_11.png

Add a data source from Grafo

In Configuring a data source from data.world, you can learn how to connect a data source using the Explore this dataset menu in data.world dataset page.

You can also add a data source from within the My Data Sources page in Grafo.

To begin, go to the My Data Sources page and click the + NEW DATA SOURCE button in the upper-right corner.

integration_12.png

In the popup window enter the Display Name and choose data.world as the Data Source Vendor.

integration_8.png

Also, enter the Dataset Owner and the Dataset Identifier, which can be found in the URL of the dataset page in data.world. If you have the URL https://jsmith/fall-2021-rosters, the dataset owner is jsmith and the dataset identifier is fall-2021-rosters.

Click the Submit button to display a confirmation popup window. Confirm that this is the correct Grafo account and then click the Continue button

integration_9.png

The Grafo app should open to the My Data Source page, on which you should see the new dataset.

integration_10.png

Click on the data source name to view the details page, on which you can click to explore the schemas and views of this data source.

integration_11.png

Exploring a data source

Click My Data Sources to view all of your data sources, then double-click on the data source you want to explore. The General page presents connection information, statistics, the and other information for this data source,

dataworld_data_10.png

Schemas

On the left-side menu, click Schemas to view a hierarchical list of entities in the data source. Check one or more boxes to exclude those entities from use in Grafo.

If there are multiple schemas in this data source, click the drop-down at the top of the page to choose one of the other schemas.

dataworld_data_11.png

On the left-side menu, click Views to view any of the view in the data source. Type a phrase into the Search field in the upper-right to search across all views.

dataworld_data_123.png

Click the Grafo logo in the upper-left corner to return to the dashboard.

Linking your data.world dataset

The easiest way to add a data source to Grafo is to work from the Data page in your data.world app.

Login to your data.world account and click Data in the left-hand pop-out menu. Then, click the Your datasets card.

dataworld_data_1.png

On the Your datasets page, click on the link of the data set that you want to integrate with Grafo.

dataworld_data_2.png

On the dataset page, locate Explore this dataset in the upper-right corner. Then, click the small drop-down arrow and choose Open in third party app.

dataworld_data_3.png

You may encounter a popup window indicating that you don't have any integrations. Click the Find integrations for you button.

dataworld_data_4.png

The Analysis SDKs & Connectors page will appear. Locate and click on the Grafo card.

dataworld_data_5.png

On the Grafo page, click Enable Integration.

dataworld_data_6.png

In the popup window, review the information and click the Authorize Grafo button.

dataworld_data_7.png

A popup will appear to confirm the integration with Grafo. Optionally, you can click the Read documentation button to access the docs./ Otherwise, click Return to my dataset to return to your dataset page in data.world.

Connect a dataset to a document

Once you have defined your model with concepts, relationships, and attributes, you are ready to connect your dataset to define your mappings.

Open a document and, from the Data Sources menu, choose Add data sources.

integration_13.png

Connect your dataset

In the popup window, check the box of the dataset you want to connect to this document and then click the Add source button at the bottom of the page.

integration_14.png

Click Got It in the confirmation popup.

Now, if you click Data Sources > Manage Data Sources, you will see the dataset in the list.

Update a data source

If changes have occurred to the data source, you'll need to do a few things in Grafo.

In My Data Sources, locate the data source in the list and access the Schemas tab for that data source.

integration_16.png

Click the small circular icon in the upper-right corner to refresh all schemas. This action will cause all recent changes to the data source to be available within Grafo.

integration_15.png

Note

It may be necessary to uncheck and recheck boxes for any table containing fields that are new or have had recent changes.

The example below shows a new column name is now available in the Primary key column in the Mappings popup window.

integration_17.png

Add a view

Navigate to Data Sources in the left-hand menu, then choose the data source in which you want to create a view.

add_a_view_0.png

Next, click the add button in the upper-right corner of the page.

add_a_view_1.png

Enter a View Name and Primary Key, and enter or paste the SQL that renders the view. Click the Preview Query button to see the results that would appear in the view. Click the Save button to commit your changes.

add_a_view_2.png