locked
which one is best and how? RRS feed

  • Question

  • i had a pjct..in which i need to pull and push data in to sql server..

    if i have 10 vendors and need to send/rcv sql data using biztalk..

    for that which one is gd option?

    creating separate table on the database that wat we need to send/rcv (OR) accessing data from entire database..

    Monday, December 5, 2011 6:25 PM

Answers

All replies

  • Your question is not very clear.

    You mean, you have to read the data from your environment and send it to different vendors (different SQL server's)?

     


    SKGuru
    Monday, December 5, 2011 7:03 PM
  • exactly i need to grab data from sql server and send it to diff vendors based on their requirement...

    my question is my data base is keep on updating..how can pull that updated data..and how i need to write diff SP for that database...

     

    if so instead of writing SP on the entire database Just can i maintain a seaparate table for updates data..so that biztalk can pull that data from the separate table..

    Monday, December 5, 2011 7:08 PM
  • You can use notification service in this case to poll the modified data.

    Please refer this: http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/

    Thanks


    SKGuru
    Monday, December 5, 2011 7:17 PM
  • You can use notification service in this case to poll the modified data.

    Please refer this: http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/

    Thanks


    SKGuru
    Monday, December 5, 2011 7:18 PM
  • Just to add to SKGuru's comments, BizTalk isn't an ETL tool and shouldn't be used for heavy-weight ETL tasks - you'll run into performance issues. If you need to move large volumes of data, consider SSIS packages directly from SQL Server.

    N.


    Nick Heppleston - Independent UK BizTalk Consultant (http://www.modhul.com)

    Please mark as answered if this answers your question.

    Looking for a fast and efficient way to archive messages in BizTalk? Try Atomic-Scope's new BizTalk Message Archiving Pipeline Component. Download a free 14-day trial!

    Tuesday, December 6, 2011 10:26 AM