Article/How To
Author: Matillion
Date Posted: Oct 25, 2023
Last Modified: Oct 25, 2023
Author: Matillion
Date Posted: Oct 25, 2023
Last Modified: Oct 25, 2023
How to Install a Matillion ETL Connector
This article shows how to install a Matillion ETL API Query or API Extract from the Matillion Exchange.
Installing an API Query connector
From the Project menu, follow Manage API Profiles > Manage Query Profiles
In the Manage Query Profiles dialog press the arrow button highlighted above, then browse for the .json file you downloaded and press OK.
Installing an API Extract connector
From the Project menu, follow Manage API Profiles > Manage Extract Profiles
In the Manage Extract Profiles dialog press the arrow button highlighted above, then browse for the .json file you downloaded and press OK.
API Query vs API Extract
Both the API Query component and the API Extract component can be used by Matillion ETL to read data from a REST API. The differences are summarised in this table.
| Property | API Query | API Extract |
|---|---|---|
| Read from | REST API | REST API |
| Write to | Relational table in a CDW | Table in a CDW with semi-structured datatype |
| Staging format | Relational | Semi-structured |
| How to work with the data | Use a Table Input in a Transformation Job | Use an Extract Nested Data component in a Transformation Job |
| Connector exchange format | .json file | .json file |