Building a Parent Teacher Interview System using ECT – PART 5 – BCS AND ECT

This blog discusses how to create the external content type, that you can use directly in
your SharePoint pages.

I will create the following external content types.

1. Schedule view – Manage the schedules

2. Teacher view – Manage the availability of teachers

3. Admin view – All interviews, both booked and not booked. All CREATE, READ, UPDATE,DELETE

4. Teacher view – All interviews that have been booked. READ, UPDATE

5. Parent view – All interviews that have not been booked. READ, UPDATE

Let’s create a new external content type.

Go to SharePoint Designer. Navigate to your site, and click new External Content

Name the External Content Type, and then specify the datasource.

When you choose the datasource, connect with an Impersonated Windows Identity.

Specify the name of the Secure Store.

Right click the table you wish to make a list for, and follow through the wizard


Create the new list for your site.



About whellmuth

Working with the education software industry to build software with standard arhitectures that allows schools to have extensible and well integrated technologies. Member of Software QLD. Member of Microsoft advisory board on cloud computing. My doctorate specialises in Software Architecture in the Education environment. My Master Research specialised in IT change management.
This entry was posted in Microsoft SharePoint. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s