Bulk uploading relationships between attributes and business terms in Ataccama

Hi everyone,

If you’re looking for a way to bulk upload relationships between attributes and business terms in Ataccama, there are two main approaches you can use: Metadata Writer step and GraphQL API. Both methods allow you to establish these relationships efficiently.

Option 1: Metadata Writer

The Metadata Writer method enables you to create relationships between attributes and business terms by structuring your data appropriately. Here’s what you need to do:

1. Entity: Use termInstance as the entity type.
2. Parent ID: This should be the ID of the attribute you want to link.
3. Target: This should be the ID of the business term you want to associate with the attribute.
4. State: Set this value to published to ensure the relationship is active.

Once you’ve prepared a file containing these details, you can upload it using the Metadata Writer, automating the bulk linking process.

Option 2: GraphQL API

Another approach is leveraging the GraphQL API. This involves:

1. Capturing the API requests made when manually attaching terms through the Ataccama UI.
2. Reverse-engineering these API calls to understand the structure and parameters required.
3. Scripting a bulk upload process using these API calls to automate term-to-attribute relationships.

This method provides greater flexibility and can be integrated into existing workflows for automated management of metadata relationships.

Which method should you choose?

• If you prefer a structured file-based approach, the Metadata Writer is straightforward and easy to use.
• If you need a more dynamic, automated solution, the GraphQL API offers greater control and scalability.

Have you tried bulk uploading business term relationships in Ataccama? Share your experience or any challenges you’ve faced in the comments below! 👇