ETL/ELT and orchestration
Where transformation logic lives.
| Connector | Deployment models |
|---|---|
| dbt | dbt Cloud, or dbt Core via code repository |
| Apache Airflow / Astronomer | Managed (Astronomer, MWAA, Cloud Composer) or self-hosted |
| Informatica | Informatica PowerCenter (on-prem) or IDMC (cloud) |
| SQL Server Integration Services (SSIS) | On-premises (SQL Server) or Azure-SSIS IR |
| Azure Data Factory / Synapse Pipelines | Azure-native ETL/ELT orchestration |
| AWS Glue | Glue Data Catalog, Glue ETL jobs, Glue crawlers |
| Fivetran / Airbyte (metadata access) | Connecting to their metadata, not using them as connectors |
Every connection starts from the pre-engagement checklist and goes through the universal validation protocol before production sign-off.