Setting up Data Integration for a Video

Updated May 14, 2023 15:23

Setting up a Data Connector

Once you have decided on the data connector that suits your needs, you are ready to implement that data connector in your video. The connector is what enables the connection between the data fields that you have defined and the actual data that you hold regarding your viewers.

1.	Open the relevant video in the Studio.
2.	Select Data in the sidebar.

3.	In the data library—in the data source section—click Select.

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

5.	Click Select again to confirm your choice.

	The selected data connector is displayed.

6.	Continue to Mapping the Source Fields.

Mapping the Data Fields to the Source Fields

After you have connected your video to a data source, you can map the source fields in the data library to your source data. The source field is populated automatically after you create a new data field and is, by default, identical to the data field.

Review all the source fields to make sure they match your source data. If a source field does not match, you'll need to edit it accordingly.

To edit a source field:

Hover over the row with the source field that you want to edit.

Click the three-dot menu at the end of the row and then select Edit.

Edit the source field so that it exactly matches the field name in your source.
▶ 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 publish the video to the channels if you want the change to be reflected in the published videos.

Click Save.

Repeat steps 1-4 for all the source fields that need to be edited.

Changing a Data Connector

When you change the data connector, any source fields that you have edited for the previous data connector are not saved and you need to redo the process for the new connector.

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.

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

5.	Click Select again to confirm your choice.

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

7.	Review all the source fields according to the guidelines in Mapping the Data Fields to the Source Fields.

Removing a Data Connector

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.

4.	If you are sure that you want to proceed, click Remove.

	The data connector is disconnected and all the source fields are removed.