We’re rewarding the question askers & reputations are being recalculated! Read more.

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.

23 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
513 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 ...
2
votes
0answers
18 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 ...
2
votes
2answers
77 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 ...
2
votes
0answers
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 ...
1
vote
1answer
146 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. ...
1
vote
1answer
68 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 ...
1
vote
0answers
32 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 ...
1
vote
0answers
71 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 ...
1
vote
0answers
43 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 ...
1
vote
0answers
44 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
1answer
815 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
1answer
502 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 ...
1
vote
1answer
91 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 ...
0
votes
1answer
91 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 = ...
0
votes
1answer
12 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 ...
0
votes
1answer
78 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 ...
0
votes
1answer
395 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 ...
0
votes
1answer
317 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 ...
0
votes
1answer
23 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 ...
0
votes
1answer
19 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 ...
0
votes
0answers
34 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 ...
0
votes
1answer
72 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 ...
0
votes
2answers
143 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?