Solved

Sharepoint column from mysql ODBC connector

Posted on 2010-11-10
5
644 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
Comment Utility
0
 
LVL 1

Author Comment

by:PhilMacavity
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
_
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now