SJaya

I'm totally new to SharePoint development...

  • I've created a BDC accessing data from an external SQL Server db using SQL Pass Through. This was created using Admin ID. I'm trying to provide access to execute this BDC for other groups like Reviewers etc. Granting permission from the "BDC permission" screen does not work. How could I make this BDC accesible to other Groups and users

  • Also is there a way to configure the database specification mentioned in XML file while moving BDC from one environment to another

  • In BDC is there a way to clear a filter applied I'm providing option to filter a BDC web part (say by Employee Names) and would like an option for them to get back the entire list again. Is this doable


Can anyone help please



Re: SharePoint - Development and Programming BDC - Setting Permissions to user Groups. (MOSS - 2007)

Todd Walker

The only way I've found to clear a Choice filter connected to a pivot table is to check the box "Allow multiple selections". Then you can deselect everything and thus the filter is cleared. I also tried the "Show (Empty) value" option, but this value did not seem to be understood by the pivot table. I also tried manually entering "(All)" as one of the choices, but it did not seem to understand this either.

Seems like there would be a button for this on the individual filter web parts or on the Filter Actions web part, but there is not.

Perhaps someone has written a custom web part for this





Re: SharePoint - Development and Programming BDC - Setting Permissions to user Groups. (MOSS - 2007)

MikeC224

On the first issue I'm assuming you used "Manage Permissions" for the application to setup the users. Have you verified that the users are setup correctly in the file. When you export the XML file do they appear in the Access Control List as expected

We have created an advanced filter web part that does what you are asking but it works with a specific grid that does not use the BDC for configuration. There is a 5 minute online demo that shows how it works available at http://www.nse.com/content.do ContentId=731 under the heading of "Putting it together, advanced filters, charts, and hierarchies ". The filter has an "All" button that when checked sends back all data for that criteria.

Hope that helps.

Mike





Re: SharePoint - Development and Programming BDC - Setting Permissions to user Groups. (MOSS - 2007)

Chris Johnson [MSFT]

Hi SJaya,

Can you post the XML BDC application definition Specifically the DB connection info.

With passthrough you have be very careful as you hit the two hop authentication problem unless you are using Kerberos. You will likely have to either set up SSO (MOSS only) OR RevertToSelf ... which will use the App Pool identity to access the DB.

Thanks,

Chris.






Re: SharePoint - Development and Programming BDC - Setting Permissions to user Groups. (MOSS - 2007)

SJaya

<LobSystemInstance Name="HDS">

<Properties>

<Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">PassThrough</Property>

<Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">SqlServer</Property>

<Property Name="RdbConnection Data Source" Type="System.String">Devbox10\sql2005</Property>

<Property Name="RdbConnection Initial Catalog" Type="System.String">HD</Property>

<Property Name="RdbConnection Integrated Security" Type="System.String"></Property>

<Property Name="RdbConnection User ID" Type="System.String">uid</Property>

<Property Name="RdbConnection Password" Type="System.String">pwd</Property>

<Property Name="RdbConnection Pooling" Type="System.String">False</Property>

</Properties>

</LobSystemInstance>

Here is my DB connection settings... Would this work

How would I use Kerberos

Thank you for the response. I greatly appreciate the feedback.





Re: SharePoint - Development and Programming BDC - Setting Permissions to user Groups. (MOSS - 2007)

SJaya

Regarding my first issue, I had to create a group on the SharePoint Server and give them access to BDC. So I guess it was a server Group that is referred and not the SharePoint Group. So I setup a common user group on the server for all users in this app and gave them access to BDC application.

The demo is interesting ... I'll look at it more and will get back

Thank you