DISQUS

DISQUS Hello! SharePoint Magazine is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

SharePoint Magazine

SharePoint Magazine is an online magazine dedicated to the world of SharePoint and related Information Worker technologies.
Jump to original thread »
Author

Everything You Need to Know about BDC: Part 1 of 8

Started by Arno Nel (SharePoint Magazine) · 8 months ago

 
Welcome to the first of an eight part series on the Business Data Catalog (BDC).  While BDC is an enormously powerful tool, it’s also fairly complex and not well understood.  This series is considered technical in nature and intended for SharePoint installers, a ... Continue reading »

4 comments

  • Andy Montgomery

    5 months ago

    Hi,

    I have been working with BDC and BDC Metaman trial version for the last couple of weeks as part of a BDC proof of concept.

    I have succesfully connected to several Oracle database and overcome all the the security issues but now my biggests pains are based around the following:

    I cannot do queries that contain Where column = , Order by column, group by column at all in BDC
    I cannot do table joins where there are foreign key relationships
    I cannot do aggregate functions, like select column,count(*)

    To overcome this, we have put Oracle views in the database to abstract away the complexity, but this is getting beyond the joke slightly. Surely BDC caters for where clauses and sorting of data?

    Can this be done in the ADF?
    reply
  • Mark

    5 months ago

    This has been a tremendous help for us. One thing we are having an issue with is assigning BDC permissions to groups. We are going into our Central Admin SSP and clicking "Business Data Catalog Permissions"

    However, it is not finding any of our SharePoint groups. I can add permissions to users (both AD and FBA) easily, but it will not recognize any groups. For instance, I have a group set up called "Members Only" in one of my web applications that I would like to give access, but it will not find it.

    Any thoughts on what I am doing wrong here?
    reply
  • resing

    2 months ago

    Mark, I'm sure you've either figured this out or given up by now, but you should know that SharePoint Groups are Site Collection Specific. The SSP can't see the Groups in other Web Applications that contain your Site Collecitons.
    reply
  • Lucy Blain

    2 months ago

    Hi Randy, I was wondering if you might be able to help? We have read these 8 tutorials many times and always finding something else useful, very well written and easy to understand!

    We are trying to bring data from SQL into a customised list using the BDC, we want to be able to view and refresh the BDC columns' data from SQL (but no need to update it) the only updates will be to the other custom list columns.

    We have succeeded to use the BDC tools to get a def file created and the data is indeed coming through to BDC web parts and now into our list. However we can only add one row at a time using the MOSS GUI tools provided and would like for example to add this months (multiple) rows from SQL, to then be viewed in the list, the user can update the other list data as necessary beside this.

    I can't workout whether I need to add/change my finder method, or whether I need to somehow use code behind to populate my list with multiple rows.. is this possible out of the box as such?

    Many thanks in advance for your advice. And looking forward to more great articles..

    Lucy :)
    reply

Add New Comment

Returning? Login