Multiple ECT's on same data source RRS feed

  • Question

  • Hi,

    I created an external list using an ECT. I have created the ECT and all operations on a table tbl1 in database X.

    I want to create another another external list from a table from the above same database X.

    1. Can I use the same ECT? If yes How.

    2. Can I create a different ECT using the same data source and create all operations for the new table.



    Thursday, June 14, 2012 9:49 AM


  • Hi Babu,

    If a new External List will work with table different from tbl1 you should create a new ECT based on new table. If you are working with SharePoint Designer you may use already created External Data Source for Database X.


    Lightning Tools LogoLightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

    • Marked as answer by star.wars Monday, June 25, 2012 2:42 AM
    Thursday, June 14, 2012 4:45 PM