Does Toad Data Point support Green Plum databases? (4307961)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Does Toad Data Point support Green Plum databases?
Description

Users want to connect to a Greenplum database using Toad Data Point and need to know if the product provides native support or alternative connection methods.
Cause

Toad Data Point does not include a native connector for Greenplum databases, which can lead to confusion when attempting to establish a direct connection.
Resolution
Toad Data Point does not natively support Greenplum databases.

However, a connection may still be possible using an ODBC driver:
1. Install a PostgreSQL-compatible ODBC driver that supports Greenplum.
2. Configure the ODBC data source on the system.
3. In Toad Data Point, create a new connection using ODBC (Generic).
4. Select the configured ODBC data source.
5. Test the connection and verify basic query functionality.
✅ Note:
- This method provides basic connectivity only.
- Advanced features available in native connections may not be supported.
Toad Data Point supports many databases through both native and ODBC connections, but ODBC connections are generally limited to basic querying and may lack features such as metadata browsing, advanced query optimization tools, or database-specific integrations. While Greenplum is based on PostgreSQL, full compatibility is not guaranteed when using generic ODBC drivers, and behavior may vary depending on the driver version and configuration. For a complete list of supported platforms and connection types, refer to the Toad Data Point Release Notes.
Additional Information

Clearly set expectation: no native support Recommend ODBC as best-effort workaround only Validate driver compatibility if issues arise Direct users to Release Notes for supported platforms Not a defect; product limitation

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Does Toad Data Point support Green Plum databases? (4307961)

Title

Description

Cause

Resolution

Additional Information

Leave a Comment