Database Reference
In-Depth Information
8.
Open SharePoint Designer and launch the SharePoint online
site. Select External Content Types and click on 'External
Content Type' from the ribbon.
9.
In the new 'External Content Type' window, enter values for
'Name,' 'Display Name,' and click on the 'External System'
link: 'Click here to discover external data sources and define
operations.'
10. Under the 'Operations Designer,' click the 'Add Connection'
button.
11. Choose 'SQL Server' from the available data source types and
click the OK button.
12. Under the 'SQL Server Connection' window, enter the Azure
SQL database server information and Database Name.
13. Choose the 'Connect with Impersonated Custom Identity'
option and enter the ApplicationID you created earlier in this
exercise. Click on the OK button, as shown in Figure A-10 .
Figure A-10. Configure SQL Server Connection
14. The action performed in the last step should connect to your
Azure SQL database provided that the credentials that you set
in the secure store services are accurate.
15. Under the 'Data Source Explorer' expand Tables, right-click
on the table that you created in SQL Azure and choose 'Create
All Operations,' as shown in Figure A-11 .
 
Search WWH ::




Custom Search