---
id: "ibm-data-virtualization"
type: "component"
kind: "database-proxy"
provider: "ibm"
category: "data"
docs: "https://cloud.ibm.com/docs/data-virtualization"
url: "https://localhost:3000/catalogue/components/ibm-data-virtualization"
---

# IBM Data Virtualization

Federation layer presenting remote tables as one virtual schema and pushing SQL down to the sources.

| | |
|---|---|
| Provider | [ibm](https://localhost:3000/catalogue?provider=ibm) |
| Kind | [Database proxy](https://localhost:3000/catalogue/kinds/database-proxy) |
| Category | Data |
| Official docs | [https://cloud.ibm.com/docs/data-virtualization](https://cloud.ibm.com/docs/data-virtualization) |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `caching` | boolean | — | no | false | inherited |
| `hedging` (advanced) | boolean | — | no | false | inherited |
| `loadShedding` (advanced) | boolean | — | no | false | inherited |
| `managed` | boolean | — | no | false | **true** |
| `poolSharded` (advanced) | boolean | — | no | false | inherited |
| `pooling` | boolean | — | no | true | inherited |
| `requestCoalescing` (advanced) | boolean | — | no | false | inherited |
| `routing` | enum | `none`, `shard-key`, `lookup` | no | "none" | **"lookup"** |
| `scatterGather` (advanced) | boolean | — | no | false | **true** |

Bold values are the ones this component pins.

## Rules that apply · 0

No rule selects this kind or its category.

## Other products of the same kind · 13

- [Amazon RDS Proxy](https://localhost:3000/catalogue/components/rds-proxy.md) `rds-proxy` — aws
- [Cloudflare Hyperdrive](https://localhost:3000/catalogue/components/cloudflare-hyperdrive.md) `cloudflare-hyperdrive` — cloudflare
- [Generic database proxy](https://localhost:3000/catalogue/components/database-proxy.md) `database-proxy` — default
- [MariaDB MaxScale](https://localhost:3000/catalogue/components/maxscale.md) `maxscale` — default
- [mongos](https://localhost:3000/catalogue/components/mongos.md) `mongos` — default
- [Odyssey](https://localhost:3000/catalogue/components/odyssey.md) `odyssey` — default
- [PgBouncer](https://localhost:3000/catalogue/components/pgbouncer.md) `pgbouncer` — default
- [PgCat](https://localhost:3000/catalogue/components/pgcat.md) `pgcat` — default
- [Pgpool-II](https://localhost:3000/catalogue/components/pgpool.md) `pgpool` — default
- [ProxySQL](https://localhost:3000/catalogue/components/proxysql.md) `proxysql` — default
- [Supavisor](https://localhost:3000/catalogue/components/supavisor.md) `supavisor` — default
- [Vitess](https://localhost:3000/catalogue/components/vitess.md) `vitess` — default
- [Cloud SQL Auth Proxy](https://localhost:3000/catalogue/components/google-cloud-sql-auth-proxy.md) `google-cloud-sql-auth-proxy` — gcp

## Use it in a design

```yaml
nodes:
  - { id: "ibm-data-virtualization", component: "ibm-data-virtualization" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# IBM Data Virtualization (Watson Query): a federation layer that presents tables held in many
# remote sources as one virtual schema and pushes SQL down to them, so no copy is made
# ("Data Virtualization"). It routes rather than stores, and gathers results across sources.
schemaVersion: "1"
type: "component"
id: "ibm-data-virtualization"
kind: "database-proxy"
provider: "ibm"
docs: "https://cloud.ibm.com/docs/data-virtualization"
defaults:
  managed: true
  scatterGather: true
  routing: "lookup"
properties:
  caching:
    type: "boolean"
    default: false
```

Human page: https://localhost:3000/catalogue/components/ibm-data-virtualization