?
Solved

Sharepoint column from mysql ODBC connector

Posted on 2010-11-10
5
Medium Priority
?
717 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:PhilMacavity
  • 3
  • 2
5 Comments
 
LVL 21

Expert Comment

by:chapmanjw
ID: 34108787
0
 
LVL 1

Author Comment

by:PhilMacavity
ID: 34110557
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?
0
 
LVL 1

Author Comment

by:PhilMacavity
ID: 34111934
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?
0
 
LVL 21

Accepted Solution

by:
chapmanjw earned 1000 total points
ID: 34112071
Unfortunately the Business Data Catalog is the only way I am aware of for integrating external data in the fashion you are looking to do.  
0
 
LVL 1

Author Closing Comment

by:PhilMacavity
ID: 36098146
_
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question