Which tool should you recommend?

You plan to create two external content types named ECT1 and ECT2. ECT1 will retrieve data from a database
hosted on a Microsoft SQL Server server. ECT2 will retrieve data from a database hosted on an Oracle server.
ECT1 and ECT2 will be deployed at the server farm-level.
You need to recommend a tool to create the external content types. The solution must minimize
development effort.
Which tool should you recommend? (To answer, drag the appropriate tools to the correct external content
types. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.)
Select and Place:

You plan to create two external content types named ECT1 and ECT2. ECT1 will retrieve data from a database
hosted on a Microsoft SQL Server server. ECT2 will retrieve data from a database hosted on an Oracle server.
ECT1 and ECT2 will be deployed at the server farm-level.
You need to recommend a tool to create the external content types. The solution must minimize
development effort.
Which tool should you recommend? (To answer, drag the appropriate tools to the correct external content
types. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between
panes or scroll to view content.)
Select and Place:

Answer:

Explanation:
Box 1: Define general information
Note: The external content type is a core concept of Business Connectivity Services (BCS). Used throughout
the functionality and services offered by BCS, external content types are reusable metadata descriptions of
connectivity information and data definitions plus the behaviors you want to apply to a certain category of
external data.
Box 2: SharePoint designer does not support building ECT against Oracle.
You will either have to build the model by hand in Microsoft Visual Studio or use a third-party tool.
How to: Create external content types for SQL Server in SharePoint 2013



Leave a Reply 0

Your email address will not be published. Required fields are marked *