Skip to main content
supports several types of connector, with each performing different processes for different purposes. A connector’s key function is to extract data from a data source and provide it to other Matillion processes. When creating data pipelines, you can connect to any data source that supports REST API using one of Matillion’s pre-built connectors, or by creating your own custom connector. Visit Connect to any source to review all the connectors Matillion offers.

​
Connector components

Connector components query data from a specific source and load that data into a table in a data warehouse. They are available in ‘s orchestration pipelines and so can be used as part of larger data workflows including complex transformations.

​
Custom connectors

You can create your own connectors based on any REST API that returns JSON data by using the Custom Connector interface. These custom connectors can then be brought into or Data Loader to build pipelines. You will require access and knowledge of the target API to create these.

​
Custom connector video example

Expand this box to watch our video about using custom connectors.

​
Flex connectors

Flex connectors are pre-configured connectors available directly in orchestration pipelines in , and from Data Loader’s Batch data sources list. Flex connectors can be edited in the Custom Connector interface for further customization, such as adding additional endpoints, if required.

​
Flex connector video example

Expand this box to watch our video about using Flex connectors.

​
Query connectors

Query connectors are used to retrieve data from your chosen source using an SQL-like query. When configuring these connectors, you can choose between Basic mode and Advanced mode. Basic mode will build a query for you based on the options you choose in the component properties, while Advanced mode lets you write the query yourself.

​
Query connector video example

Expand this box to watch our video about using Query connectors.

​
Streaming connectors

Streaming connectors are built for use in streaming pipelines. They allow you to capture data from a source database so you can then write it to cloud storage or a data warehouse.

​
Streaming connector video example

Expand this box to watch our video about using the Microsoft SQL Server streaming connector.