Questions tagged [bcs]

Microsoft Business Connectivity Services (BCS) (formerly named the Business Data Catalog) provides the capability to allow data sources outside of SharePoint to be surfaced and potentially modifiable in SharePoint's List user interface. Use this tag for questions or problems related to configuration or using BCS.

Filter by
Sorted by
Tagged with
0 votes
1 answer
88 views

How to create refiner when we have two BCS external content crawled and displayed in Search?

I am using SharePoint 2016 On-Premises Enterprise Search..I have two separate external contents in DB , each of the records having thousands of Data. When the search results displayed I am trying to ...
John Zachariah's user avatar
1 vote
1 answer
47 views

How to Parse External content URL in DB connected via BCS Model in On Premises Search?

I have crawled through External content located in DB in which one Column is having links that are all documents either word or ppt or pdf. I am able to display the row data's in Search, Would like ...
John Zachariah's user avatar
1 vote
0 answers
96 views

Can not retrieve sql server routine return parameter schema information

I am trying to create an external content type on Sql stored procedure in sharepoint 2013 and getting the following error: Invalid Object Name '#...' .Can not retrieve sql server routine return ...
Misha's user avatar
  • 83
1 vote
0 answers
70 views

External Content Type from an OAuth2 secured REST data store in SharePoint Online

Is it possible to create an external content type that accesses a RESTful data store which requires OAuth2 authorisation without building a proxy website in between?
Dale M's user avatar
  • 133
4 votes
1 answer
1k views

Insert item in an external list via REST API

I'm trying to insert an item in an external list (a SQL server table linked to SP through BCS) via javascript...i thought it was simple but... this is the function for insert this.insertListItem = ...
teoooo78's user avatar
0 votes
1 answer
40 views

How to use xml definition in SharePoint list which is configured using BCS

I have a SQL database server with 3 columns ID, Location, FileType, I have used BCS service to connect SharePoint with this table. Now for example Location field is int type something like 19 means ...
Rishabh Shukla's user avatar
3 votes
1 answer
75 views

SQL Data into SP Online and access on mobile

As my title states, I'm looking for some help/resources on how I can pull data from SQL server and display it on SP Online. The added kicker is, we'd like this data to be view-able on mobile devices. ...
Braden's user avatar
  • 147
0 votes
1 answer
1k views

Creating External Content Type under BCS model by connecting to an Oracle Database

I want to create an External content type by connecting to an Oracle database using VS or SP designer,to show data in an external list? I am a bit new to BCS model so a little background will be ...
Ahmed's user avatar
  • 31
1 vote
0 answers
237 views

Read External List (BCS) Data in SharePoint Hosted App

I have this SharePoint hosted app on SharePoint Online. In this app, I am able to read the data from any SharePoint List/Library using the REST calls. However, when I try to fetch the items from a ...
Piyush's user avatar
  • 215
1 vote
0 answers
213 views

Fill in External Item Picker (BDC) with query string value with InfoPath

We are trying to customize a 'new' form with InfoPath so that our query string value (idPatient) is automatically filled in into the External Item Picker (BDC entity). In InfoPath, we have set up the ...
Perneel's user avatar
  • 71
0 votes
1 answer
1k views

BCS External list login failed error

