The CONNX for Red Brick module provides secure, real-time, read/write access to Red Brick data sources on AIX, OSF1, HP-UX, SCO, Solaris, Unisys, Unix and Windows. This relational database management system was optimized and designed specifically for data warehousing. In conjunction with other CONNX modules, you can perform seamless joins between Red Brick and most other databases.
With CONNX for Red Brick, 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 supports over 600 data types, including BLOBs and CLOBs, and performs bi-directional data conversions for data updates and retrieves.
CONNX for Red Brick 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.