Setting up Data Integration in a Data Library

Introduction

A data library in the SundaySky platform includes three components: a collection of data fields, a data connector, and a mapping configuration.

When creating a new data library, we recommend that you first add the data fields and then continue to attach a connector and map the data fields.

After the initial selection of the data connector and the mapping process, you can always switch the data connector and edit the mapping as required. When making any change to a data library—in regard to the data fields, connector, or mapping—always remember that any change will affect all the videos that have selected this data library. We recommend that you consider the implications carefully before making any change.

If this is the first time that you are setting up a data integration, we recommend that you read Video Personalization—How It Works and Managing the SundaySky Data Library.


Selecting a Data Connector

The connector is what enables the connection between the data fields that you have defined and the actual data sets that you hold. Put simply, the connector is what determines how data flows from your data source to your data library.

1.

Open the relevant video in the Studio.

2.

Select Data in the sidebar.

 

The data library selected for the video is displayed. Note that the icons in the Status column indicate that the data fields are neither mapped nor in use in the video.

 

Opened_library.jpg

3.

Click Select in the data source section.

 

Click_select.jpg

4.

Hover over the data connector that you want to use and then click Select.

 

Select_file_upload.jpg

5.

Click Select at the bottom of the window to confirm your choice.

 

The name of the selected data connector is displayed.

 

Selected_data_connector.jpg

6.

Continue to mapping the data fields.


Mapping the Data Fields

The mapping process specifies what field in your source data corresponds to the data field that you created in the data library. A precise mapping ensures that the right data is pulled from your data set to populate a personalized video.

1.

Open the relevant video in the Studio.

2.

Select Data in the sidebar.

3.

Make sure that you have selected a data connector for the data library.

4.

Click Map Fields in the data source section.

 

Click_map_fields.jpg

 

In the mapping window, the names of the fields in your data source (in the example below, File Upload) are populated automatically according to the data field names that you defined.

 

Map_fields_window.jpg

5.

Review each pair and make sure that the data source field matches the field name in your data set. If it does not, edit it accordingly.
▶ See the Important Notes below for additional guidelines.

 

Important Notes:

a.

For File Upload, the source fields need to match the column headers in the file.
For SundaySky API, the JSON file needs to use the source fields.
For URL Parameters, the keys need to match the source fields.

b.

The source field names are case-sensitive. This means that the letter case of the source field name and your source data must be the same.

c.

If you rename a data field after setting up a data connector, the source field name is not changed. This name change will not impact the existing mapping.

d.

If you add a data field after the initial library creation, a source field will be created automatically with the same name. You will need to review the new field as explained above.

e.

After any change that you make—including changing and removing a data connector—you'll need to republish the video if you want your viewers to see the updated content. See Publishing and Sharing a Video—Overview to learn more. 

6.

Click Save.


Changing a Data Connector

Warning:

A data connector is a component of a data library. The same data library can be used in multiple videos. If you change the data connector, it affects all the videos using the same data library. We therefore recommend proceeding with caution.

When you change a data connector, the previous mapping is not saved. After selecting a different connector, you will need to review the mapping and make any needed edits.

1.

Open the relevant video in the Studio.

2.

Select Data in the sidebar.

3.

In the data source section, click the three-dot menu and then select Change Source.

 

Select_change_source.jpg

4.

Hover over the data connector that you want to change to and then click Select

 

select_new_connector.jpg

5.

Click Select at the bottom of the window to confirm your choice.

6.

If you are sure that you want to change the connector, click Change.

 

change_data_source.jpg

7.

Review the mapping and make any required edits to the source fields.


Removing a Data Connector

Warning:

A data connector is a component of a data library. The same data library can be used in multiple videos. If you remove the data connector, it affects all the videos using the same data library. A data library without a data connector cannot be used for personalizing videos. We therefore recommend proceeding with caution.

1.

Open the relevant video in the Studio.

2.

Select Data in the sidebar.

3.

In the data source section, click the three-dot menu and then select Disconnect.

 

Disconnect_connector.jpg

4.

If you are sure that you want to proceed, click Disconnect.

 

Disconnect_confirmation.jpg

 

The data connector is disconnected and the mapping is removed.

Was this article helpful?
0 out of 0 found this helpful

Still Have Questions?

SundaySky Support is here for you

contact support