none
Anybody got a good solution for interacting with Sybase RRS feed

  • Question

  • I need to interact with sybase, is there anyone who has got a good solution for that ?
    Well0549
    Wednesday, June 17, 2009 6:28 AM

Answers

  • Hi,

    We indeed used a sort of simplified adapter. The adapter could only execute stored procedures in sybase. So no direct SQL statements where supported. We did not need that according to our requirements.

    We used a custom tool (much like the sql adapter schema wizard) to generate the schemas for message going to and coming from sybase. The schema contained information about the stored procedure to call, etc...

    This was a custom adapter so it took a lof effort to build and maintain. If you're looking for a short cut this is probably not the way to go. I think I remember there are also some commercial adapters for sybase available. Not sure.....

    Good luck!




    HTH, Randal van Splunteren - http://biztalkmessages.vansplunteren.net - Please mark as answered if this answers your question.
    Thursday, June 18, 2009 7:20 AM
    Moderator

All replies

  • Hi,

    I was involved in a project where we needed to communicate with Sybase. We decided to build a custom adapter. The custom adapter internally used the managed ado .net provide for sybase from datadirect. see: http://www.datadirect.com/products/net/net_for_sybase/index.ssp


    HTH, Randal van Splunteren - http://biztalkmessages.vansplunteren.net - Please mark as answered if this answers your question.
    Wednesday, June 17, 2009 11:23 AM
    Moderator
  • But then you still have to build everything from scratch....

    Generate schema's and stuff....

    I am looking for a shortcut here, I am working in an environment where there are several sybase servers and i need to be able to send & receive data.

    I must be able to run SP's and select statements as wel as insert statements. So a multitude of functionality. Actually i need the SQL adapter for Sybase but i guess that's not going to happen.

    How did you solve this problem, or did you make a simplified adapter.
    Well0549
    Wednesday, June 17, 2009 1:32 PM
  • Hi,

    We indeed used a sort of simplified adapter. The adapter could only execute stored procedures in sybase. So no direct SQL statements where supported. We did not need that according to our requirements.

    We used a custom tool (much like the sql adapter schema wizard) to generate the schemas for message going to and coming from sybase. The schema contained information about the stored procedure to call, etc...

    This was a custom adapter so it took a lof effort to build and maintain. If you're looking for a short cut this is probably not the way to go. I think I remember there are also some commercial adapters for sybase available. Not sure.....

    Good luck!




    HTH, Randal van Splunteren - http://biztalkmessages.vansplunteren.net - Please mark as answered if this answers your question.
    Thursday, June 18, 2009 7:20 AM
    Moderator