Dynamic database action in BizTalk 2009

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Dynamic database action in BizTalk 2009

Viewing 1 reply thread
  • Author
    Posts
    • #22647

      Normal
      0

      false
      false
      false

      EN-US
      X-NONE
      X-NONE

      MicrosoftInternetExplorer4

      <!–
      /* Font Definitions */
      @font-face
      {font-family:”Cambria Math”;
      panose-1:2 4 5 3 5 4 6 3 2 4;
      mso-font-charset:1;
      mso-generic-font-family:roman;
      mso-font-format:other;
      mso-font-pitch:variable;
      mso-font-signature:0 0 0 0 0 0;}
      @font-face
      {font-family:Calibri;
      panose-1:2 15 5 2 2 2 4 3 2 4;
      mso-font-charset:0;
      mso-generic-font-family:swiss;
      mso-font-pitch:variable;
      mso-font-signature:-1610611985 1073750139 0 0 159 0;}
      /* Style Definitions */
      p.MsoNormal, li.MsoNormal, div.MsoNormal
      {mso-style-unhide:no;
      mso-style-qformat:yes;
      mso-style-parent:””;
      margin-top:0in;
      margin-right:0in;
      mso-margin-bottom-alt:auto;
      margin-left:0in;
      mso-pagination:widow-orphan;
      font-size:11.0pt;
      font-family:”Calibri”,”sans-serif”;
      mso-ascii-font-family:Calibri;
      mso-ascii-theme-font:minor-latin;
      mso-fareast-font-family:Calibri;
      mso-fareast-theme-font:minor-latin;
      mso-hansi-font-family:Calibri;
      mso-hansi-theme-font:minor-latin;
      mso-bidi-font-family:”Times New Roman”;
      mso-bidi-theme-font:minor-bidi;}
      p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
      {mso-style-priority:34;
      mso-style-unhide:no;
      mso-style-qformat:yes;
      margin-top:0in;
      margin-right:0in;
      mso-margin-bottom-alt:auto;
      margin-left:.5in;
      mso-add-space:auto;
      mso-pagination:widow-orphan;
      font-size:11.0pt;
      font-family:”Calibri”,”sans-serif”;
      mso-ascii-font-family:Calibri;
      mso-ascii-theme-font:minor-latin;
      mso-fareast-font-family:Calibri;
      mso-fareast-theme-font:minor-latin;
      mso-hansi-font-family:Calibri;
      mso-hansi-theme-font:minor-latin;
      mso-bidi-font-family:”Times New Roman”;
      mso-bidi-theme-font:minor-bidi;}
      p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst
      {mso-style-priority:34;
      mso-style-unhide:no;
      mso-style-qformat:yes;
      mso-style-type:export-only;
      margin-top:0in;
      margin-right:0in;
      mso-margin-bottom-alt:auto;
      margin-left:.5in;
      mso-add-space:auto;
      mso-pagination:widow-orphan;
      font-size:11.0pt;
      font-family:”Calibri”,”sans-serif”;
      mso-ascii-font-family:Calibri;
      mso-ascii-theme-font:minor-latin;
      mso-fareast-font-family:Calibri;
      mso-fareast-theme-font:minor-latin;
      mso-hansi-font-family:Calibri;
      mso-hansi-theme-font:minor-latin;
      mso-bidi-font-family:”Times New Roman”;
      mso-bidi-theme-font:minor-bidi;}
      p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle
      {mso-style-priority:34;
      mso-style-unhide:no;
      mso-style-qformat:yes;
      mso-style-type:export-only;
      margin-top:0in;
      margin-right:0in;
      mso-margin-bottom-alt:auto;
      margin-left:.5in;
      mso-add-space:auto;
      mso-pagination:widow-orphan;
      font-size:11.0pt;
      font-family:”Calibri”,”sans-serif”;
      mso-ascii-font-family:Calibri;
      mso-ascii-theme-font:minor-latin;
      mso-fareast-font-family:Calibri;
      mso-fareast-theme-font:minor-latin;
      mso-hansi-font-family:Calibri;
      mso-hansi-theme-font:minor-latin;
      mso-bidi-font-family:”Times New Roman”;
      mso-bidi-theme-font:minor-bidi;}
      p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast
      {mso-style-priority:34;
      mso-style-unhide:no;
      mso-style-qformat:yes;
      mso-style-type:export-only;
      margin-top:0in;
      margin-right:0in;
      mso-margin-bottom-alt:auto;
      margin-left:.5in;
      mso-add-space:auto;
      mso-pagination:widow-orphan;
      font-size:11.0pt;
      font-family:”Calibri”,”sans-serif”;
      mso-ascii-font-family:Calibri;
      mso-ascii-theme-font:minor-latin;
      mso-fareast-font-family:Calibri;
      mso-fareast-theme-font:minor-latin;
      mso-hansi-font-family:Calibri;
      mso-hansi-theme-font:minor-latin;
      mso-bidi-font-family:”Times New Roman”;
      mso-bidi-theme-font:minor-bidi;}
      .MsoChpDefault
      {mso-style-type:export-only;
      mso-default-props:yes;
      mso-ascii-font-family:Calibri;
      mso-ascii-theme-font:minor-latin;
      mso-fareast-font-family:Calibri;
      mso-fareast-theme-font:minor-latin;
      mso-hansi-font-family:Calibri;
      mso-hansi-theme-font:minor-latin;
      mso-bidi-font-family:”Times New Roman”;
      mso-bidi-theme-font:minor-bidi;}
      .MsoPapDefault
      {mso-style-type:export-only;
      mso-margin-bottom-alt:auto;}
      @page Section1
      {size:8.5in 11.0in;
      margin:1.0in 1.0in 1.0in 1.0in;
      mso-header-margin:.5in;
      mso-footer-margin:.5in;
      mso-paper-source:0;}
      div.Section1
      {page:Section1;}
      /* List Definitions */
      @list l0
      {mso-list-id:2105803985;
      mso-list-type:hybrid;
      mso-list-template-ids:1426782702 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
      @list l0:level1
      {mso-level-text:”%1\)”;
      mso-level-tab-stop:none;
      mso-level-number-position:left;
      text-indent:-.25in;}
      –>

      /* Style Definitions */
      table.MsoNormalTable
      {mso-style-name:”Table Normal”;
      mso-tstyle-rowband-size:0;
      mso-tstyle-colband-size:0;
      mso-style-noshow:yes;
      mso-style-priority:99;
      mso-style-qformat:yes;
      mso-style-parent:””;
      mso-padding-alt:0in 5.4pt 0in 5.4pt;
      mso-para-margin-top:0in;
      mso-para-margin-right:0in;
      mso-para-margin-bottom:auto;
      mso-para-margin-left:0in;
      mso-pagination:widow-orphan;
      font-size:11.0pt;
      font-family:”Calibri”,”sans-serif”;
      mso-ascii-font-family:Calibri;
      mso-ascii-theme-font:minor-latin;
      mso-hansi-font-family:Calibri;
      mso-hansi-theme-font:minor-latin;}

      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

    • #22693

      Maybe you want to see the book written by Richard Seroter about BizTalk 2009.  You can find it at Amazon (http://www.amazon.com/SOA-Patterns-BizTalk-Server-2009/dp/1847195008)

       

      Also, there is a free chapter about the SQL adapter in 2009 from this book.

      (http://www.packtpub.com/files/soa-patterns-with-biztalk-server-2009-sample-chapter-9-new-soa-capabilities-in-biztalk-server-2009-wcf-sql-server-adapter.pdf)

      • #22699

        Thank you Brunchey, I will try to read through out.

         

        Regards

        Matheu

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.