The CONNX for PostgreSQL module provides secure, real-time, read/write access to PostgreSQL databases running on any platform, using .NET, OLE DB, ODBC, or JDBC. In conjunction with other CONNX modules, you can perform seamless joins between two or more supported disparate databases.
With CONNX for PostgreSQL, a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable, standards-based framework for information access.
CONNX for PostgreSQL supports the creation of views, which facilitates hiding table relationships from the end user. CONNX views facilitates the creation of heterogeneous joins between multiple disparate databases.
CONNX imports the metadata directly from your PostgreSQL RDBMS. In addition, CONNX and PostgreSQL includes support for stored procedures, and pass through SQL execution.