Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [external-data]

External data refers to data that isn't under the management of SharePoint, but is made visible through crawl, indexing and search of the external data source.

Filter by
Sorted by
Tagged with
0 votes
0 answers
16 views

Can SharePoint Hosted Excel Files Use ODBC Connections Without Requiring User Installation?

I'm looking to share an Excel file on SharePoint that connects to a Cloudera Impala database via ODBC. Locally, after installing the Impala Cloudera ODBC driver and providing the database credentials, ...
Tejas Naresh Suvarna's user avatar
0 votes
1 answer
147 views

How to create a file:/// link in Sharepoint?

If I include a file link in a desktop Word document, I am able to follow it, for example file:///C:/ or file:///K://my_confidential_network_folder In Sharepoint, the link is displayed as a link but I ...
Stefan's user avatar
  • 141
0 votes
1 answer
52 views

Importing Data from Excel to Sharepoint (External Data field)

I have a list containing external data columns. I have an excel file that has values for external data columns. I want to bulk update via Powershell. When I try to update the value from excel to ...
Mark Antony's user avatar
1 vote
1 answer
43 views

Does Sharepoint API allow 3rd party database calls?

I am recreating an old intranet site using Sharepoint. I have created a few lists in Sharepoint that will be used to show data. Now, I am trying to populate these lists with the same data from the ...
Holt's user avatar
  • 115
0 votes
0 answers
144 views

A connection was successfully established with the server, but then an error occurred during the login process

My 2016 SharePoint farm, among other servers/services, runs two Front Ends and has Business Data Connectivity setup. I have created an external data source to a SQL server database and an External ...
SomeShinyObject's user avatar
2 votes
0 answers
31 views

Create, read, and update from SQL table to on-prem SharePoint 2016?

Ultimately I would like to create an external list that can be customized (i.e., partly columns from a SQL table and partly native SharePoint columns). BCS isn't an option because it would not let me ...
almostsp's user avatar
0 votes
1 answer
167 views

Copy BCS Field from a list to another list using powershell

