I'm implementing a custom BCS Model to get data from a backend system. As the backend uses it's own user management, I'm accessing it through a service account. All of this works well and allows me to pull data into SharePoint. However because it's channeled through the service account, everyone can access it, which is bad. Can anyone ...
Here's my scenario. I've got SharePoint 2010 running on one server, with an SQL Server running on another. Both machines are on the same domain, but the logins involved are local to each machine. SharePoint is running as NT Authority\Network Service, if that makes any difference. I've created a BCS that pulls data from the remove SQL...
Where does one put validation for external content types? Let's say one field on my ECT represents an email address that must be unique in our system. Where would I put the validation that checks to see that someone hasn't submitted an instance of the ECT with a duplicate email address? How do I bubble up validation errors so they're dis...
We are looking at creating a solution using SharePoint Foundation 2010 with forms-based authentication. The application will access business data by consuming a number of web services via SharePoint's business connectivity service. Both the web service and SharePoint will have access to the same database containing the user data for au...
I'm at a fork in the road. I need somebody to give me some advice from their personal journey in IT. At the moment, I have a college diploma (2 years) in Computer Programmer, and about 2 years of professional experience in the field of software. I'm currently freelancing my programming skills to the public, and am enjoying a nice income...
In SharePoint 2010 BCS, I have created an external content type to retrieve a list of appointments from our LoB application. This works, and I can see the list of appointments in SharePoint. The problem is, I can only see the appointments as a list. I want to display them in a calendar, but that doesn't seem to be an option. I've set t...
We are using SharePoint BCS to connect to our DB2 Database, we have our method configured as the following <Property Name="RdbCommandText" Type="System.String">select "EMPNO","FIRSTNME","MIDINIT","LASTNAME" from ADMINISTRATOR."EMPLOYEE" order by "FIRSTNME" fetch first ? rows only</Property> we also have a limit Filter which provides t...
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 the security trimmer to give me URLs based off of the "default" profile URL defined in the model. Unfortunately, that is not the case. It g...
Hi, I have a list with 3 fields in Sharepoint 2010: ID (counter), Description (String) and ProductCode (Business Data). All works fine if I use the user interface and I'm able to choose che ProductCode from the BCS entity. Now I need to write code to insert items in this list. I simply use this: element["Description"]=var1; element["Pro...