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

learn more… | top users | synonyms

3
votes
0answers
106 views

How to provision External content Type using CSOM

Is it possible to provision External Content type and list using CSOM?
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'...
2
votes
0answers
24 views

Reading data from a external list using a 2010 workflow

I work with SharePoint 2013, and need to read information from a external list that I have created. The list can display information correctly when using it through the browser. I need to create a ...
2
votes
0answers
29 views

Display additional fields on forms (External lists)

I have a external list where I have employee information. I am trying to do a lookup where I can select the employee and display it's corresponding department with the additional columns possibility. ...
2
votes
0answers
77 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no "...
2
votes
0answers
149 views

Migrate external content types from 2010 to 2013

I have done a test 2010 -> 2013 migration and most things work fine. I have some user profile property mappings to BDC models I have restored the secure store, managed metadata, BDC services using ...
2
votes
0answers
181 views

Unable to Refresh BCS External Data

I am running into a refresh issue with BCS. Whenever I hit the little refresh button in the UI, I am repeatedly getting this error. I am using an OData web service for BCS with WindowsCredentials ...
2
votes
0answers
242 views

Why can't i get data from External List within my workflow?

Im trying to load a value (string) into my SPD 2010 workflow from an external list. I want to save that value in a workflow variable, so I lookup for that external list and set up my filter's ...
2
votes
0answers
71 views

Updated external content type but connection not updated in central admin

I have an external content type for a sql server view, all working well. I add a new field to the view and save (SPD), in central admin I go to BDC and click on the content type - I can see the added ...
2
votes
0answers
691 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 ...
2
votes
0answers
737 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 ...
2
votes
0answers
77 views

What CMIS services are required if Fast Search is used to query an external CMIS repository

For a repository to be CMIS compliant, it must implement a number of services. Query services are not mandatory. I want to incorporate a CMIS repository in SharePoint 2010 as an External Content Type. ...
2
votes
0answers
495 views

Business Connectivity Services over OData : caching and paging?

I'm planing a new application for a customer that requires to read data from an external system. Basically, the external system will expose a read-only OData service (to be defined actually). The ...
2
votes
0answers
881 views

Sharepoint external list problem

I'm taking my first crack at creating an External list in Sharepoint 2010. I've taken 3 training classes in Sharepoint 2010, and am now trying to transfer my knowledge to my own development ...
1
vote
0answers
109 views

SharePoint Designer 2013 - External Content Type, Page Number filter issue

I have created an External Content Type using SharePoint Designer. The data source is SQL table. The data in SQL table may increase up to around 25k rows. To handle this situation, we are using Page ...
1
vote
0answers
233 views

How to get the data from external SQL Server database in SharePoint 2013 site

What I want to do is retrieve the data from external SQL server database and bring it on the SharePoint 2013 site and show the graphs accordingly. So the data might be from different database tables. ...
1
vote
0answers
104 views

How to correctly update specific columns in an external database through an ECT?

Here is the scenario: I have an External Content Type based on a specific table in an external DB. The table itself has 33 columns, my ECT exposes a total of 13 of those columns, 7 as read-only and ...
1
vote
0answers
45 views

BDC update operation fails with socket exception

I have set up an external content type in my BDC Service, and I am using the Secure Store Service to provide the database credentials. In the ECT I have set up Read Item, Read List, and Update Item ...
1
vote
0answers
45 views

How to enable quick edit in an External List?

I know, it is not supported. I am in the process to customize a ECT list view with access to enable the quick edit function.
1
vote
0answers
16 views

How to tell an ECT developed in VS to use credentials from Secure Store Service?

I am trying to develop an External Content Type using Visual Studio so I can use External Data Source columns in a SharePoint list. Most of the stuff I am finding online uses Designer, but I don't ...
1
vote
0answers
27 views

Display SQL Server data in Sharepoint with the ability to Drill Down

Metadata External List Users need to see & update metadata information about user databases via sharepoint. Users open a Sharepoint site and look for metadata Information Data being pulled from ...
1
vote
0answers
86 views

Updating External List after Updating BCS: SharePoint 2013

I am using SharePoint 2013 and SQL Server 2012, both Enterprise Editions. Earlier I had created an External Content Type and created its External List. I have no problem performing various options ...
1
vote
0answers
55 views

Select Default Filter in BDCM File

When working with Business Connectivity Services (BCS) and Business Data Connectivity Model (BDCM) files, does anyone know in the code where to set the "default" Filter and hide the option? Right ...
1
vote
0answers
105 views

