IBM Db2 Warehouse on Cloud

Supported versions

IBM Db2 Warehouse on Cloud 11.1

Supported schema elements and metadata

Dataedo reads the following metadata from IBM Db2 Warehouse on Cloud:

• Tables
  • Columns
    • Data type with length
    • Nullable
    • Default value
  • Primary keys
    • Columns
  • Unique indexes
    • Columns
  • Foreign keys
    • Columns
  • Triggers
    • When triggered
    • Script
• Views
  • Columns (see tables)
  • Script
• Materialized views
  • Columns (see tables)
  • Script
• Procedures
  • Script (for SQL procedures)
  • Parameters
• Functions
  • Script (for SQL procedures)
  • Parameters
  • Returned value

Data profiling

Dataedo does not support data profiling in IBM Db2 Warehouse on Cloud.