IBM Db2 Warehouse support

Supported versions

IBM Db2 Warehouse 11

Supported schema elements and metadata

Dataedo reads following metadata from IBM Db2 Warehouse:

• Tables
  • Columns
    • Data type with length
    • Nullable
    • Default value
  • Primary keys
    • Columns
  • Unique indexes
    • Column
  • 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

Datedo does not support data profiling in IBM Db2 Warehouse .