Adding a Data Warehouse
The data warehouse
is used to expose information stored inside a SQL database using the standard
search and data extraction endpoint. This endpoint exposes data using OData
standards. Any number of warehouses may be created for a single community.
Follow these steps to create a data warehouse.
- On the Interoperability Service Properties dialog, select the Data Warehouse tab, and then right-click in a blank area of the window and select Add Data Source, for example: The Data Warehouse Endpoint Wizard dialog appears.
- Click Next.
- Select Use current community database as warehouse to use the current community’s database context and list all the tables and views to be used as exposed OData entities and then click Next.
- Select the Database Server from the list and then click Next.
- Enter the Username and Password for the database, and click Next.
- Select the database to which the data source will reference, and then click Next. For example,
- Enter a Warehouse Name and then click Next.
- Select all tables and views that should be exposed using the OData provider, and then click Next to complete the wizard.
- Click Close to close the Data Warehouse Endpoint Wizard.