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

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

Native Target: The target instance is called native in two cases

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

External Target: The target instance is called external in two cases

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

The configuration details corresponding to each target instance are described in following pages:

Working with Flat File Target Instance Transform

Working with DFS Target Instance Transform

Working with Avro Target Instance Transform

Working with Oracle Target Instance Transform

Working with DB2 Target Instance Transform

Working with MSSQL Target Instance Transform

Working with MySQL Target Instance Transform

Working with Salesforce Target Instance Transform

Working with Netezza Target Instance Transform

Working with Teradata Target Instance Transform

Working with Hive Target Instance Transform

Working with Snowflake Target Instance Transform

Working with PostgreSQL Target Instance Transform

Working with BigQuery Target Instance Transform

Working with Splice Machine Target Instance Transform

Working with Thoughtspot Target Instance Transform

Working with Redshift Target Instance Transform

Working with Azure Synapse Target Instance Transform

Working with Parquet File Target Instance Transform