Use the odata service to obtain data tables in access services

ArticleDirectory

• Release the arms database
• Access odata
• Call odata

Open Data Protocol (odata) is a web protocol used to query and update data, or a Web protocol used to query and update data from the current application.ProgramTo unlock and release data. In our enterprise's IT environment, there may already be many odata providers, such as IBM WebSphere, Microsoft SQL Azure, SQL Server reporting services, or online services like Netflix or dbpedia. SharePoint 2010 is also an odata provider. Access Services are also one of the ways to provide odata services. In the following demo, you will see how to extract data from a published access web database and use the data in Microsoft Excel 2010's workbook.

Release the arms database

First, we need to instantiate a ross-text Network Database and release it to SharePoint 2010.

Access odata

Access Services stores data in the list of SharePoint 2010. Therefore, the process of retrieving access services data tables through odata is actually the same as that of querying the Sharepoint list. Here are two blog posts that show more details about the application of odata in SharePoint: This article and this article. I also have a blog post on using the list odata service through WCF. For our Rose text application, the main odata access point is located at http: // server/northwind/_ vti_bin/listdata. SVC. This access point describes all tables provided by the odata service. If we want to obtain the employee table through odata, we use http: // server/northwind/_ vti_bin/listdata. SVC/employees. For more details about odata, refer to the odata developer page.

Note:: For the latter, ie uses the built-in RSS reader for display by default. The page will be very strange. We need to disable the RSS reading function of IE to see the XML content above. Click "Tools"> "Internet Options" in the menu ".

Under the content tab, find "source and webpage News" and click "Settings ".

Deselect open source reading view and restart IE.

Call odata

One method of calling the odata service is to use the workbook in Excel 2010 (Note: The workbook is an add-on and needs to be installed separately. The installation steps are relatively simple in the link provided by the installation package download and Installation Guide ). To import data from the arms database to the workbook, follow these steps:
1. From the workbook tab of the functional area, click "workbook window ".

2. In the open workbook for Excel window, click "feed from data" in the "get external data" section of the functional area ".

3. In the pop-up table import wizard dialog box, enter the odata Access Point address, in this example: http: // server/northwind/_ vti_bin/listdata. SVC

4. Select the expected rose database table from the "Table import wizard. In this example, select "inventory", "categories", and "products ".

5. Complete the Wizard to retrieve data from access services.
The data in the arms database is now imported to the workbook and can be used in excel at any time.

References

Get to access services tables with odata