OData Source - SQL Server Integration Services Design Patterns - page 341

4. Enter the user ID and password you use when connecting to
SharePoint Online. You may also need to provide a domain value, de-
pending on how your site administrator has configured your Active
Directory integration with Office 365.
5. You should now be able to successfully connect to your SharePoint
Online site. Enter the Service Document URL (e.g., ht-
tps://< mysite >.sharepoint.com/_vti_bin/
ListData.svc ) and click the Test Connection button.
Note More information about the OData endpoints offered by SharePoint Online can
be found in Books Online at http://msdn.microsoft.com/en-us/lib-
rary/ff521587.aspx .
Configuring the Source Component
You can bring up the OData Source Editor by double-clicking on the component in the
data flow. The editor is similar to what you'd expect from other SSIS data flow com-
ponents and is shown in Figure 12-3 .