none
SQL Adapter RRS feed

  • Question

  • Hi,

    How to create a dynamic connection string for building a SQL Adapter. The requirement is for creating an SQL Adapter which gets created at the time of execution.
    Thursday, September 10, 2009 6:26 AM

Answers

  • Danish

    did you follow the link in the article? it does go and explain further.

    Basiclly - to use dynamic ports you need to configure your send port as dynamic.
    You then need to set the port address and transport type sometime before sending the message, for exmaple, from the article
    SendPort(Microsoft.XLANGs.BaseTypes.Address)="mssql://sql_server/my_instance/my_database";
    SendPort(Microsoft.XLANGs.BaseTypes.TransportType)="WCF-Custom";

    Last - you need to set any relevant context properties for your chosen transport, on the message being set (when constructed, in an assign shape) , again - the example from the article -

    Request2=Request1;
    Request2(WCF.Action)="TableOp/Insert/dbo/CustomerTable";
    Request2(WCF.BindingType)="sqlBinding";
    Request2(WCF.UserName)="myuser";
    Request2(WCF.Password)="mypass";


    if you are not sure when the action should be - run the wizard and see what it generates for you.

    If you need more information about static send ports in BizTalk have a look at
    http://msdn.microsoft.com/en-us/library/aa578247(BTS.10).aspx
    http://msdn.microsoft.com/en-us/library/aa560663(BTS.10).aspx
    as well as run a search on "BizTalk Dyanmic send port"


    Yossi Dahan http://www.sabratech.co.uk/blogs/yossidahan [To help others please mark replies as answers if you found them helpful]
    Thursday, September 10, 2009 11:09 AM
    Moderator

All replies

  • If you're referring to the new SQL adapter, this will hopfully lead you in the right direction -http://geekswithblogs.net/GaneshKumar/archive/2009/09/03/dynamic-sql-port---new-in-biztalk-2009.aspx


    Yossi Dahan http://www.sabratech.co.uk/blogs/yossidahan [To help others please mark replies as answers if you found them helpful]
    Thursday, September 10, 2009 7:18 AM
    Moderator
  • Hi Yossi,

    The link you suggested seems to be describing what i require but as am just a beginner in BizTalk hence i require a bit more detailed explanation for creating a dynamic SQL Adapter.
    Can you tell me how to and where to include "SQL.ResponseDocumentRootElementName" in orchestration?
    Is it to be written in an expression stage?
    Will it require adding any reference to the project as well?

    Thanks,
    Danish

    Thursday, September 10, 2009 8:53 AM
  • Danish

    did you follow the link in the article? it does go and explain further.

    Basiclly - to use dynamic ports you need to configure your send port as dynamic.
    You then need to set the port address and transport type sometime before sending the message, for exmaple, from the article
    SendPort(Microsoft.XLANGs.BaseTypes.Address)="mssql://sql_server/my_instance/my_database";
    SendPort(Microsoft.XLANGs.BaseTypes.TransportType)="WCF-Custom";

    Last - you need to set any relevant context properties for your chosen transport, on the message being set (when constructed, in an assign shape) , again - the example from the article -

    Request2=Request1;
    Request2(WCF.Action)="TableOp/Insert/dbo/CustomerTable";
    Request2(WCF.BindingType)="sqlBinding";
    Request2(WCF.UserName)="myuser";
    Request2(WCF.Password)="mypass";


    if you are not sure when the action should be - run the wizard and see what it generates for you.

    If you need more information about static send ports in BizTalk have a look at
    http://msdn.microsoft.com/en-us/library/aa578247(BTS.10).aspx
    http://msdn.microsoft.com/en-us/library/aa560663(BTS.10).aspx
    as well as run a search on "BizTalk Dyanmic send port"


    Yossi Dahan http://www.sabratech.co.uk/blogs/yossidahan [To help others please mark replies as answers if you found them helpful]
    Thursday, September 10, 2009 11:09 AM
    Moderator