Solved

Sharepoint column from mysql ODBC connector

Posted on 2010-11-10
5
660 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 500 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-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

861 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

30 Experts available now in Live!

Get 1:1 Help Now