Skip to content

Data integration connectors reference

A Qlik Talend Data Integration data connection refers to a connection established to a source or target data service, which can be used for building data integration projects.

You can use the Data Connections, Data Sources, and Data Credentials APIs to programmatically create and manage data connections for data integration projects. To do this, you must reference the correct dataSourceId value for each connector type.

This reference lists all supported data integration connectors and their corresponding identifiers.

Understanding connector types

Data integration supports two types of connectors:

  • Source connectors (repsrc_ prefix): Extract data from source systems
  • Target connectors (reptgt_ prefix): Load data into target systems

Some systems (such as Microsoft SQL Server and MySQL) have both source and target connector variants to support different use cases.

Supported connectors

Use the dataSourceId values from this table when creating data connections for Data Integration projects via the APIs.

Sources

ConnectordataSourceIdType
IBM DB2 for iSeriesrepsrc_db2iseriesSource
IBM DB2 for LUWrepsrc_db2luwSource
IBM DB2 for z/OSrepsrc_db2zosSource
Microsoft SQL Server (log based)repsrc_mssqlSource
Microsoft SQL Server (Microsoft CDC based)repsrc_azuresqlmscdcSource
MySQL (source)repsrc_mysqlSource
Oracle (source)repsrc_oracleSource
PostgreSQL (source)repsrc_postgresqlSource
SAP Application Serverrepsrc_sapdbapplicationSource
SAP Extractorrepsrc_sapextractorSource
SAP HANA (Database)repsrc_saphanaSource
SAP ODPrepsrc_sapodpSource

Targets

ConnectordataSourceIdType
Amazon Redshiftreptgt_qdiredshiftTarget
Amazon S3reptgt_qdis3Target
Azure Data Lake Storagereptgt_qdiadlsTarget
Azure Synapse Analyticsreptgt_qdisynapseTarget
Databricksreptgt_qdidatabricksTarget
Google BigQueryreptgt_qdibigqueryTarget
Google Cloud Storagereptgt_qdigooglecloudstorageTarget
Microsoft Fabricreptgt_qdimicrosoftfabricTarget
Microsoft SQL Serverreptgt_mssqltargetTarget
MySQL (target)reptgt_qdimysqlTarget
Oracle (target)reptgt_qdioracleTarget
PostgreSQL (target)reptgt_qdipostgresqlTarget
Snowflakereptgt_qdisnowflakeTarget

Using dataSourceId in API calls

When creating a data connection for a data integration project, pass the dataSourceId to the Data Connections API:

Terminal window
curl -X POST "https://<TENANT>/api/v1/data-connections" ^
-H "Authorization: Bearer {access_token}" ^
-H "Content-Type: application/json" ^
-d "{
\"dataSourceId\": \"<DATA_SOURCE_ID>\",
\"qName\": \"<CONNECTION_NAME>\",
\"space\": \"<SPACE_ID>\",
\"connectionProperties\": {
// Connector-specific properties here
}
}"
Use only documented connectors

Although other connectors may be available, only the ones documented on this page should be used with data integration projects.

Was this page helpful?