Edit connections

A connection makes datasets available to Explore from other databases. When you first onboard to Explore, Guidewire sets up a connection to the Data Studio integration datastore. Each time you publish new datasets to the datastore or publish tables with an updated schema, you must update the connection's tables or columns.

Add tables

Before you begin

You must have the Connection Management role.

About this task

After you publish a new dataset from Data Studio to Explore, you must update the connection to include the new dataset. The dataset arrives in Explore as a table, which is what Explore calls the raw dataset.

Procedure

To add a table:
  1. Go to the Data Database icon workspace, then select Connections.
  2. Select the connection name to open it, then select Edit connection.
  3. In the tables list, select your newly published dataset. It’s usually listed under explore > public.
  4. Select all of the columns to add the entire dataset to the Explore connection. If you don’t select some columns, they will stay in the integration datastore, but they won’t become available in Explore.
  5. Select Update.

Results

Now the dataset is a table in Explore. Find it in the Data Database icon workspace under Data objects > Tables.

What to do next

Make the table more user-friendly by creating an Explore model.

Add or remove columns

Before you begin

You must have the Connection Management role.

About this task

You can add or remove individual columns from an existing table in the Explore connection. Reasons for doing this are:
  • You decide some columns do or do not need to be available in Explore.
  • You update the dataset's column schema in Data Studio, then republish it to Explore using the same dataset name. Explore automatically recreates the table with the same name, but you must update the connection to include new columns or remove old columns. To learn more about updating datasets in Data Studio, see the Data Studio guide.

Procedure

  1. Go to the Data Database icon workspace, then select Connections.
  2. Select the connection name to open it, then select Edit connection.
  3. In the tables list, select an existing table. It’s usually listed under explore > public.
  4. Select or clear columns to add or remove them from the Explore connection.
  5. Select Update.

Results

The table in Explore now contains only the columns you selected in the connection. Find the table in the Data Database icon workspace under Data objects > Tables.