Testing connectivity to Greenplum

Here's a sample way to test:

$ ./odbctest
Registered Data Sources:
Greenplum Wire Protocol (DataDirect 6.0 Greenplum Wire Protocol)
Server Name? greenplum
User ID? gpadmin
Password? password
Detected Data Direct compatibility
Server greenplum conforms to LEVEL 1.
Server's cursor commit behavior: PRESERVE
Transactions supported: ALL

Maximum number of concurrent statements: 0

For a list of tables, use PRINT.

> PRINT
TABLE_SCHEM TABLE_NAME
--------------------------------------------------------------------------------
gp_toolkit __gp_localid
gp_toolkit __gp_log_master_ext
gp_toolkit __gp_log_segment_ext
gp_toolkit __gp_masterid
gp_toolkit gp_disk_free
information_schema sql_features
information_schema sql_implementation_info
information_schema sql_languages
information_schema sql_packages
information_schema sql_parts
information_schema sql_sizing
information_schema sql_sizing_profiles
public customer
public lineitem
public nation
public orders
public part
public partsupp
public region
public supplier
public uac_1_0
public uac_1_1
public uac_1_2
public uac_1_3
public uac_1_4
public unica_snapshot_test
public unica_snapshot_test2
gp_toolkit __gp_fullname
gp_toolkit __gp_is_append_only
gp_toolkit __gp_number_of_segments
gp_toolkit __gp_user_data_tables
gp_toolkit __gp_user_data_tables_readable
gp_toolkit __gp_user_namespaces
gp_toolkit __gp_user_tables
gp_toolkit gp_bloat_diag
gp_toolkit gp_bloat_expected_pages
gp_toolkit gp_locks_on_relation
gp_toolkit gp_locks_on_resqueue
gp_toolkit gp_log_command_timings
gp_toolkit gp_log_database
gp_toolkit gp_log_master_concise
gp_toolkit gp_log_system
gp_toolkit gp_param_settings_seg_value_diffs
gp_toolkit gp_pgdatabase_invalid
gp_toolkit gp_resq_activity
gp_toolkit gp_resq_activity_by_queue
gp_toolkit gp_resq_priority_backend
gp_toolkit gp_resq_priority_statement
gp_toolkit gp_resq_role
gp_toolkit gp_resqueue_status
gp_toolkit gp_roles_assigned
gp_toolkit gp_size_of_all_table_indexes
gp_toolkit gp_size_of_database
gp_toolkit gp_size_of_index
gp_toolkit gp_size_of_partition_and_indexes_disk
gp_toolkit gp_size_of_schema_disk
gp_toolkit gp_size_of_table_and_indexes_disk
gp_toolkit gp_size_of_table_and_indexes_licensing
gp_toolkit gp_size_of_table_disk
gp_toolkit gp_size_of_table_uncompressed
gp_toolkit gp_skew_coefficients
gp_toolkit gp_skew_idle_fractions
gp_toolkit gp_stats_missing
gp_toolkit gp_table_indexes
information_schema _pg_foreign_data_wrappers
information_schema _pg_foreign_servers
information_schema _pg_user_mappings
information_schema administrable_role_authorizations
information_schema applicable_roles
information_schema attributes
information_schema check_constraint_routine_usage
information_schema check_constraints
information_schema column_domain_usage
information_schema column_privileges
information_schema column_udt_usage
information_schema columns
information_schema constraint_column_usage
information_schema constraint_table_usage
information_schema data_type_privileges
information_schema domain_constraints
information_schema domain_udt_usage
information_schema domains
information_schema element_types
information_schema enabled_roles
information_schema foreign_data_wrapper_options
information_schema foreign_data_wrappers
information_schema foreign_server_options
information_schema foreign_servers
information_schema information_schema_catalog_name
information_schema key_column_usage
information_schema parameters
information_schema referential_constraints
information_schema role_column_grants
information_schema role_routine_grants
information_schema role_table_grants
information_schema role_usage_grants
information_schema routine_privileges
information_schema routines
information_schema schemata
information_schema sequences
information_schema table_constraints
information_schema table_privileges
information_schema tables
information_schema triggered_update_columns
information_schema triggers
information_schema usage_privileges
information_schema user_mapping_options
information_schema user_mappings
information_schema view_column_usage
information_schema view_routine_usage
information_schema view_table_usage
information_schema views

112 tables found.

> exit
$