Solved

Sharepoint column from mysql ODBC connector

Posted on 2010-11-10
5
671 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

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…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

775 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