I have created external list from external content type, external content created from Azure SQL Database, but when i open the list it gives me following error. Cannot connect to the LobSystem (...
Trimantra Software Solution's user avatar
1 vote
0 answers
51 views

Query BCS Connection to Update a SP 2013 Library

I have a requirement to update a SP 2013 Library (let's call this Test Library) The requirements are detailed below: Update all items with a Status = Created If Status = Created update: Name, ...
Nina G's user avatar
  • 935
1 vote
0 answers
68 views

How to configure (My sites)User profile services in SharePoint without using AD? [closed]

Configure User Profile services by using External data sources(BCS),I already referred http://www.dotnetfunda.com/articles/show/1628/user-profile-imports-using-bcs But its not Working....Please ...
Debugger's user avatar
  • 1,722
0 votes
1 answer
47 views

Build SQL query and execute

I want the user to be able to select certain checkboxes, in the background a sql query is created, depending on which selections have been made. Then a button is pressed to execute the query against ...
Orange Juice Jones's user avatar
2 votes
1 answer
273 views

What is SecurityDescriptor format?

MSDN article "How to: Configure item-level security in SharePoint 2013" mentions service returning Property with Name="WindowsSecurityDescriptorField". What is actual format, in which this information ...
Tschareck's user avatar
  • 2,165
-1 votes
1 answer
471 views

User Profiles - Merge BCS with AD Sync Data

Preface: Yes, I've read many, many articles related to each aspect of this issue, but still welcome any references. Problem: I'm unable to merge BCS (SQL connection) data with user profiles pulled ...
Ben Willett's user avatar
1 vote
0 answers
73 views

SharePoint 2013 BCS Action mailto not working

I have SharePoint 2013 and I am using BCS to show data from external database. For this external content type I have an action "mailto:{0}", it does not work and generates error "Could not redirect to ...
KayEye's user avatar
  • 169
1 vote
1 answer
549 views

Sync SharePoint list with CRM entities via BCS (on-premises)

all. I have a task to implement one-way synchronization from a custom list on SharePoint to specific type of entities on Dynamics CRM. The case is pretty simple to explain. There is an App (Add-in) ...
Alisher Abdurakhmanov's user avatar
3 votes
1 answer
7k views

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ in BCS

I have already configured BSC service in SharePoint 2013, I created an external content type in SharePoint Designer, everything is ok. But unfortunately, When I tried to browse an external list from ...
Mohamed El-Qassas MVP's user avatar
0 votes
1 answer
20 views

ECT and adding created by and updated by

I'm using BCS and ECT's to connect to external DB. Is it possible to record the user who has updated or created the record in the DB? I'm not using SSS at the moment. Thanks
Orange Juice Jones's user avatar
4 votes
4 answers
720 views

Store 2,500,000 records SharePoint

I want to keep the records of registered user for course registration. There are maximum 100,000 users, 1 user can registered 25 courses. Which means the maximum records can be 2,500,000. One item ...
Vikas Sharma's user avatar
0 votes
2 answers
653 views

BCS connecting to Oracle Database with BDC Model

Firstly I'm open to suggestions if people have better solutions or ideas. I want to create a Dashboard with CRUD operations from the Oracle data and planning on using SPD External Content Types. I'...
Orange Juice Jones's user avatar
0 votes
3 answers
3k views

Parameters not passed to BCS External List via REST API

I have two external lists connected via external content types which are connected to stored procedures in SQL Server. I believe I have them set up identically (though evidently not because one is not ...
Brad's user avatar
  • 141
1 vote
1 answer
3k views

How to add External Content type To custom SharePoint list?

We have a requirement Creating External Content type in sharpoint 2013 based on that SQL database Table. For example in sql i have four database(db1,db2,db3,db4) and sharepoint i have 4 custom list(...
Elina's user avatar
  • 331
0 votes
1 answer
205 views

How we can access External content type to client system via code?

In visual studio we are creating one project and implement some functionality. Then we are deploying in bin folder we can get .wsp file. So the same functionality need for our client or other system ...
Elina's user avatar
  • 331
1 vote
1 answer
215 views

Pull data from SharePoint On-Premises to SharePoint Online

I would like to pull data from SharePoint On-Premise (Custom List Data) to SharePoint Online. When searched on Internet most of the posts are suggesting like SQL Azure Connectivity between SharePoint ...
user53942's user avatar
0 votes
1 answer
65 views

Activating BCS in sharepoint 2013

I'm wanting to use BCS in my SharePoint environment and i came to the problem of the database. Can we connect multiple databases on different servers? Can we select the database from its IP ...
Tanaka J.'s user avatar
  • 143
2 votes
1 answer
44 views

What happens to External List created using BCS from SQL query once the server goes offline?

If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
Jake's user avatar
  • 23
0 votes
1 answer
320 views

MetadataObjectNotFoundExceptionState when creating an external content type in SharePoint Designer

I am getting a really strange error in SharePoint designer upon trying to create an external content type for a simple SOAP Web service. The error happens at the moment I clicked Add Connection, have ...
DmytroL's user avatar
  • 133
1 vote
1 answer
308 views

SharePoint 2010 bcs item limit

I have an on premise SharePoint 2010 implementation. I need to implement a custom form with 65 fields which has rich text, drop downs and some complex filtering logic on the form. I want to load the ...
user1339913's user avatar
1 vote
1 answer
600 views

use external liste error :Oracle database TNS The value's length for key 'data source' exceeds it's limit of '128'

I have created xml model for external list using bcs this is the code example for my BDCM model: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <Model xmlns="http://schemas....
Imen Turki's user avatar
  • 2,183
1 vote
1 answer
154 views

Active Directory Import and it "not supporting" Business Connectivity Services Import

I'm in the process of setting up a new SharePoint farm. We only really need one way import for Active Directory so I've been thinking we'll go with simplified Active Directory Import... however... of ...
mtwelve's user avatar
  • 91
1 vote
0 answers
119 views

How to implement Update/Delete operations using Business Data Web part

I have created a web part page for displaying the contents of my external list with a Filter parameter. I'm using a Business Data List Web part for this. I need to have Update/Delete operations for ...
IshaK's user avatar
  • 11
1 vote
2 answers
2k views

BCS, can I connect a result of SQL query to external database in SharePoint list?

Can I connect a result of SQL query to external database in SharePoint list? As I understand - External Content types could map only one table for list, but I need to get some combined data from few ...
Gennady G's user avatar
  • 1,613
1 vote
0 answers
359 views

BCS REST Performance Issues

So we're migrating from On-Prem 2010 to Office 365 and I need to convert some of our simple calendar webparts to online solutions. I've setup an External Content Type in 365 using SharePoint Designer....
Chad's user avatar
  • 750
0 votes
1 answer
626 views

BCS UserProfile Sync to Oracle not working after upgrade from Oracle 10 to Oracle 11

I am experiencing problems with a BDC connection to Oracle. I am using SharePoint 2013. The database I am connecting to is moved to a new Oracle 11 server. It was Oracle 10. I use this connection to ...
Danny's user avatar
  • 443
0 votes
0 answers
100 views

BCS is to get external data into SP, what about the other way around?

I am going to migrate/update our SP 2010 to 2013 or 2016 (depending on when it actually gets released). Preferably cloud. What our fear is currently is... if we go cloud will we really have access to ...
default_noob_network's user avatar
3 votes
0 answers
213 views

create custom BCS connector

What are the steps to create a custom bcs connector? I have a ftp location where the data gets updated every week. So I want to write a bcs connector which will connect to data source with the ...
user avatar
0 votes
1 answer
21 views

Displaying BCS data like profile view

I have configured external content type and able to display the data in Business data list web part. But now it is showing in table format. Emp ID Emp Name 1 aaa 2 bbb but I want something ...
user48040's user avatar
0 votes
1 answer
256 views

External Lists not working

Two problems. Despite spending all day learning BCS and Enterprise Features and getting all the different levels of credentials set in Central Administration when I put an External List webpart on my ...
seanw432's user avatar
0 votes
2 answers
5k views

Workflow to read data from external list

I have just recently started working with external lists using BDC and was quite surprised to discover that I can’t really interact with the data in any way using SharePoint 2013 workflows (Even just ...
Morten K's user avatar
  • 1,219
2 votes
1 answer
188 views

Provider Hosted App vs BCS

I'm new to Office 365/2013 but I've been working with on-prem SharePoint 2007/2010 for a while. I've mostly setup some simple webparts to pull data out of SQL/WCF and display it. I'm wondering what ...
Chad's user avatar
  • 750
1 vote
0 answers
42 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 ...
Dylan Cristy's user avatar
  • 12.5k
0 votes
1 answer
18 views

External List from SharePoint 2010

I want to know can we create an external list for SharePoint Online from SharePoint 2010 list as a source. ?
RHM's user avatar
  • 543
0 votes
2 answers
173 views

Query on BCS list

I need to retrieve the items of BCS based list. I am using the server side object model on SP2013 and I am getting this error: An error occurred while enumerating through a collection: The shim ...
Nk SP's user avatar
  • 2,883
1 vote
0 answers
113 views

Using a InterSystem Caché database in SharePoint? [closed]

I have searched for any kind of database compatible with SharePoint and at this point I haven't found anything. I've searched on google and msdn. Google gave me this only thread about my question : ...
user28470's user avatar
5 votes
1 answer
4k views

Problems trying to retrieve logs from a Correlation Id

I have a correlation id for an error that an external list has been throwing which I need to view the ULS log entries for. I've connected to the site in SharePoint Online Management Shell using ...
Michael A's user avatar
  • 1,435
1 vote
1 answer
922 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
radicalEdward's user avatar
1 vote
0 answers
116 views

Sharepoint 2013 accessing external list in workflows

I have created an external list using WCF connections. I have in that list all the information that I need. Now I need to access that data from another list workflow(sharepoint 2013 platform workflow)....
Yennifer Yero's user avatar
1 vote
1 answer
238 views

Business Data List web part customization?

I have a question with business connectivity services in SharePoint 2013. I have a connection with CRUD access using an SQL server. The list view displays all records, but I have use the Business Data ...
David Conde's user avatar

1
2
3 4 5
8