Source Connectivity

Multiple connection types, one global registry

MDM Studio ingests from the systems you already run. Every source is defined once in a global registry — shared across all four hub engines, with credentials AES-256 encrypted at rest. These are the connection types available out of the box.

MDM Studio Design Map Govern Trust

Relational databases

SQL
Microsoft SQL ServerOn-prem & self-hosted
PG
PostgreSQLOpen-source RDBMS
My
MySQLOpen-source database
Or
OracleEnterprise database
Td
TeradataEnterprise warehouse

Cloud data platforms

Az
Azure SQLManaged SQL on Azure
Sy
Azure SynapseAnalytics warehouse

Files

CSV
CSVDelimited flat files
XLS
ExcelWorksheets, with chooser

Integration

FTP
FTPFile drop & pickup
API
REST APIJSON / HTTP endpoints

Each connection type supports schema discovery, live data previews and stage-aware field mapping. Databases and cloud platforms stream through pooled connections; files and APIs ride the same pool surface with worksheet choosers and endpoint previews.

How it works

Defined once, available everywhere

One registry, every engineA connection created on one hub engine is adopted automatically by the others at read time — no re-entry, no drift.
Encrypted credentialsEvery secret is AES-256 encrypted at rest and never returned to the browser.
Preview before you mapInspect schemas, sheets and endpoints with live previews, then map fields stage by stage into your model.
Connection types
SQL ServerAzure SQLSynapsePostgreSQLMySQLOracleTeradataCSVExcelFTPREST API
GLOBAL SOURCE REGISTRYencrypted · shared · self-healing
Schema importIngestion jobsMapping designer

Don't see your source?

We add connection types as customers need them. Tell us what you run and we'll show you the fit.

Request a demo info@adaptivecanvas.co.za