locked
Populating Dropdownlist From Oracle Database RRS feed

  • Question

  • Dear all,

    Grateful if someone can help me.

    I have crated an entity and i have added a dropdown list on the form.

    What I want is to populate the dropdown list from an Oracle Database based on some query onFormLoad.

    Is it possible to populate a dropdown list on the CRM form from a Oracle database??

    If so, can anyone help me please.

     

    Many Thanks,

    Vinay

    Monday, October 4, 2010 6:27 AM

All replies

  • Hello, Vinay.

     

    As for me it is better to create custom entity, create relation with your existing and new created where new created is parent, place lookup on yours and develop some synchronization mechanism which will synchronize data between Oracle DB and created new entity.


    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Monday, October 4, 2010 6:33 AM
    Moderator
  • that you can populate on the client side.but it wo't save in the db.

    but the actual values of the picklist used to carry while creating the picklist.

    if you want to populate the values dynamically, then you have to 1st add the values to the picklist while creating and then as per your condition you can show on the client side(example country and states).

     

    Sudhanshu


    yes.sudhanshu

    http://bproud2banindian.blogspot.com/
    http://ms-crm-2011-beta.blogspot.com/
    Monday, October 4, 2010 6:34 AM
  • you can also do through picklist also but using the approach suggested by Andriy will help you implement this more efficiently. for the synchronization you can write window service or you can use SSIS integration.
    Mahain : http://mahenderpal.wordpress.com
    Monday, October 4, 2010 6:37 AM
    Moderator
  • Hi

    You can add picklist items dynamically using client side scripting but you will have to figure out how you will retrieve data from oracle database.

    You can use picklist attributes AddOption and DeleteOption to dynamically add and remove items from the dropdown in crm. please check the following article in sdk

    http://msdn.microsoft.com/en-us/library/cc189837.aspx


    Hope this helps. Amar
    Monday, October 4, 2010 6:52 AM
  • Thnks Andriy,

     

    Can you please help / guide me to some url how to achieve the synchronization between the Oracle DB and a created new entity.

     

    Many thnks

    Monday, October 4, 2010 6:54 AM
  • Dear all,

    I think the synchronization is the best method.

    Can anyone help / guide me to some url, how to achieve the syncronization between the Oracle DataBase and the new created entity.

    Many thnks.

    Vinay

    Monday, October 4, 2010 6:57 AM
  • Vinay,

    My thoughts here are that the goal is to use dynamic data from the oracle database which will be correct for each CRM transaction but which will have values that change frequently. One instance where this might be true would be a list of currency conversions which come from a cetnral organization database which tracks the offical rates for the company of a number of foreign currencies.

    If this is the type of situation which you are considering I would not syncronize as a strategy.


    Jeff Loucks | Available Technology | 888-474-2237 | http://msmvps.com/blogs/jeffloucks
    Monday, October 4, 2010 7:17 AM
  • Thnks Andriy,

     

    Can you please help / guide me to some url how to achieve the synchronization between the Oracle DB and a created new entity.

     

    Many thnks


    Vinay. It seems that this article - http://blogs.msdn.com/b/crm/archive/2008/05/07/integrating-crm-using-sql-integration-services-ssis.aspx?wa=wsignin1.0 can help you.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Monday, October 4, 2010 7:27 AM
    Moderator