DRAG DROP
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.)

Answer:

Explanation:
Box 1: Define general information
Start Microsoft SharePoint Designer 2013.
Click Open Site, and then enter the appropriate site name.
In the Navigation pane, under Site Objects, select External Content Types.
To open the External Content Type Designer, on the ribbon, click External Content Type.
On the New External Content Type page, do the following:
Next to Name, click New external content type, and then enter a unique name for the external
content type.7
Next to Display Name, enter a different name if you want a more descriptive display name.
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