- This topic has 5 replies, 1 voice, and was last updated 9 years, 1 month ago by
.
-
Posts
-
-
Hi,
what is the best way, to get data from a ms sql server into a biztalk orchestration in realtime?
My problem is, to get changed data from an sql-server to a sap-system in realtime. the way from the biztalk to the sap-system is no problem, but how to get the data from the sql-server to the biztalk?
I think, it would work if i define a trigger in sql, which generates a file in the receive location of the biztalk Another way would be, to check for updates in the table in an intervall by the biztalk-orchestration.
But i think, none of the two ways is really good and performant.
Is it possible to push th biztalk from sql (like from sap via a rfc, …)?
Or is there another way to solve this problem?
Thanks a lot!
-
You can use BizTalk SQL Adapter for this purpose. If you are using BizTalk 2009 then you can use the WCF-SQL Adapter.
Regards,
Abhijit
-
-
Hi mster,
Have you considered exposing your BizTalk orchestration as a web service or WCF service in order to consume it from SQL Server?
Daniel.
-
Hi,
@xman71:
you are right. I think a wcf service is the best way to handle this. I`ve createt one and it works fine … but i am not able to get a string from the service. the value of my response string is allways NULL. ??? Any idea?
Greets!
-
You could look at the new Query Notification capability with the WCF SQL Adapter:
http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.