none
InfoPath form's data to SQL / SSRS database RRS feed

  • Question

  • Hi

     

    In my current project we are dealing with a lot if Infopath forms of all sizes and complexities. currently they are being saved in Forms library of sharepoint.

    We need to build a warehouse for SSRS which receives data either from content database or from infopath forms submit with minimum latency.

    I thought of few alternatives, but, not sure which is most robust and economical.

    1. Built c# classes to parse XML of infopath forms and then push data to SQL using ADO.net and SQL stored procedure while item is being added (ItemAdding) to Forms Library.

    2. Use CAML queries to extract XML from forms library and then continue with C#/ADO/SQL..

    3. Use SSIS APIs and webservices to massage XML and put it to SQL at ItemAdding event

    4. Use CAML queries to generate XML files and stage it to FTP and rest will be done on SSIS.

     

    I am currently looking for feseability information based of Besy Known Practise.  Please feel free to suggest a totally new approach, if available.

    Thanks

    Friday, April 11, 2008 12:22 PM

All replies

  • How many types of forms do you have, and over time how many will be added/changed?

     

    personal choice for me would be

    the C# code looks the simplest option (comparing C# and SSIS)

     

    I am assumeing you have C# as part of your companies core compencies. (as with SSIS and CAML)

     

    and also that the SSRS is being produced from the SQL repository.

     

     

     

     

     

    Sunday, April 13, 2008 3:18 PM
  • Hi,

    Currently we have about 100 forms of small to medium size(100 values) and there is a potential to add more..

    Monday, April 14, 2008 12:10 PM
  • I know it's not easy any way you cut it.

     

    but I would think that c# would win hands down for easy of maintance.

     

    the bottom line for me is that you will need to do 'code' somewhere, and if you handed this over to me I would like 1 c# program which does the whole job.

     

     

    however the only way you will know is to do it!

     

     

    Monday, April 14, 2008 12:28 PM