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 perform the following actions in this order:

1. Add the data fields
2. Select a data connector (data source)
3. Map the data fields

Data integration is considered complete after selecting a data connector and mapping the data fields (both addressed in this article).

After the initial data integration, you can always switch the data connector and edit the mapping as required. When making any change to a data library—involving 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 first 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 the status of the data fields. The icon by the first four data fields indicates that the field is neither mapped nor in use in the video.
3.	Click Select in the data connector section.
4.	Select the data connector that you want to use and then click Select at the bottom of the window. ▶ Note that some connectors require an integration process before they can be used.
	The data connector is attached to the library and a message similar to the one below is displayed.
5.	Click Edit Mapped Fields to continue directly to field mapping. ▶ If you prefer mapping at a later time, click Got It! to return to the data library.

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.

The mapping process differs slightly depending on the connector that you are using.

Refer to the Important Notes below for additional guidelines.

Mapping Method #1 Mapping Method #2

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 connector section.
	In the mapping window, the data fields created for the data library are displayed on the right side. For each of these data fields, you'll need to select the field in your data source (in the example below, HubSpot) to which you want to map this field.
5.	For each data field, select the field in your data source to which it should be mapped.
6.	After all the fields are mapped, click Save at the bottom of the window.

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 connector section.
	In the mapping window, the field names in your data source (in the example below: File Upload/CSV) are populated automatically according to the data field names in the data library.
5.	Review each pair and make sure that the data source field matches the field name in the data library. If it does not, edit it accordingly.
6.	(Optional) If you make any changes while reviewing the field mapping, click Save at the bottom of the window.

Changing a Data Connector

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.	Click the three-dot menu in the upper right corner and then select Switch data source.
4.	Select the data connector that you want to change to and then click Switch at the bottom of the window. ▶ Note that some connectors require an integration process before they can be used.
5.	Take note of the videos that will be affected by the connector change and then click Switch Anyway if you want to proceed.
	The data connector is changed and a message similar to the one below is displayed.
6.	Click Edit Mapped Fields to continue directly to field mapping. ▶ If you prefer mapping at a later time, click Got It! to return to the data library.

Removing a Data Connector