My problem is when copying items from a list to another, i can see the BCS field in the Display form(the value of the BCS in the display form is correct) but not in the Edit form(the text box of the ...
Jihen's user avatar
  • 513
0 votes
1 answer
237 views

set BCS field using powershell

I have an external data field. I have to copy the value from list to another list. How i can set the value in the other list? $web = Get-SPWeb http://intranet/CAC/RestrictedAreaManco/ $listProspect = ...
Jihen's user avatar
  • 513
0 votes
1 answer
16 views

Synchronize BCS when item is deleted from source

I have a contact list where i store all my contacts info. In my subsites, I have lists where i created an External Data Column which is referenced to the Contact list. The Problem is : When i delete ...
Jihen's user avatar
  • 513
0 votes
1 answer
127 views

read data from external SQL database

What's the best approach for reading data from external SQL database? build web services and call it in web part using ado.net and read data directly in web part using external list and read data ...
Arul kumar's user avatar
1 vote
1 answer
1k views

Save data to SharePoint list from external website

I have a web page running locally on my machine which hosts a bunch of forms for different requests, built using HTML/CSS/JS (AngularJS). I want to export that data to a SharePoint list when a user ...
Anaq97's user avatar
  • 11
1 vote
1 answer
210 views

SharePoint Online Azure SQL Database External Content List Error

I have an Azure SQL database created. I also have fallowed the steps listed hereExternal List from a SQL Azure table with Business Connectivity I have also created an external list on my SPO site. ...
Mile T.'s user avatar
  • 155
0 votes
1 answer
187 views

Update External Data Field in SPD workflow

I created a Workflow in SharePoint Designer that create an item in a List B that was created in List A. The issue that the creation is OK. but when i Update the item, the workflow not delete the old ...
Jihen's user avatar
  • 513
1 vote
1 answer
114 views

SPO Search from external DB

The scenario is this (in SharePoint Online): I am trying to implement a search box, in our Intranet Page, that is connected to an external database. This is just a small DB with people's names, phone ...
JohnKelheim's user avatar
1 vote
0 answers
42 views

Create a Key Filter from an External Data column

I'm currently creating a Document management system in On-prem SP 2013 to store documents with specific meta data terms so the document library is easily searchable/filtered. We have an external DB ...
Samuel Phillips's user avatar
3 votes
1 answer
2k views

How to change the external content type of a list?

I have a webpart that consumes and displays items from a list that has an external content type. The problem is that the list is consuming the wrong font and I would like to know If it is possible ...
Xablau Developer's user avatar
1 vote
0 answers
82 views

Business Connectivity Service on Sharepoint online-How to link with external data source?

We have a sharepoint online(O365) solution,now we are maintaining all our dept user data in a virtual db in our dept itself,i just want to know how to connect our sharepoint site to that data source ...
Vish's user avatar
  • 81
2 votes
1 answer
89 views

"Export to Excel" - Database Connections Data - SP2010

We have few "Database Connections" created in SP Designer 2010 and I used the "Data view" web part to display the database connections' data. Is it possible to export this data to an excel?
George's user avatar
  • 1,522
2 votes
1 answer
68 views

Does external column data refresh change list items' modified and modified by?

I have SharePoint list having External Data column. Now I want to refresh that column data. I can do it through UI using refresh button at top on the column. But I am not sure whether it will change ...
Dhaval Kariya's user avatar
4 votes
1 answer
883 views

Update column having external data as data type using CSOM

I have a list which contains a column having data type as "External Data". I want to update that particular column using CSOM. I have tried below code: ClientContext clientContext = new ...
DRS's user avatar
  • 722
1 vote
0 answers
50 views

How to pull data on to SP Online from an external source without Azure instance?

I am new to SharePoint Online, so checking is there a way to connect and pull/push data from an external data source like (SQl on prem, Chatter) on to SharePoint Online through BCS or External content ...
AXA240778's user avatar
  • 499
0 votes
1 answer
469 views

Data from oracle db to sharepoint 2013 list

I want to get data from oracle to sharepoint 2013 list.I need one way sync only i-e from oracle to sharepoint list.Is there any way other than BCS or BDC? can i do this using web services and jquery ...
zain abbasi's user avatar
-1 votes
2 answers
2k views

Fetching external data into SharePoint online sites

Is it possible to get data from external sources into SharePoint online sites? I suppose rest API's is an option, but how can that be done? Any suggestions would be much appreciated.
mohd tahir's user avatar
  • 2,406
0 votes
1 answer
47 views

Connecting to external data sources like sql database and exchange

I am looking for the best options on connecting my SharePoint list with external data sources like SQL database and exchange servers to update the contacts list automatically. I am using SharePoint ...
SPLearner's user avatar
  • 1,407
3 votes
0 answers
640 views

Excel Services: Configuring Data Refresh for an External Workbook Data Source

Honestly, configuring this has been such a hard experience. I encountered many errors already, one after another but am stuck now. To illustrate what I've come across so far, I've had problems with ...
sharepointnewbie's user avatar
0 votes
1 answer
64 views

Does Excel Services support connecting / refreshing external data that comes from another workbook?

I'm testing Excel Service via the Excel Web Access Web Part. I managed to make a working sample of a chart that retrieves its data from a SharePoint List. However, for some reason, I can't make a ...
bloodfire1004's user avatar
1 vote
0 answers
52 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
0 votes
1 answer
301 views

Inserting an External Link in Page Viewer Webpart in SPS 2013 gives warning

Inserting an External Link in Page Viewer Webpart in SPS 2013 gives warning. Warning Message: Only Secure content is displayed. Gives an option to click on a button name: show all content Please ...
Jason's user avatar
  • 765
0 votes
1 answer
463 views

Lookup column data from another database

I've explored lookup columns, managed meta column, and external datatypes, and I'm either not understanding them, or I haven't found what I'm looking to do, so I'm hoping I can describe my goal and ...
Ken's user avatar
  • 1
0 votes
1 answer
132 views

Sharepoint not indexing external site

I have a simple HTML documentation site with a TOC column on the left side that includes all the links on the page. The URLs are structured http://documentation/section1_subsection1_subsection2.htm ...
Trevor Newhook's user avatar
1 vote
1 answer
403 views

Can not refresh external data in Excel file which connected to Postgres via PowerQuery in Excel Web App

We have an Excel file which is connected to a postgres database via PowerQuery. PowerQuery needs npgsql provider for it. When I open file locally on my computer and try to update data - everything is ...
re-gor's user avatar
  • 111
0 votes
1 answer
27 views

How to use Sharepoint as a filserver against external programs

I am workig for a survey company and we are starting to implement sharepoint as a fileserver. The idea is that the surveyours working in the field uploads there measerud files to the file library and ...
Odd Arne Nohr's user avatar
1 vote
1 answer
930 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
1 answer
560 views

Access is denied when search external SharePoint site

We have an internet (SharePoint 2013) and intranet (SharePoint 2010). I want to have our internet (http://www.example.com) items in our intranet search result. We also have proxy setting. I created a ...
Melika's user avatar
  • 375
0 votes
1 answer
164 views

Apps cannot use External Content Types defined in the Business Data Connectivity Shared Service Application metadata catalog

My issue is getting Unauthoraized exception while accessing external data in workflow 2013 context throw REST call (HttpSend). I read several posts suggests to create BDC model inside App package, ...
Greg Yolshin's user avatar
0 votes
1 answer
25 views

SharePoint Workflows and Lists, External Housing Dilemma

So I have a client who has arranged for their SharePoint environment to be housed and managed to by an external entity (not my contracting group) and we have limited access to administrative ...
Thomas's user avatar
  • 1
2 votes
2 answers
86 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
aaquib_khan's user avatar
0 votes
2 answers
187 views

Searching external files on a disk

I have a bunch (1000s) of external files that I want to search using SharePoint search. What is the best way to index these files and get SharePoint to Search them as well when users key in queries?
user39707's user avatar
0 votes
0 answers
36 views

Sharepoint with external database

We have a Sharepoint application which uses external database besides content database.we have stored connection string in a list to connect to that external database. everything works fine in a ...
SharePointMan's user avatar
1 vote
1 answer
94 views

Crawling external database with security trimming

We have a legacy records management system that we want to index in SharePoint 2013. We just want to index it and leave the documents where they are. The records management system of course has a ACL ...
Juergen Riemer's user avatar
1 vote
1 answer
2k views

POST Request through WebProxy with JSON data

I want to make a POST request with JSON data to a REST API through the WebProxy. Therefor I make a request like: $.ajax({ url: "../_api/SP.WebProxy.invoke", type: "POST", data: JSON....
Mars's user avatar
  • 73
6 votes
1 answer
2k views

SharePoint Hosted App Cross Domain Calls to a REST API

I have a SharePoint hosted app and I want to use the JIRA REST API with it. Which means I want to make requests and work with the data from the responses. Because it's a SharePoint hosted app I can ...
Mars's user avatar
  • 73
0 votes
1 answer
100 views

External Data Column keeps showing wrong value

I have created an external data column that allows you to search by one of the columns. The column is a string in the following format: number-number. For example, "001-001". I have a large range of ...
user11457's user avatar
  • 501
0 votes
1 answer
78 views

Recommended way to access external data?

There are different ways in SharePoint to access external data (i.e. BCS, custom web service, some might even consider creating a custom service application), but is there a recommended way in ...
Celbester's user avatar
  • 193
2 votes
1 answer
6k views

Does sharepoint online support external Data sources

We are looking to migrate to sharepoint online from our current on premise installation and currently have one question that is still unanswered. We use custom WebParts (which we will need if we ...
cujo's user avatar
  • 123
0 votes
1 answer
1k views

SharePoint 2013 InfoPath External Connections with Kerberos

Environment 2 App 2 WFE 1 DB C2WTS account- domain\AppPool (Log on as service/act as OS/Impersonate auth policy on all 4 servers) IIS Kernel mode - off Delegation for the all four servers: Using ...
Mike's user avatar
  • 12.2k
1 vote
2 answers
591 views

Query External Data using BCS

I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than 200,...
Pouyan's user avatar
  • 475
2 votes
0 answers
2k 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 ...
Brent Ellis's user avatar
0 votes
1 answer
294 views

Business Connectivity Services vs. ADO.NET

Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...
Tom Bola's user avatar
  • 381