Home› Reference› Entity types› Connector types

Connector types

Connector types define how AnalyticsCreator connects to source systems and external data providers. They determine how metadata is accessed and how source data can be integrated into the generated data warehouse flow.

Use this section to understand the available connector types and choose the appropriate connector for your source technology and integration scenario.

Available connector types

Access

Connector for Microsoft Access source files and databases.

  • Legacy source support
  • File-based database access
  • Useful for smaller existing data stores

Open Access

Azure BLOB

Connector for file-based and object-based sources in Azure Blob Storage.

  • Cloud storage integration
  • Useful for landing and exchange zones
  • Supports Azure-based source scenarios

Open Azure BLOB

CSV

Connector for delimited text file sources.

  • Flat file ingestion
  • Simple structured source format
  • Suitable for exchange files

Open CSV

Direct

Connector type for direct source access scenarios.

  • Direct integration pattern
  • Reduced abstraction layer
  • Useful for specific source access cases

Open Direct

Excel

Connector for Excel-based source files.

  • File-based source access
  • Structured spreadsheet input
  • Useful for departmental data sources

Open Excel

MSSQL

Connector for Microsoft SQL Server sources and metadata import.

  • Relational source access
  • Table and metadata import
  • Common warehouse source type

Open MSSQL

OData

Connector for OData-based service endpoints and API-style data access.

  • Service-oriented integration
  • Useful for API-style sources
  • Supports metadata-driven remote access

Open OData

ODBC

Generic connector based on ODBC driver access.

  • Broad compatibility
  • Useful for many relational systems
  • Driver-based connection model

Open ODBC

OLEDB

Generic connector based on OLE DB provider access.

  • Flexible connectivity option
  • Useful for supported provider-based sources
  • Suitable for heterogeneous environments

Open OLEDB

OLEDB.NET

Connector based on OLE DB .NET provider access.

  • .NET-based provider model
  • Useful for provider-specific integrations
  • Extends connectivity options

Open OLEDB.NET

Oracle

Connector for Oracle-based source systems.

  • Relational source integration
  • Metadata-driven access
  • Suitable for Oracle source landscapes

Open Oracle

SAP

Connector for SAP metadata and source integration scenarios.

  • SAP metadata import
  • Relevant for ERP integration
  • Supports SAP-oriented modeling flows

Open SAP

How to choose a connector type

  • Use MSSQL or Oracle for direct relational database integration
  • Use Excel, CSV, or Access for file-based and desktop data sources
  • Use SAP for SAP-oriented metadata and source integration
  • Use ODBC, OLEDB, or OLEDB.NET for generic provider-based connectivity
  • Use Azure BLOB for cloud storage-based source scenarios
  • Use OData for service-based or API-style access
  • Use Direct when a direct connector pattern is required for the source integration scenario

Key takeaway

Connector types define how AnalyticsCreator accesses metadata and source data across relational databases, files, enterprise systems, cloud storage, and service-based interfaces.