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?
Mark
· 9 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?
resing
· 6 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.
Lucy Blain
· 6 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 :)
adeelkl
· 3 months ago
I am using time sheets and it is paradox DB file. how can i use this as BDC in moss 07.
All Comments
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?
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?
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 :)