Microsoft Office Tutorials and References
In Depth Information
Connectivity Service page,
filtered by External
The External System Specifies the actual external source of data and the protocol used
to access it, such as a SQL server database, a web service, or an OLEDB or ODBC
database using an ADO.NET connector. It can also be considered the line-of-business (LOB)
system. When managing external systems, you can still import a BDC model, set
permissions, and delete. In addition, there is a Settings button, but often the external systems for
the BDC service application don’t have any conigurable settings.
The External Content Type Specifies the actual data within the external system that is
being accessed using the BDC service application instance. When you are viewing
external content types, there is an Import button for BDC Models, as well as permission
buttons and Delete.
Each part of a service application can be secured, and as such, each has permission settings.
At the service application level, you can set up administrators allowed to invoke the selected
service application. The BDC has three additional parts that can be configured, and each of
those has object and metadata store permissions. Setting the Object permissions applies to that
particular object, whereas modifying the permissions of the metadata store can affect all
metadata used by the BDC service.
This gives you the option of securing the whole application, a BDC model, its external system
connections, or the content types (which is generally what I apply permissions to for user access).
Administrators This button takes you to a page where you can add administrators who are
allowed to administer the selected service application instance (Figure 11.26). Farm
administrators already have the right by default.
Properties Click this button to see or change the settings you configured when creating
the service application instance (or proxy connection). Settings such as the application pool,
database, service name, and managed account are displayed (Figure 11.27).