PhilMacavity
asked on
Sharepoint column from mysql ODBC connector
Hi,
We have a mysql database that contains columns of our customer IDs and customer names that we want to use these as a source for some dropdown selection boxes for list items in Sharepoint – Most likely through an ODBC connector
Ideally what we want to achieve is to have something like you can get using the following steps:
- Create a new site column
- Set it to ‘Choice (menu to choose from)’
- Enter choices in the Additional Column Settings for the items that should appear in the drop down list.
We want a column like above but without having to manually update the list of choices that appear in the drop down list. This is what should be pulled from the mysql database – probably just refreshing its self once a day.
Is this possible by writing a feature to create the column, or through some third party add-ons? Any help to point us in the direction of how to get this setup will be much appreciated.
We have a mysql database that contains columns of our customer IDs and customer names that we want to use these as a source for some dropdown selection boxes for list items in Sharepoint – Most likely through an ODBC connector
Ideally what we want to achieve is to have something like you can get using the following steps:
- Create a new site column
- Set it to ‘Choice (menu to choose from)’
- Enter choices in the Additional Column Settings for the items that should appear in the drop down list.
We want a column like above but without having to manually update the list of choices that appear in the drop down list. This is what should be pulled from the mysql database – probably just refreshing its self once a day.
Is this possible by writing a feature to create the column, or through some third party add-ons? Any help to point us in the direction of how to get this setup will be much appreciated.
You can use the Business Data Catalog to integrate external data sources: http://office.microsoft.com/en-us/sharepoint-server-help/use-the-business-data-catalog-to-integrate-external-data-HA010244360.aspx
ASKER
Thanks, it looks like it will be possible then from the URL provided. Can you please provide more information as to how we would use the Business Data Catalog to acheive our end result?
ASKER
I have been looking into this further and it seems that the BDC connection is only available with MOSS Enterprise. We are only running the standard version of MOSS 2007 so are there any other options for getting this working?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
_