Alation Integration APIs
To integrate Alation with Telmai, you'll use a set of REST API endpoints to manage the connection, automatically or manually create data mappings, and perform other configuration tasks. These API calls enable Telmai to interact with your Alation data catalog for seamless data governance.
Setup
These endpoints allow you to configure, retrieve, and remove the core Alation integration with Telmai. All requests require your backend_service_host and tenant identifier.
Add or Update Integration
Use this endpoint to establish the connection between Telmai and Alation or to update an existing one. You'll need your Alation URL, a user ID, and a refresh API token.
PUT{backend_service_host}/{tenant}/configuration/integrations/alationRequest Body:
JSON
{ "url": "https://dq-partner.mtse.alationcloud.com/", "user_id": 81, "refresh_api_token": "xxxxxx..." }Response:
JSON
{ "url": "https://dq-partner.mtse.alationcloud.com/", "user_id": 81 }
Get Integration Properties
Retrieve the current configuration details for your Alation integration. This call doesn't require a request body.
GET{backend_service_host}/{tenant}/configuration/integrations/alationResponse:
JSON
{ "url": "https://dq-partner.mtse.alationcloud.com/", "user_id": 81 }
Remove Integration
Permanently delete the Alation integration from your Telmai environment.
DELETE{backend_service_host}/{tenant}/configuration/integrations/alationResponse:
JSON
{ "message": "Alation integration configuration deleted successfully" }
Mappings
These endpoints handle the creation and management of mappings, which link Telmai data assets to specific tables in your Alation data catalog.
Start Automatic Mappings
This endpoint initiates a background job to automatically create mappings for your assets. You can optionally choose to overwrite existing mappings.
POST{backend_service_host}/{tenant}/configuration/mappings/alation/autoRequest Parameters:
should_overwrite:trueorfalse(default isfalse).
Response:
JSON
{ "message": "Creating Alation mappings started", "job_id": "f583cea0-640d-4c50-9153-e187f92a982e" }The response provides a
job_idthat you can use to track the status of the mapping job.
Get Mapping Job Result
Check the status and results of an ongoing or completed automatic mapping job using its job_id.
GET{backend_service_host}/{tenant}/configuration/mappings/alation/autoRequest Parameters:
job_id: Thejob_idfrom the automatic mapping request.
Response:
JSON
{ "status": "COMPLETED", // Can also be IN_PROGRESS or FAILED "error_message": null, "result": [ { "asset_id": "35xftecujtsjd", "data_source_id": 251, "data_source_name": "telmai_datasource", "schema_id": 46, "schema_name": "adventureworks.SalesLT", "table_id": 6121, "table_name": "CustomerAddress" }, ... ] }
List All Mappings
Retrieve a list of all existing Alation mappings configured in Telmai.
GET{backend_service_host}/{tenant}/configuration/mappings/alationResponse:
JSON
[ { "asset_id": "35xftecujtsjd", "data_source_id": 251, "data_source_name": "telmai_datasource", "schema_id": 46, "schema_name": "adventureworks.SalesLT", "table_id": 6121, "table_name": "CustomerAddress" }, ... ]
Delete a Mapping
Remove a specific mapping by providing its Telmai asset ID.
DELETE{backend_service_host}/{tenant}/configuration/mappings/alationRequest Parameters:
asset_id: The ID of the Telmai asset to unmap.
Response:
JSON
{ "message": "Alation mapping deleted successfully" }
Create a New Mapping Manually
Manually create a new mapping between a Telmai asset and an Alation table. You must provide the Telmai asset ID and the Alation table ID.
POST{backend_service_host}/{tenant}/configuration/mappings/alationRequest Body:
JSON
{ "asset_id": "35xftecujtsjd", "alation_table_id": 6121 }Response:
JSON
{ "asset_id": "35xftecujtsjd", "data_source_id": 251, "data_source_name": "telmai_datasource", "schema_id": 46, "schema_name": "adventureworks.SalesLT", "table_id": 6121, "table_name": "CustomerAddress" }
Last updated