p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   Biztalk (http://p2p.wrox.com/biztalk-112/)
-   -   Dynamic Database Action in BizTalk 2009 (http://p2p.wrox.com/biztalk/74762-dynamic-database-action-biztalk-2009-a.html)

mithu June 12th, 2009 10:18 AM

Dynamic Database Action in BizTalk 2009
Hi there,

I am very new to BizTalk but my client wanted to done the work with BizTalk.
I have a situation described below:

I have a table name CustAccount in CRM where database and customer name is entered for customer. These customers have database with many tables in CRM and they also have data in another table in another DB outside crm. Now what I have to do is pick a database name from CustAccount and send their data to their tables with Biztalk (with CRM adapter for BizTalk). Note that in CustAccount table database name is entered by human and also create database in CRM. Now Question is:

1)Does BizTalk support this dynamic action? (Picking database name and sending data to that database.)
2)How we can setup schema for a database which is not created yet? I know we can do it with programming.

Please give me as much information possible because I am very new. But I completed some small project with Biztalk without dynamism.

Any help will be highly appreciated

Thanks in advance

oliviajones July 29th, 2013 06:41 AM

Dynamic Database Action in BizTalk 2009
There are two ways for this:

1. Use the WCF adapter to talk to the CRM web-services
2. Write an AIC (application integration component).

In my opinion AIC is better


All times are GMT -4. The time now is 03:19 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.