Question Connect to progress from BizTalk

[bigwill]

Hi all

Is it possible to send messages from a BizTalk Server (version 2013 R2) to an Progress AppServer (Progress version 10.2B) over a TCP/IP connection? Is it possible to use IP and port to connect to the AppServer? We have a BizTalk server on a windows platform, and the AppServer is on a Solaris platform.


If this is not possible, what are our options for sending messages from the BizTalk server to the Progress environment? We basically want to insert a record into a table in a Progress database.

Cheers
Lars E

 

[TheMadDBA]

There isn't a native BizTalk adapter for Progress and I am not sure BizTalk has a generic SQL/ODBC adapter (not MS SQL or Oracle). Progress 10.2B has basic SQL support... certainly enough to do your basic DML and selects.

You could also make a custom biztalk adapter and use the Progress Open Client... it creates classes/dlls for .NET or Java that can talk directly to the Progress Appserver. Keep in mind that the Progress Appserver will not allow you to run freeform queries, just the procedures that are available on that appserver.

https://community.progress.com/comm...164.openedge-10-2b-product-documentation.aspx

 

[KrisM]

The Proxy Generator can generate a webservice for connecting to the AppServer.
Do you think you can work with that ?

 

[TheMadDBA]

That is indeed another option Kris. Here is a KB link that explains the process. Depending on how much Progress experience you have it can anywhere from not too painful to excruciating though

http://knowledgebase.progress.com/articles/Article/P150680