The source instance transform represents the source object that needs to be treated as the source. The source instance transform corresponds to the data object created for a specific type of source system. The extraction SQL or command executed on the source system is generated based on the configuration of the source instance transform. The properties to be configured in the source instance transform depends on the type of the data object used to create the source instance.

The source instance can be either native or external to the data flow. This is determined based on the type of data object used as the source instance and the native type of the data flow. The type of source instance determines how the extraction SQL or command will be generated for execution.

Native Source: The source instance is called native in two cases

  • The data point linked to the source instance and the data flow is same or
  • The data point linked to the source instance and the data flow is of same type and the connection properties defined in the associated data point is same.

External Source: The source instance is called external in two cases

  • The data point linked to the source instance and the data flow are of different type or
  • The data point linked to the source instance and the data flow is of same type and the connection properties defined in the associated data point are different.

The details of configuring source instance transform for each type is detailed in following pages:

Working with Flat File Source Instance Transform

Working with COBOL Source Instance Transform

Working with DFS Source Instance Transform

Working with JSON Source Instance Transform

Working with XML Source Instance Transform

Working with Oracle Source Instance Transform

Working with DB2 Source Instance Transform

Working with MSSQL Source Instance Transform

Working with MySQL Source Instance Transform

Working with Sybase Source Instance Transform

Working with MariaDB Source Instance Transform

Working with ThoughtSpot Source Instance Transform

Working with Web Services Source Instance Transform

Working with Salesforce Source Instance Transform

Working with Netezza Source Instance Transform

Working with Teradata Source Instance Transform

Working with Hive Source Instance Transform

Working with Snowflake Source Instance Transform

Working with PostgreSQL Source Instance Transform

Working with BigQuery Source Instance Transform

Working with Splice Machine Source Instance Transform

Working with Azure Synapse Analytics Source Instance Transform

Working with Redshift Source Instance Transform

Working with SAP HANA Source Instance Transform

Working with Office 365 Source Instance Transform

Working with Parquet File Source Instance Transform

Working with Twitter Source Instance Transform

Working with Facebook Source Instance Transform