.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

View Complete Post

More Related Resource Links

Error Creating External Content Type using Sharepoint Designer 2010

I am trying to create an external content type using Sharepoint Designer 2010. I ran SD on my local machine and connected to a site on some other machine running Sharepoint Server 2010. The Db on which I want to create my ECT resides on my local machine. When I try to use User Identity to connect to my local Db server, it gives me the error that login failed for user <my domain username>. I have both sql server and windows authentication mode login enabled on my sql server. Any help in this regard is appreciated.

SharePoint Designer 2010 External Content Types Data Source Already Exists in Business Data Connecti


I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer.  Later I changed some column names in the table.  I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the Business Data Connectivity Metadata Store and it refers to a different data source.  Cannot complete operation generation.  Add a connection to this data source with a different name and try again." 

I re-created the Secure Store using a different name in SharePoint 2010 Central Administration.  I didn't find the option to choose the connection name in SharePoint 2010 Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.

SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa


Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!

Creating SOAP or REST Data Sources in SharePoint 2010 Designer while using Forefront Server


When I create a REST data source to access a sharepoint list, I have permission issues because of the Forefront sever in front of my SharePoint 2010 server.  I've tested in an environment without the Forefront server and it works as expected.

1.  Tested in browser and works fine againsted forefront server (https://myforefrontserver.com/site/sub/_vti_bin/ListData.svc/MyList)

2.  Added this to web.config

      <proxy autoDetect="true" />

3. Created Rest Data Source in SharePoinbt designer pointing to https://myforefrontserver.com/site/sub/_vti_bin/ListData.svc/MyList and tried all logon options with no sucess.

Out of ideas

SharePoint Designer 2010 workflow specified in Content Type retention policy not starting



I have a SharePoint Designer 2010 resuable workflow that uses the "Start Approval Process" Task Action. This workflow needs to run after a document has been declared a record. So I have a Content Type that has an Information Management Policy (IMP) attached to it. And I have 2 retention stages specified in the IMP. The first retention stage action is to run the workflow. And this Content Type is associated with the Document Library containing the records. But for some reason, the SPD workflow never gets triggered. The document has been successfully declared as a record. I also see in the document's "Compliance Details" screen, the "Scheduled Occurrence Date" is set to the proper date, but the workflow never got started on that date. I tried it with different dates that I set in the document, to ensure that the workflow runs on "Scheduled Occurence" dates such as 11/19/2010, 11/20/2010 to no avail.

What am I missing? Any help/suggestions would be greatly appreciated as always.

Best regards,
Kiran K

How exactly does a SharePoint 2010 External Content type / list work?



I'm trying BCS on an SQL table which contains about 300,000 rows. Following is what I've observed:

1. A "SELECT * FROM <TABLE>" query fired on the SQL Table using SQL Management Studio returns all the result in 12 seconds
2. The same data when accessed by browsing the default view of external list (to which an External Content Type (ECT) built over the same SQL table in SharePOint Designer 2010 is attached) takes about 3:14 minutes

If I edit the ECT (using SharePoint Designer) and set limit as 100,000, it takes about 49 seconds to load, and further reduction in limit reduces the time to load.

My questions are:

1. What is it that causes so much delay in accessing the rows, as SQL delivers them in 12 seconds? Can anyone please help me understand the BCS / ECT architecture- how it accesses data, etc.
2. Can I implement paging in ECTs created using SharePoint Designer 2010?

Any help shall highly be appreciated. Thans in advance!


Configuring SharePoint Server 2010 Search for External Content Types, Part 2

Learn how defining external content types reduces crawl times for large amounts of data by using incremental crawls.

Configuring SharePoint Server 2010 Search for External Content Types, Part 1

Learn how to use SharePoint Designer 2010 to define external content types and to set up a SharePoint Server search crawl that includes that external data.

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Video: Creating Workflows in SharePoint Designer 2010

This demonstration shows how to create a powerful list workflow with code-style logic by using SharePoint Designer 2010. (Length: 8:15)

Video: External Content Types and Business Connectivity Services for SharePoint 2010

This video discusses the concept of external content types for Business Connectivity Services. (Length: 1:34)

Cannot install Sharepoint Server 2010 "A previous installation has been detected with a license type

I'm trying to upgrade to Team Foundation Server 2010 and Project Server 2010. After getting TFS 2010 and Project Server 2007 to work with WSS 3.0, I started upgrade to Project Server 2010 which requires update to Sharepoint Server 2010 Enterprise. I installed pre-requisites and run "stsadm -o preupgradecheck" which passed everything. When I tried to run the installation I get Setup Warning "A previous installation has been detected with a license type that does not match the install in progress". I thought that my trial licence for Project Server 2007 stopped this so I completely uninstalled WSS 3.0 and restarted the server but the installation still stops with Upgrade window. Any ideas? Regards    mjsk

Creating Custom Business Connectivity Services Connectors Using SharePoint Server 2010

Learn how to create a Business Connectivity Services (BCS) custom connector to integrate data sources into SharePoint Server 2010.

Error creating Read Item or Read List operation in Sharepoint Designer 2010

In terms of high-level requirements, I need to pull in lists from a couple of different web apps.  To do this, I’m using SPD 2010 to create an External Content Type for the list of interest.  I’m able to create a SOAP Service or WCF Service connection just fine.  However, when I try to create the external content type and create a Read Item Operation on one of the GetList or any other Get* (or other Update methods for that matter) methods, I get the following error:"The method that your operation is based on has parameters with complex types that do not have default parameterless constructor.  This kind of data source methods cannot be used in Business Data Catalog."I tried defining an operation on the “AddAttachment” method, and that worked just fine.  I also tried providing default values to the listName and viewName parameters when creating the SOAP Service connection, but still get the error.  Same issue with a WCF Service connection as well. Does anyone know if this is a 2010 issue, or am I approaching this requirement incorrectly?  What are other approaches for connecting to lists that reside in a different web app than yours? 

External content types are not working in SharePoint 2010 Web Front End in DMZ


I have discovered that my Web Front End server will try to connect directly to the SQL server I have listed in my external content type.  I am able to render the contenct properly on my SharePoint 2010 App server, but when I try to render the list on the DMZ server I receive Cannot connect to the LobSystem (External System).   Is there a way around this?  I would like my Web Front End to connect only to my SharePoint 2010 App tier which has access to all of the databases in my infrastructure.  The Web Front End only has access to the App tier.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend