Database Reference
In-Depth Information
There's more...
The example used in this recipe explained how you can create a dataset for Service Man-
ager. The display name is retrieved from another query. Adding other data sources such as
Operations Manager or Orchestrator database information is a simple task. Perform the fol-
lowing steps to create a dataset for Orchestrator:
1. In the
Power Query
tab, select
From Database
and click on
From SQL Server
Database
.
2. The Microsoft SQL database page opens:
◦
Server
: Enter the name and instance of the other data source (for example,
Orchestrator
)
◦
Database
: Specify the other database (for example, the
Orchestrator
database) that you want to integrate in the query
3. In the
Navigator
pane, select the views from the Orchestrator database and click
on
Load
. Load retrieves the data and brings it into the dataset. Alternatively, use
Load to..
to load the query only in the workbook queries.
Once the query is available in the workbook query list, you can start using it to extend your
data query with the procedures that are described in this recipe.
