As the name suggests, a data connector is a process that transfers data from a source (for example, a data file) to the SundaySky Video Platform where it is used for personalizing videos for your viewers.
SundaySky comes with an ever-growing library of connectors, from which you can choose the one best suited for your needs. In this article you can read about the key features of each data connector.
File Upload
CSV files are manually uploaded to the SundaySky platform.
With this method, you can distribute the video using a landing page built with the SundaySky landing page builder or use your own page and play the video using the SundaySky player.
To learn more, see Using File Upload to Connect Data.
| 1. |
When you have data that is available in CSV format. |
| 2. |
Your source data does not change frequently and is relevant for a relatively long period of time. |
| 3. |
When the communication or campaign is one-off or not frequent. |
Google Sheets
Following a one-time integration process between SundaySky and the relevant Google account, individual data records are pulled directly from the selected Google sheet to personalize videos in real time (when the viewer clicks play to watch the video).
With this connector, you can distribute the video using a landing page built with the SundaySky landing page builder or use your own page and play the video using the SundaySky player.
To learn more, see Using Google Sheets to Connect Data.
| 1. |
When data for personalization is either contained in a Google Sheets spreadsheet or you’d like to export a subset of data to a spreadsheet. |
| 2. |
When the data you use for personalization changes frequently. |
| 3. |
Video campaigns with multiple blasts, where data is updated between blasts . |
| 4. |
When you need to perform operations on the data before it is used in the video. These operations include using formulas for mathematical calculations, formatting cells, and concatenating data strings. |
HubSpot
With this method, you can distribute the video using a landing page built with the SundaySky landing page builder or use your own page and play the video using the SundaySky player.
To learn more, see Using HubSpot to Connect Data.
| 1. |
When data used for personalization is available in your HubSpot account. |
| 2. |
When data used for personalization always needs to be up to date. |
Marketo
With this method, you can distribute the video using a landing page built with the SundaySky landing page builder or use your own page and play the video using the SundaySky player.
To learn more, see Using Adobe Marketo Engage to Connect Data.
| 1. |
When data used for personalization is available in your Marketo account. |
| 2. |
When data used for personalization always needs to be up to date. |
Salesforce
With this method, you can distribute the video using a landing page built with the SundaySky landing page builder or use your own page and play the video using the SundaySky player.
To learn more, see Using Salesforce to Connect Data.
| 1. |
When data used for personalization is available in your Salesforce account. |
| 2. |
When data used for personalization always needs to be up to date. |
SFTP Transfer
Managed by SundaySky Professional Services (free of charge)
Alternatively, the file with the data records can be uploaded to a folder on your SFTP server, and then accessed by SundaySky.
An SFTP transfer is fully automated and can be scheduled to run at certain dates and times. This method does not require human intervention, eliminating the need to perform manual tasks.
With this method, you can distribute the video using a landing page built with the SundaySky landing page builder or use your own page and play the video using the SundaySky player.
| 1. |
When the video can be generated with data that is updated periodically and not in real time. |
| 2. |
When your data is stored in a platform from which it can be easily extracted. |
| 3. |
When you have data that is available in a structured format (e.g., CSV, pipe delimited). |
| 4. |
When your source data changes frequently or you need to upload new records on an ongoing basis. |
Technical stakeholders in your company will need to work together with SundaySky in order to set up the SFTP transfer.
SundaySky API
With this method, you can play the video in the SundaySky player.
However, you cannot distribute the video using a landing page built with the SundaySky landing page builder.
To learn more, see Data Connector: SundaySky API.
| 1. |
When data is available on your backend system and requires system-to-system integration. |
| 2. |
If the viewer data you hold is sensitive. |
| 3. |
If real-time data accuracy is critical when watching the video. |
URL Parameters
With this method, you can distribute the video using a landing page built with the SundaySky landing page builder or use your own page and play the video using the SundaySky player.
To learn more, see Using URL Parameters to Connect Data.
| 1. |
When data is available in the page URL (for example, a dynamic link from an email management system). |
| 2. |
When data is available on the page on which the viewer is watching the video. |
Custom Integration
Managed by SundaySky Professional Services (requires additional fee)
A custom integration is managed entirely by SundaySky.
To learn more, see Implementing a Custom Data Integration.