Business Data Catalogue (BDC) is feature in Microsoft Office SharePoint Server 2007 (MOSS 2007) which allows SharePoint to display data from SAP, Siebel, or other line-of-business (LOB) application via Web services or databases.
0
votes
0answers
11 views
SharePoint BDC Catalog custom sorting
Is it possible any kind custom sorting of the column in SharePoint BDC Catalogs. For example string column which contains numeric and character sequences - make order starting as numbers, then by ...
1
vote
0answers
25 views
DateTime Warning When Fetching Data From Oracle
I have an table, which includes DateTime but DateTime makes warning.ıThe warning always saysy that it assumes it UTC. In DateTime typed value there is just date, not included hours.
Why DateTime ...
0
votes
0answers
20 views
Got this error when I click on my BDC service in Central Admin: The full exception text is: Access is denied
These are the steps I did under the administrator and farm account:
I go to central admin -> application management -> manage service applications
I click on New-> Business Data Connectivity Service
...
1
vote
0answers
17 views
How to figure out a backhand Database in a BDC (BDCM model)
I wanted to know how can one know which Database is a BDCM model using. I did some research and found that I can export the model from the central admin (which I did). Now that I have a model ...
0
votes
0answers
110 views
SharePoint search custom indexing connector using BDC
If we want to create SharePoint search custom indexing connector, following interface/class should be implemented/inherited.
StructuredRepositorySystemUtility
LobUri
INamingContainer
Read the ...
1
vote
0answers
227 views
Sharepoint. External Content Types. Passing values to stored procedure
I have simple stored procedure, that takes couple parameters and updates table.
How to pass parameters via BDC?
For example, to execute stored procedure, that selects rows and takes one param, code ...
0
votes
0answers
156 views
'The HTTP request is unauthorized with client authentication scheme 'Ntlm'. when calling an external list from client
I have created a bdc model using .net custom connector which connects to the External system via a custom built webservice. It works when I open the external lists locally from the SharePoint server ...
0
votes
0answers
157 views
Trying to consume an Odata Web service with SharePoint 2010 BDC Model
I have built a BDC Model inside of Visual Studio 2010. I am getting the cannot display web part in SharePoint on the External List. I know that I have 5700 records that the web service returns. I ...
0
votes
0answers
128 views
SharePoint BDC: Update method doesn't work
EmployeeDataDataContext ctx = new EmployeeDataDataContext(GetConnectionString());
vwCurrentEmployees_Dev emp = ctx.vwCurrentEmployees_Devs.Single(e => e.EMPLOYEE_NUMBER
...
0
votes
0answers
155 views
Disable Sharepoint 2010 BCS/BDC Picker Browse DialogBox Default Population
We have implemented BDC/BCS picker control in our Web part.
When clicking on the browse entities [Search external item(s)] button, I get the picker dialog box which is already populated with the ...
1
vote
0answers
258 views
External data URL in Sharepoint Search - Profile Page URL : BDC3
I want to search in external data source.
I made connection with external SQL Table via Business Data Connectivity (BDC) Service; I made profile pages etc, I set up search, everything works.
But...
...
0
votes
1answer
2k views
ABAP: suppress initial selection-screen in transaction
I want to call Z-transaction via "CALL TRANSACTION" statement and skip it's first screen. But "AND SKIP FIRST SCREEN" addition doesn't work.
I've read that it have sense only when passing to the ...
0
votes
0answers
50 views
SharePoint replicating document between site according to external database on a regular basis
I want to copy a file from Site A to Site B according to external DB status on a timer job.
e.g
I have documents in Site A.
I want to move those documents to Site B when the document' status in ...
1
vote
1answer
316 views
Sharepoint External Data - multi value field
I need to create a list field which contains external datas (from BDC). The field has to contain multiple values. But I didn't found a way how to make a external-data-field taking multiple values.
...
2
votes
1answer
266 views
SharePoint: Unable to fetch information from an external list
I am trying to fetch information from an external list using the following CAML query.
<Where>
<Eq>
<FieldRef Name='EventID' />
<Value ...
0
votes
1answer
306 views
SharePoint 2010 BDC ID Prefix Double Underscore Number Origin
What is the origin of the underscore number prefixed on the BDC Identifier within SharePoint 2010 Business Data Connectivity External List Items. For instance I have a URL
...
1
vote
3answers
2k views
How to connect SharePoint Online with Dynamics CRM Online using BDC?
I am trying to connect SharePoint Online with Dynamics CRM Online using BDC, but I'm not getting any results.
I am trying to use Accounts from CRM in SharePoint Online like a list.
When I have 100 ...
3
votes
1answer
445 views
Enforce Unique Values for external data type column in sharepoint
Enforce Unique Values for external data type column - I know that it is not possible out of the box. What are the soultions for validating external data type columns for duplicates? workflows? others?
...
0
votes
2answers
552 views
Error deploying SharePoint 2010 solution - Cannot create more than '500' IEntity objects per ILobSystem object
I am generating a sharepoint 2010 bdc model xml file along with the entities and associated service classes from a model 1st LLBLGen framework/ C# .net 3.5 project. All was going well when suddenly I ...
1
vote
0answers
787 views
SharePoint BDC Model and WCF
Here is my scenario..
I have created a BDC model project in VS2010 for deployment in SharePoint2010. I have added a service reference to a WCF service that we have running on another system. I want ...
0
votes
1answer
515 views
Business Data Catalog to a SharePoint List?
I have to manage the concept of external contacts in a SP farm.
My idea is to create a custom User Profil with a specific sub-type for such contacts.
There is not yet a storage for this external ...
0
votes
1answer
2k views
SharePoint BDC Service error: Cannot connect to the LobSystem (External System)
Im new to SharePoint 2010. I created an External Content Type in SharePoint Designer using data from AdventureWorks database. After setting permissions for my ECT I created an External List and ...
3
votes
4answers
3k views
How to deploy SharePoint BDC model package using VS setup project (or at all!)
Background: We have a ClickOnce-deployed WPF app, that talks to WCF Services, which in turn both talk to our own SQL database and also to SharePoint via the Client OM. To set up the WCF and the ...
1
vote
2answers
1k views
SharePoint Foundation 2010 and BDC with SQL
Everything I've read on setting up External Content Types with BDC seems to use SharePoint 2010, rather than SharePoint Foundation (SPF) 2010 (the free version). Even though it also includes BDC, it ...
1
vote
0answers
437 views
Sharepoint Business Data List Behavior
This is a multi faceted question, but any help is appreciated
Background:
I have a Application Definition with 6 entities using SSO
The database back end is Firebird through ODBC
All the data is ...
0
votes
1answer
458 views
Sharepoint BDC - Check names not working
Long story short:
I have a BDC application definition in my sharepoint 2007 server, which is pulling data from a SQL server.
Some of this data is the Employee Name.
What i'm trying to do, is that ...
0
votes
1answer
323 views
How to get a BDC or XML file from SQL Server to use for BDC in SharePoint?
I have a simple database for a stack management system. I want to use this database in SharePoint. So I need to use the BDC concept in SharePoint services, right? How can I generate the required form ...
0
votes
1answer
163 views
Download an XML BDC file from a Sharepoint server
There's a BDC xml application file in the server done by another programmer. Is there a way to download the file back to my PC? SO, I can review it.
1
vote
2answers
869 views
Sharepoint 2010 BDC: Connecting to Oracle an using assembly fails
I'm trying to make a BDC connection in Sharepoint 2010 to an Oracle Database using an assembly. When unit testing the assembly, it works perfectly, but when using it in the BDC, I get the following ...
2
votes
0answers
410 views
Problem With Multiple ITransformableFilterValues
I'm trying to filter a BDC list and my filter returns multiple values. When the BDC list is filtered it filters based on the first item and then ignores the remaining values. Has anyone run into ...
0
votes
2answers
938 views
How do I load BDC data from a BDC URL?
I am doing this in SharePoint 2010, but wouldn't be surprised if the problem exists in SharePoint 2007 and has the same solution.
I have a runtime security trimmer on my BDC data. I was expecting ...
0
votes
1answer
131 views
Filter SharePoint Business Data List By Audience
I'm using a Business Data List that displays a list of programs. I want to be able to filter the list based on the audience / user viewing the page. Also, does anyone know if it's possible to ...
1
vote
1answer
681 views
How to use BDC (business Data Catalog) in sharepoint of user define?
I have database in sql server 2008. I have installed the MOSS 2007 also configured the Sared services. I want to Use BDC concept to show the data on sharepoint pages by its web parts. What steps I ...
0
votes
1answer
298 views
Is there any free BDC generator?
I'm looking for BDC generator, I found great one: MOSS BDC Design Studio but is there any free BDC generator?
1
vote
0answers
366 views
Sharepoint 2010 Claims in BDC
I would like my BDC ReadList()-operation to fetch objects based on email from a user claim. I tried using IClaimsPrincipal in a webpart, with no problem, but I can't get it to work in BDC model.
...
2
votes
2answers
153 views
BDC Security Issues
We are planning to use BDC to read and probably write to a SQL Server content database on external server. I have heard that there are many security issues that you may run into or should be aware of ...
2
votes
2answers
972 views
Formatting of BDC Fields
I'm trying to format a field in a BDC (Business Data Catalog) definition, in SharePoint, with a thousand separator.
It doesn't appear to be possible in the BDC XML definition, and only possible ...
0
votes
2answers
386 views
Changing the Sort order on BDC Actions in SharePoint
We have a number of Actions defined in a BDC (Business Data Catalog) definition in SharePoint, and need to change the order they are displayed in the UI.
Within the Action defintion, there is a ...
2
votes
0answers
384 views
SharePoint BDC - In the Entity Picker control when the user selects the entity a guid is added to the text
In the Entity picker when the user selects an entity the id appears in the text box next to the add bottom. Is this normal? Users are wating a more meaniful name like the ProductName which is show as ...
1
vote
1answer
497 views
Allow multiple values to BDC Column
I have added a column called Customer to my documents library, this is a business data column.
What I want to do is relate a document to multiple customers by entering customer codes into this box.
...
1
vote
1answer
987 views
Error with home-grown SharePoint BDC entity definition
I am trying to create my own application definition xml file for the SharePoint BDC, mostly because I want to become more familiar with the concepts. My application uses an in-house Oracle database, ...
0
votes
1answer
94 views
SharePoint MOSS BDC for reading in opml feeds
We currently have some c# code that runs and imports data from a number of opml feeds and stores it in several sql server tables.
We are working in a moss environment and I am thinking the Business ...
1
vote
1answer
251 views
How do I expose Excel 2003 Spreadsheets to PerformancePoint 2007?
I am working on a PerformancePoint 2007 project. I have a bunch of Excel spreadsheets, and I need to get at the data. The users need to continue to enter data, they have Excel 2003, and I won't be ...
0
votes
1answer
239 views
BDC - Problems in applications
I am getting some problems in the BDC applications.
When I import some BDCs application I get an empty error and my BDC applications in Central Administration file has no Version and no data. If I ...
1
vote
1answer
727 views
Custom BusinessDataListWebPart Pagination (Next Button) - pageindex never changes
Pagination (Next button) doesn't work for custom BusinessDataListWebPart.
I am adding BusinessDataListWebPart using code. Everything works fine. I can see 20 data raw at the same time but when I ...
1
vote
3answers
894 views
BDC Web Part connection Interface error
I want to provide "Query Value" to the BDC List WebPart from (Provider) businessdata filter webpart. I get fllowing error when i try to connect.
"The provider connection point ...
0
votes
1answer
208 views
BusinessDataList Web Part Edit view using code
I am adding BDC List Web Part programmaticaly in the Sharepoint. I want to edit view using code too.
Like "Retriever items that meet these criteria" and allow Paging...I tried to do using following ...
0
votes
1answer
394 views
Write log for sharepoint BDC List webpart
How can I write a log for sharepoint BDC List webpart?
I want to know that which sql query bdc list webpart send to the database.
Like I am filtering webpart on "Test". So, what would be the sql ...
0
votes
1answer
3k views
Edit column header of Sharepoint BDC webpart using XSLT
I would like to change database column names of a BDC list webpart using an XSL file.
My SQL query is "Select BATCH_ID...", I want to change that column name "BATCH_ID" to "ID" using XSL. I also ...
2
votes
4answers
283 views
MOSS and the Business Data Catalog - any good documentation?
Can anyone point to any good 'beginners walkthroughs' for the Business Data Catalog in MOSS 2007 Enterprise? It seems to be very powerful, but all the official guides assume preexisting knowledge.
