?
Solved

Sharepoint column from mysql ODBC connector

Posted on 2010-11-10
5
Medium Priority
?
705 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

777 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