A variation of a content type that stores content outside of SharePoint.

learn more… | top users | synonyms

2
votes
1answer
1k views

Secure Store Application ID credentials don't work when creating ECT

I have been going crazy trying to figure out why this is not working. I followed Fabian Williams blog entry to the letter. I have a development farm with everything on a single farm. I DID NOT use ...
0
votes
1answer
185 views

How do I populate the VALUEs in one column with the FIELD NAMES of another list?

I'm trying to create a 'request update form' where the user selects an entry which is incorrect and then which field is incorrect and writes a comment and that form will get submitted via workflow to ...
0
votes
1answer
63 views

External content types for specific web applications

Is there any way that we can limit the ECTs are available only for few web applications/site collections rather than across the farm?
1
vote
0answers
62 views

ExecuteWcFOperation http://www.microsoft… slow performance

I am troubleshooting a performance issue and I see some log entries like: Leaving Monitored Scope (ExecuteWcfOperation:http://www.microsoft.com/Office/2009/BusinessDataCatalog/...
1
vote
0answers
300 views

Handling identity column when managing SQL database table using external content type \ external list

I have a SQL table (with a primary key identity column) which I want to perform CRUD operations on using a SharePoint external list as a front end. I have setup stored procedures to perform the CRUD ...
0
votes
0answers
63 views

Edit row information using BDC

I want to make simple database table insert/edit/delete using BDC. What I have tried: I have created External Content type mapped to database table and using external content type created list. But ...
1
vote
1answer
172 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
1
vote
0answers
200 views

Authentication between SharePoint O365 and external OData web service

We are using SharePoint Online (O365) with ADFS. We are also building an on-premise OData web service to provide data into the cloud as an External Content Type. We understand generally how to use ...
0
votes
0answers
562 views

SharePoint 2013 BCS External Data Column

How do I return all entities without using entity.GetFilters() ? I have the following and I can only seem to produce a FilterCollection. I would much rather have just all the enities because i am ...
1
vote
1answer
1k views

Permissions to write to External List from Workflow

I'm attempting to create a SharePoint workflow that creates a new item in an external list using the "Create item in [External List Name]" action available in SharePoint Designer. Currently, I keep ...
0
votes
1answer
768 views

SharePoint 2013 External Content type. Populate secondary fields

I am trying to migrate data to a document library that contains a external content type using the SharePoint 2013 client object model. The external content type is pulling from a sql server 2012 ...
2
votes
2answers
741 views

How to choose the right datatype when creating external content types?

assuming I want to create a SPList using external content types, in my case SQL server tables. When I create my ECT in Sharepoint Designer 2010 SQL data types are mapped to the List as follows: ...
0
votes
1answer
867 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
0
votes
1answer
66 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is unavailable/...
2
votes
1answer
1k views

Throttled While Crawling Large External Databases

I created an ECT using SPD2013 last week. It connects to a SQL DB while using the Secure Store to impersonate a domain user for a particular DB View. Last week, I used my personal (farm admin) ...
1
vote
1answer
76 views

BCS Question (changing data source of a web service)

We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData. If we migrate our database from one location (in Oracle) to another (e.g. ...
0
votes
1answer
168 views

Display friendly field values in SharePoint 2010 list

I have an SQL table where I with the help of an Externl Content Type has created a list in SharePoint 2010. The table has a foreign key to a dim table where the display friendly names are listed. How ...
1
vote
0answers
1k views

Cross-Domain access limited or not happening

I am having issues connecting to the Host Site of the App, to query a List and obtain information. If i manually navigate to the url, `HostURL/_api/web/Lists/getByTitle('tblTestList')/items?$select=...
2
votes
1answer
1k views

Impersonated Windows Identity vs Impersonated Custom Identity

Could anyone explain the difference between Impersonated Windows Identity and Impersonated Custom identity in SharePoint?
0
votes
1answer
530 views

External Content Type = access denied

I have an External Content Type created. It connects to a SQL Server 2005 db, using "Impersonate Windows Identity" authentication, with an account over in Secure Store Service. I've got a Read List ...
3
votes
1answer
472 views

Adding a non WCF SOAP wsdl as external content type in sharepoint manager

This is location to my wsdl, it is WSDL created by Spring WS: http://foo.bar/local/rpc/file.wsdl I am trying to add the connection to external data source from sharepoint designer. In the selection ...
3
votes
1answer
877 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
2
votes
1answer
338 views

SP Designer 2013 - External Content Types & BCS

I'm currently setting up an experimental 2013 environment with BCS, following the instructions in the AdventureWorks white paper found here - http://www.microsoft.com/en-gb/download/details.aspx?id=...
2
votes
0answers
710 views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
1
vote
1answer
405 views

namespace on external content type

I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer. For example, all the ...
0
votes
0answers
343 views

How to perform CRUD operations in SharePoint 2010 on External datasources

I have been working with SharePoint 2010 for sometime now but haven't been able to come up with a solution that can perform CRUD operations on external sources WITHOUT having to rely on an External ...
0
votes
1answer
758 views

Entity (External Content Type) cannot be found with Namespace = 'http://server1', Name = 'user_information'

I restored site collection backup from one farm to another. I am displaying data from this content type on one of my publishing site page. I had already created this external content type before ...
2
votes
2answers
4k views

How can I get external content crawled into SharePoint online index

I have SharePoint online and I want to add external content to the index. So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
1
vote
0answers
336 views

Business Data Connectivity Metadata Store is currently unavailable in Sharepoint designer 2013

I use SharePoint 2013. When I use SharePoint Designer and open my SharePoint website and select External Content Types I get this error : Business Data Connectivity Metadata Store is currently ...
0
votes
1answer
432 views

Workflow to Copy Item to a Library with External Data field?

I have a workflow that is triggered when a item is approved, it looks at the status and copies it over to a archive library with a external data field. Problem I am having is when the copy happens ...
2
votes
0answers
762 views

Alerts on SharePoint 2013 External List

I have created an external list using an external content type reading from a database server on our network that is not on the same machine as our SharePoint database server. I am also sysadmin on ...
1
vote
1answer
90 views

How to create a External Content Type equivalent to a Document Set?

I'd like to create an External Content Type either inheriting from or equivalent to a Document Set. I'm not finding any good examples and Document Sets are derived from folders, so the API must be ...
0
votes
1answer
53 views

Update list from external list on a timer

I have an external list which is generated from an external content type pointing towards my WCF service. I want to expose this list to my users but I don't want to spam the WCF service every time a ...
0
votes
1answer
1k views

Create external content type with impersonated custom identity

I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
2
votes
1answer
799 views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
0
votes
0answers
63 views

External Content Type grab last rows of SQL table instead of first

I'm working with a limit filter on an external content type that grabs the first 1000 rows of my table. Is it possible to instead grab the LAST 1000 rows?
2
votes
1answer
2k views

External Content Type in sharepoint 2013 Office 365 environment

Can we create external content type for SharePoint online environment? If yes then how can we create it using visual studio 2012? Any suggestion or anyone have done something like this? I have a ...
0
votes
0answers
102 views

Cant get items from external list

I have an External list based on an External Content Type that is connected to Dynamics CRM. In an event receiver (C#), I successfully get an SPList instance that is able to print the 'Title' and '...
0
votes
1answer
151 views

When delete BDC Service, the External Content Type and External System are removed too?

I have this problem in my SharePoint 2013 farm, when I use the search feature the system returns this error: "The load balancer is not provisioned. Verify the load balancer was provisioned ...
1
vote
1answer
577 views

External Content Type creating problems in Saving Site as Template on SharePoint 2010

I'm having trouble trying to save a SharePoint 2010 site as template. SPSolutionExporter: Microsoft.SharePoint.SPException: Feature definition with Id a4fbae30-a689-43d0-8f75-484a940336cf ...
0
votes
1answer
656 views

External content type from SQL Query

Can I create a external content type based on an SQL query? Can I make an external list based on that content type. Can I make a list with a lookup column to that new list, and make that field as ...
2
votes
2answers
2k views

How to connect multiple external tables into one SharePoint list to perform CRUD operations

I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
1
vote
0answers
806 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
3
votes
0answers
66 views

Crawled Properties from Business Data not getting created

I have created a content source crawling exteranl data using business data connectivity service. I can sucessfully crawl the business data content source without any errors. In crawl logs also I didn'...
1
vote
1answer
2k views

Add Column to External List from Updated External Content Type

We are currently trying to understand the relationship between External Content Types and External Lists within SharePoint 2013. We have a read-only ECT which we defined based on a SQL Server View. ...
0
votes
1answer
62 views

Problem showing External List in a page

I have a external content type that is showed in section of lists (Insert in Ribbon). I want to add it to a page but when is added, It shows list of BDC Identity, and when I click on them, main data ...
1
vote
2answers
65 views

External “Asset Library”

Any idea if SharePoint has an extensibility point to add an external DAM store as a normal Asset source for images or other media files?
0
votes
1answer
834 views

Sharepoint Designer crashing when trying to add new External Content Type

Sharepoint Designer is crashing when trying to add new External Content Type with below error message: Description: Stopped working Problem signature: Problem Event Name: CLR20r3 Problem ...
0
votes
1answer
346 views

Search External Content type not returning all records

I have a sql view that returns 449 records. I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations. I have created the ...
0
votes
0answers
57 views

Add Connection is empty-External Content Type

When I click on Add Connection the drop down list comes empty. What should I do? Why can't I see the drop down list?