Microsoft Office Tutorials and References
In Depth Information
Figure 4-13. Manage connections for ECT
Click on add Connection and from external Data source type selection ➤ Data source type,
select sQL server, and click oK.
set Database server, Database name, and optional Connection name in the sQL server
Connection window. For this example, choose “Connect with user’s identity” and click oK.
(also, make sure the logged-in user has sufficient rights on the database selected.)
■ in this example, we will use the adventureWorks database. however, note that we will be using the relational
database this time, not cube data.
the selected data connection will be displayed in the Data source explorer section. expand
the Data source and tables and, after right-clicking on the employee table, select Create all
operations from the context menu. this launches a wizard you can use to create the required
CruD operations for the eCt, as shown in Figure 4-14 . this also allows you to select columns
you’d like to display and define any input or filter parameters.
Search JabSto ::