Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Database Action in BizTalk 2006

Status
Not open for further replies.

Mithu33

IS-IT--Management
Jun 12, 2009
1
BD
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.

Thanks in advance
Matheu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top