Database Reference
In-Depth Information
■
Note
One of the tabs you see in Figure 7-4 is Project Houston, which is discussed in Appendix A.
3.
After your information is validated, a Database Information section appears on
the page. Select the database on which you want to enable OData, and select
the Enable OData check box. At this point you may think you're done, but not
quite. When you click the Enable OData check box, a User Mapping section
appears on the page, as shown in Figure 7-5.
Figure 7-5.
Configure OData Service Database Information section
As the User Mapping section explains, you can map specific users to the Access Control Service
(ACS) keys or allow anonymous access to your SQL Azure database via OData through a single SQL Azure
account. Now that we have our data exposed via a REST interface it is through the User Mapping that we
control access to our SQL Azure data.
The Anonymous Access User drop-down defaults to No Anonymous Access, but you can also
choose to map and connect via dbo, as shown in Figure 7-6. This chapter talks about anonymous access
shortly. Selecting the dbo option allows you to connect using the database dbo account, basically as
administrator. In a moment you learn the correct way to connect to the OData service.
Figure 7-6.
Configure OData Service User Mapping section
