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
1
vote
0answers
58 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?
4
votes
1answer
947 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 = ...
0
votes
1answer
29 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 ...
3
votes
1answer
60 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. ...
0
votes
1answer
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 ...
1
vote
0answers
227 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 ...
1
vote
0answers
195 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 ...
0
votes
1answer
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 (...
1
vote
0answers
45 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, ...
1
vote
0answers
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 ...
0
votes
1answer
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 ...
2
votes
1answer
254 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 ...
-1
votes
1answer
444 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 ...
1
vote
0answers
65 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 ...
1
vote
1answer
466 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) ...
3
votes
1answer
6k 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 ...
0
votes
1answer
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
4
votes
4answers
612 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 ...
0
votes
2answers
488 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'...
0
votes
3answers
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 ...
1
vote
1answer
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(...
0
votes
1answer
161 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 ...
1
vote
1answer
102 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 ...
0
votes
1answer
63 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 ...
2
votes
1answer
40 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.
0
votes
1answer
268 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 ...
1
vote
1answer
279 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 ...
1
vote
1answer
446 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....
1
vote
1answer
146 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 ...
1
vote
0answers
106 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 ...
1
vote
2answers
1k 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 ...
1
vote
0answers
315 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....
0
votes
1answer
512 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 ...
0
votes
0answers
91 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 ...
3
votes
0answers
195 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 ...
0
votes
1answer
20 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 ...
0
votes
1answer
208 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 ...
0
votes
2answers
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 ...
2
votes
1answer
178 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 ...
1
vote
0answers
40 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 ...
0
votes
1answer
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. ?
0
votes
2answers
151 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 ...
1
vote
0answers
112 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 : ...
5
votes
1answer
3k 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 ...
1
vote
1answer
859 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 ...
1
vote
0answers
108 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)....
1
vote
1answer
215 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 ...
2
votes
0answers
528 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 ...
2
votes
1answer
102 views

SharePoint - reporting data from SQL

We have got a time tracker website in ASP.NET which is used by employees to record their daily time and work. The data is huge (about 10 years of data and ongoing) and stored in the SQL database. We ...
1
vote
0answers
660 views

BDC types not coming up as crawled properties in SharePoint 2013 search

I am trying to setup search in my SharePoint 2013 site, using BCS, connecting to a .Net assembly which is exposing the types. The first time I deployed the solution, the exposed types came up as ...

1
2
3 4 5
8