I have a list built on external content using bdc with a custom filter, I get the data but not the filter

SPD 2013, SP Enterprise 2013, SQL 2008 So I have a BDC connector setup with a SQL backend, I then built a Exernal Content List off that. I then inserted a content control webpart and inserted some ...
1
vote
0answers
201 views

Error while creating external content type using SharePoint Designer 2013 against a SQL server 2012 Table

I am trying to create a external content type for my SharePoint 2013 environment using SharePoint designer 2013. The content type will be against a SQL Server 2012 table. The SQL instance is the same ...
1
vote
0answers
16 views

List view of external content type with group by

I've got a list that displays data from an external content type. The view uses group by on a single column and I want it to be rendered collapsed. This view works just fine. And if I create a web ...
1
vote
0answers
221 views

Display Search box on an external list

I have an external list on a sharepoint site, from a BDC connector on sharepoint 2013. I want an inline Search box so that a search can be done on that list only. When i go into the web part and ...
1
vote
0answers
61 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
289 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 ...
1
vote
0answers
196 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 ...
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=...
1
vote
0answers
330 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 ...
1
vote
0answers
801 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 ...
1
vote
0answers
185 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
0answers
199 views

SPQuery on ECT very slow

I am creating a custom web part which is supposed to return results from an External Content Type(ECT) List which contains almost 40,000 records. There are multiple ways the items can be searched and ...
1
vote
0answers
167 views

Use Secure Store Credentials to connect to database with Windows Authentication in Visual Studio solution?

Background: I have an external content type that has been developed in a Visual Studio 2010 solution. This content type is based mostly off elements in a database that are accessed via stored ...
1
vote
0answers
289 views

Does BCS support creating an external list from an existing list in a different web application using List Web Services

I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :- Web Application A > Site Collection > ...
1
vote
0answers
457 views

Create a survey in sharepoint 2010 where question text is from external content type

I have a small issue. I need to create a survey page in SharePoint 2010. This page needs to have dynamic number of questions where text values for this questions are retrieved from SQL Server database ...
1
vote
0answers
534 views

Association created by VS does not work

I am trying to create several ECT with Associations between them. Been playing around with several tools and reading/watching a handful of tutorials. I have gotten my pieces to work when playing ...
1
vote
0answers
590 views

PageNumber-Fillter for Finder in .Net Assembly Connector

I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following. <Method ...
1
vote
0answers
577 views

Problem with Refresh button on External data column

I'm struggling with refreshing items on list with external data. So far I have been able to make the refresh button work, but only when I add items to list in a standard way (via browser). When I add ...
1
vote
0answers
139 views

Could not find IEntity

I have a SharePoint 2010 site collection, which is mainly used to create projects. These projects can contain different phases, which becomes a new subsite when a new project is created. The phases ...
0
votes
0answers
11 views

Create ECT using Nested SQL Store Procedure

I'm creating ECT in SharePoint O365 using SP Designer. I'm defining the operations using Store Procedure. My Read List Store Procedure some thing like below: CREATE PROCEDURE [dbo].[...
0
votes
0answers
11 views

MYSQL External Content Types in SharePoint Online

Is there a way to create an external content type using MySQL in SharePoint 2013 online?
0
votes
0answers
10 views

SharePoint External List editing

I create a page with 2 web parts. one displays the external list and 2nd web part displays the data of selected item. I would like to be able to make this 2nd web part as editable. is it possible? ...
0
votes
0answers
18 views

SharePoint 2013 BCS identity delegation with kerberos and claims

I have a question about the BCS and having it successfully pass through the current users' identity to a SQL database whilst using Claims and Kerberos. I've read a lot of contradictory information ...
0
votes
0answers
29 views

Connecting outside database via WEB API's to SPO

Has anyone been able to automate a connection to an outside source that uses WEB API's? We use Deltek Vision in the cloud, and would like to be able to automate some information to carry over from ...
0
votes
0answers
41 views

Data not showing in External list of SharePoint 2013 site

I have created external content type using stored procedure. Also created read list operation, as well as read item operation. But the problem is that the stored procedure that I have created is ...
0
votes
0answers
39 views

New “Read List” operations is not showing on external list

I am working on a SharePoint 2013 environment. We use external data to display contact information. To use some other Data we created a view on the SQL-Server and added a new Read List operation for ...
0
votes
0answers
26 views

Doing some actions into multiple Item of External list

I have an external list of Microsoft CRM 2011 Accounts in SharePoint 2013 (By BDCS Service). In SharePoint 2013 environment I want to select some items in this External List and apply an action to the ...