Source Systems per Generator Configurations

Source Systems per Generator Configurations

The following pictures give an overview of the possible Source Systems for each Generator Configuration for each existing Target Technology:

• Microsoft Fabric Warehouse
• Microsoft Fabric Lakehouse and Azure Synapse
• Databricks
• Snowflake
• Microsoft SQL Server
• Oracle

Microsoft Fabric Warehouse

The possible Source Systems per Generator Configuration for the Microsoft Fabric Warehouse Target Technology are:

• Fabric Warehouse - Data Store
  • Spark (Delta tables): use a Delta files discovery

• Fabric Warehouse - Stage
  • Spark (Delta tables): use a Delta files discovery
• Fabric Warehouse - DataVault
  • Spark (Delta tables): use a Delta files discovery

• Fabric Warehouse - DataVault and Mart
  • Spark (Delta tables): use a Delta files discovery
• Fabric Warehouse - Datamart
  • With a Linked Project only

Microsoft Fabric Lakehouse and Azure Synapse

The possible Source Systems per Generator Configuration for the Microsoft Fabric Lakehouse Target Technology are:

• Fabric Lakehouse - Data Store
  • Spark (Delta tables): use a Delta files discovery
• Fabric Lakehouse - Stage
  • Spark (Delta tables): use a Delta files discovery
• Fabric Lakehouse - Stage Files
  • Parquet
  • Delta files
  • CSV files
• Fabric Lakehouse - Stage JDBC
  • Microsoft SQL Server database
    
  • Oracle database
    
  • PostgreSQL database
    
  • MySQL database
    
  • MariaDB database
• Fabric Lakehouse - Dimensional
  • Spark (Delta tables): use a Delta files discovery
• Fabric Lakehouse - Dimensional and Mart
  • Spark (Delta tables): use a Delta files discovery
• Fabric Lakehouse - DataVault
  • Spark (Delta tables): use a Delta files discovery
• Fabric Lakehouse - DataVault and Mart
  • Spark (Delta tables): use a Delta files discovery
• Fabric Lakehouse - Datamart
  • With a Linked Project only

Databricks

The possible Source Systems per Generator Configuration for the Databricks Target Technology are:

• Databricks - Data Store
  • Databricks Unity Catalog
• Databricks - Stage
  • Databricks Unity Catalog
• Databricks - Stage Files

  • Parquet
    

  • Delta files

  • CSV files
• Databricks - Stage JDBC
  • Microsoft SQL Server database
    
  • Oracle database
    
  • PostgreSQL database
    
  • MySQL database
    
  • MariaDB database
• Databricks - Dimensional
  • Databricks Unity Catalog
• Databricks - Dimensional and Mart
  • Databricks Unity Catalog
• Databricks - DataVault
  • Databricks Unity Catalog
• Databricks - DataVault and Mart
  • Databricks Unity Catalog
• Databricks - Datamart
  • With a Linked Project only

Snowflake

The possible Source Systems per Generator Configuration for the SnowflakeTarget Technology are:

• Snowflake - Data Store
  • Snowflake database
• Snowflake - Stage
  • Snowflake database
• Snowflake - Stage File
  • Parquet
• Snowflake - Dimensional
  • Snowflake database
• Snowflake - Dimensional and Mart
  • Snowflake database
• Snowflake - DataVault
  • Snowflake database
• Snowflake - DataVault and Mart
  • Snowflake database
• Snowflake - Datamart
  • With a Linked Project only

Microsoft SQL Server

The possible Source Systems per Generator Configuration for the Microsoft SQL Server Target Technology are:

• Microsoft SQL Server - Data Store
  • Microsoft SQL Server database
• Microsoft SQL Server - Stage
  • Microsoft SQL Server database
• Microsoft SQL Server - Stage Files
  • CSV files
• Microsoft SQL Server - Stage OpenQuery
  • Microsoft SQL Server database
    
  • Oracle database
    
  • PostgreSQL database
    
  • MySQL database
    
  • MariaDB database
• Microsoft SQL Server - Stage JSON
  • JSON files
• Microsoft SQL Server - Dimensional
  • Microsoft SQL Server database
• Microsoft SQL Server - Dimensional and Mart
  • Microsoft SQL Server database
• Microsoft SQL Server - Datavault
  • Microsoft SQL Server database
• Microsoft SQL Server - DataVault and Mart
  • Microsoft SQL Server database
• Microsoft SQL Server - Datamart
  • With a Linked Project only

Oracle

The possible Source Systems per Generator Configuration for the Oracle Target Technology are:

• Oracle - Data Store
  • Oracle database
• Oracle - Stage
  • Oracle database
• Oracle - DataVault
  • Oracle database
• Oracle - DataVault and Mart
  • Oracle database
• Oracle - Datamart
  • With a Linked Project only

 

To learn more about Generator Configuration, please consult Understand the Generator Configuration.