从BizTalk连接到PostgreSQL数据库

从BizTalk连接到PostgreSQL数据库

问题描述:

Hello Experts,

Hello Experts,

我只是在检查是否有任何方法可以从BizTalk连接到PostgreSQL数据库。我们有ODBC和WCF-Custom适配器,但不确定它们是否可以与PostgreSQL数据库一起使用。

I am just checking if there is any way to connect to the PostgreSQL database from the BizTalk. We have ODBC and WCF-Custom adapter but not sure if they will work with the PostgreSQL database.

谢谢

如果你可以建立ODBC连接那么它将适用于大多数这些行动。我从未尝试使用Biztalk适配器进行progresssql连接。你可以做的是在网络或其他任何地方创建你的api然后使用。如果项目预算允许
,那么试着看看dreamfactory。它可以连接到progresssql并将其公开为REST api。它有许多其他数据库连接,文件,ldap等服务,它们将底层平台暴露为RESt apis。
If you can establish ODBC connection then it will work for most of the operations. I have never tried progresssql connection using Biztalk adapter. What you can do is create your apis around that in net or whatever and then use. If the project budget allows then try having a look at dreamfactory . It can connect to progresssql and expose it as REST apis. It has many other db connections, file , ldap etc etc services that exposes underlying platform as RESt apis.