API Query and API Extract

The Data Productivity Cloud replaces Matillion ETL's API Query and API Extract with custom connectors, flexible components that can be configured to connect to any compatible third-party API.

---

Migration path

If you have a job that uses API Query or API Extract, the migrated pipeline should be refactored to use custom connectors that will replicate the functionality of your query or extract components.

API Query

1. Recreate the connector as a custom connector.
2. Replace the "Unknown Component" in the migrated pipeline with the new custom connector.

API Extract

You can download the extract profile from Matillion ETL and import it to set up a custom connector. Follow this process:

1. In Matillion ETL, click Project → Manage API Profiles → Manage Extract Profiles.
2. In the Manage Extract Profiles dialog, locate the profile you want to export and click the download icon next to it. This will download the profile as a .json file to your local filesystem (exact location will be browser and operating system dependent).
3. On the Manage Custom Connectors screen, click the drop-down icon next to Add connector, then click Import connector.
4. Select the .json file that you exported your extract profile to, then click Import.
5. Replace the "Unknown Component" in the migrated pipeline with the new custom connector.

Note

Not all paging and source formats are supported in custom connector.