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.
48
questions
0
votes
0
answers
61
views
I have an Excel file with pivot tables accessing external data (a separate Excel file). Where do I put this external data file?
I have an Excel file containing both VBA macros, and pivot tables which access data from an external source (another Excel file).
I've been asked to share this dashboard via SharePoint. As it ...
0
votes
1
answer
45
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 ...
1
vote
1
answer
41
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 ...
- 115
0
votes
0
answers
136
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 ...
2
votes
0
answers
29
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 ...
- 21
0
votes
1
answer
164
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 ...
- 523
0
votes
1
answer
226
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 = ...
- 523
0
votes
1
answer
15
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 ...
- 523
0
votes
1
answer
124
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 ...
- 190
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 ...
- 11
1
vote
1
answer
204
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.
...
- 155
0
votes
1
answer
185
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 ...
- 523
1
vote
1
answer
112
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 ...
- 154
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 ...
3
votes
1
answer
1k
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 ...
- 157
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 ...
- 71
2
votes
1
answer
88
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?
- 1,512
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 ...
- 326
4
votes
1
answer
872
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 ...
- 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 ...
- 499
0
votes
1
answer
467
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 ...
-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.
- 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 ...
- 1,407
3
votes
0
answers
632
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 ...
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 ...
- 238
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, ...
- 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 ...
- 765
0
votes
1
answer
452
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 ...
- 1
0
votes
1
answer
131
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
...
- 381
1
vote
1
answer
393
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 ...
- 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 ...
1
vote
1
answer
927
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
1
answer
557
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 ...
- 375
0
votes
1
answer
155
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, ...
- 13
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 ...
- 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 ...
- 21
0
votes
2
answers
184
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?
- 11
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 ...
- 3,364
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 ...
- 1,057
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....
- 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 ...
- 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 ...
- 501
0
votes
1
answer
77
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 ...
- 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 ...
- 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 ...
- 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,...
- 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 ...
- 756
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 ...
- 381